Threads Replies Last Post 225 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>   Function to calculate yearly billing amount I am trying to calculate a year charge amount for each year between two dates. I have the following data: ID 1 Tot_BillingAmt $198,810.25 StartDate 01/01/2001 StopDate 12/31/2001 MonthsBetween* 12 MonthAmt* $16,567.52 ID 2 Tot_BillingAmt $18,500.00 StartDate ... 6 01.09.2006 18:09:03 Fill Listbox with recordset Project VBA Hi, I have retreived a recordsed from an SQL ODBC driver and want to fill my listbox with those records. I want to be able to retreive a value from the list whilst displaying a text description. Can anyone help ? ... 2 01.09.2006 17:18:01 DoCmd.openForm Condition Type Mismatch I am using: DoCmd.OpenForm "Contacts", , , "LastName = '" & Me!List & "'" And "CompanyName = '" & Me!List & "'" on an update for a list box. It worked fine for just the last name, but I get the first record encountered when there are duplicates. I wanted to add the CompanyName and I get a type Mismatch but it is the same type as the last name. Any help is greatly appreciated. Ken... 3 01.09.2006 17:09:02 Filling Screen with Application Does anyone know what's going on here: I wish to fill the display screen with the contents of a form. The form's on-load event populates an ActiveX control that produces a grid of data. Ths uses some 75 lines of code. I then use the following lines to firstly expand the Access window to fill the screen, then expand the form to fill the window. DoCmd.Maximize Application.RunCommand ... 2 01.09.2006 16:50:12 hide access builtin menu and tolbars Hi all, I would Like to know how to programmatically hide all access builtin Menu and Toolbars Thanks... 2 01.09.2006 16:47:22 Adding user name to records modified in Access How would I add a user name or initials to records added, deleted or edited in an Access database? I can record the date and time but I will need to know which user modified records. Thanking you in advance,... 4 01.09.2006 16:44:55 Object Not Supported FOr This Type Of Object Dim Td1 As TableDef Dim QD1 As QueryDef Dim NewRule As Long Dim ListCriteria As Variant Dim RS3 As Recordset Set db = CurrentDb() Set Td1 = db.TableDefs!tblListItems Set RS3 = Td1.OpenRecordset Please..can some one help, This piece of code is meant to delete an item from a table called tblListItems dependant on the value of ListOfItems (ListBox) It used to work...Now I keep o... 3 01.09.2006 16:37:21 How to dispay multiple columns for a field? I have a listbox in the header of a report. When there are too many rows to list in a single column, I would like them to flow into adjacent columns -- like text in Word when newspaper-style columns are in effect. If the header were limited to 3 rows of output, it would look like this: _________________________ row1 row4 row7 row2 row5 row8 row3 row6 row9 ...... 4 01.09.2006 16:31:37 Attaching files to a specific record I have Access 2003 and am storing application info for my company. I would like to scan a resume and attach a path to this resume for each record in my database. How would I set up a way to store this file path by clicking a button and also retrieve the path by clicking a different button. Any help is appreciated. Thanks Nick ... 3 01.09.2006 14:51:02 Data import from Kaikei ? Hi there.. We got a japanese Software from one of our customers. It's name is Kaikei.. the only problem with it is, that no one knows something about it. No im trying to import the date from kaikei to my access database but it doesnt work. Does someone have experience with this software? or does someone have heared something about this software, how it works.. or something else? R... 2 01.09.2006 13:39:01 Multiuser local and server tables I'm in the process of trying to convert an Access database that is currently being used by 3 people into one that can be used by more than 20 people. The report that is created uses linked SQL Server stored procedures and two SQL Server Tables that are linked to the Stored procedures. The two tables are used for the user input. One holds account numbers and the other holds the month and ... 3 01.09.2006 13:27:49 Filesearch I am using the followin code to fill a comboBox with the names of csv files found in a folder. I use the comboBox to select a file to transfer into a table. After desplaying the data in the file and saving it into other tables, i delete the original file with the Kill function. I then set the combobox rowsource to "" and call this procedure again. The problem is that the file.csv tha... 3 01.09.2006 13:10:02 Validation Controls before Closing DB I have several working tables that I want to ensure are empty before closing the DB. I can currently enable or disable the DB exit process, and want to install these checks before enabling the close and quit functions of the DB. Is there a way to easily code this?... 7 01.09.2006 13:04:04 Duplicates in an Access Table that don't show up until ADD is clic and, if possible show the record with the duplicate number. I have a basic table that has a field called ANumber that restricts duplicates. However in the form, it doesn't tell us it is a duplicate until we hit the ADD button at the bottom of the form after ALL the data has been entered. How can I tell it to let the person entering know it is a duplicate as soon as the number has been... 39 01.09.2006 13:00:12 How do I generate a random number in Access 2003? I have a need to randomly select a record from a related table and need to know how to generate a random number in Access so that I can accomplish this task. Is there a mathematical function in VBA that can be used, for example?... 5 01.09.2006 12:25:29 Data import from Kaikei ? Hi there.. We got a japanese Software from one of our customers. It's name is Kaikei.. the only problem with it is, that no one knows something about it. No im trying to import the date from kaikei to my access database but it doesnt work. Does someone have experience with this software? or does someone have heared something about this software, how it works.. or something else? R... 1 01.09.2006 09:44:37 Create windows directories structure from Access Hi, I need some help. Is there a way to create directories structure on local or network drive directly from Access? Thanks... 5 01.09.2006 09:04:25 The Command or Action "saverecord" isn't available Hi, I have a form in which the user enters information about a new client. this then has a close command button which asks the user if they want to save the dirty record. I was using the docmd.DoMenuItem to svae the record howver this brought about troubles as i had ver70( or whatever it is) as the last argument however when I came to use this on 2000(Which some users have) it kicked ... 1 01.09.2006 08:45:01 A quick bit of help required VBA I have an "after update" event that checks the option chosen in a pop-up form with the information in a field on the main form. If the department is wrong it brings up a message. If it is correct it would then set focus on the next textbox. My problem is that the first line doesn't work even if the two fields match. What is wrong? If Me.dept <> Forms.employee.dept Then MsgBox ... 6 01.09.2006 08:06:02 can query link with another table?? hola.. i have make a query for a table in my database..but..i need to add field from another table to that query..can i???can anyone help me??? ... 3 01.09.2006 06:15:40 Customer Relationship Management (CRM) Guide Customer Relationship Management (CRM) Guide CRM Basics,CRM Objectives,CRM Types :: Operational CRM , Analytical CRM ,Collaborative CRM, CRM Implementation ,CRM Technical Functionalities ,Popular CRM's :: SugarCRM ,vTiger CRM , Daffodil CRM ,Future of CRM http://flying-rugs.com/crm/CRM.html ... 1 01.09.2006 05:49:43 how to apply a filter when a subform loads? I have a form with 2 subforms. The current record in subform1 determines the filter applied to subform2. However, if I can't get subform2 to display filtered data when the main form loads, because the statement Me.Parent.subfrmKitComps.Form.Filter = "KitItem = '" & StrCurrentKit & "'" produces the error Run-time error 2455: "You entered an expression that has an invalid refer... 3 01.09.2006 02:28:01 please help to view pdf files in Access forms i am developing a access database which can able to view the pdf files in the forms. please suggest how to to this.is there a need to add activeX control? ... 8 01.09.2006 01:43:01 Access version, pre-XP In either Access XP or Access 2003, the VBA Application.version property will return the currently running version (10.0 or 11.0, respectively). How do you retrieve the version from Access 97 or Access 2000 (8.0 or 9.0, respectively)? Thanks Vern Rabe... 3 31.08.2006 22:49:02 create new blank database by VBA code Hi all, Is it possible to create a new blank database with all table structures and relationships by VBA code? My new task is to create a button "create new database" , when the user click that button, user will prompt to open directory, type the file name with defaut .mdb, when click ok from dialog file and new database was create + all tables structures + table relationships (no da... 6 31.08.2006 22:01:02 225 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>