Search results for query: *

You will need to use code to calculate this. We will need some additional information. 1) Are the acounting periods the same each year? If so we can hard code them in else we should set up a table for them. 2) Need to know the starting date and ending date for each accounting period. There...

First I don’t think you can do what you want to do with a “Query”. You could do with a Function. You did not give detailed table and field so develop specific code could not be but here is the basic out line. I am not an expert and coding so some syntax may be cause error messages. 1) You will...

Name order Name Order Name1 Order1 Name1 Order1 Name1 Order2 Name1 Order2 Name1 Order3 Name1 Order3 Name2 Order1 Name2 Order1 Name3 Order1 Name3 Order1 Name3 Order2 Name3 Order2 Try using the Left() and Right() Excel Functions to seperate your data on your...

When you link two databases, you actually link the data tables. The front end does not contain a copy of the tables. The front end only contains links to the tables in the backend database. The data is not imported into the front end.

Use TransferSpreadsheet macro action, or VBA code's DoCmd.TransferSpreadsheet method.

You can use the runing sum by employee by adding a grouping by employee. Put the employee name and sum fields in the title section and hide the detail section.

Try creating a blank table with all the fields including the autonumber field and appending the data to the table?

I forgot say to put this code in a DOS .bat file. Then schdule this the.bat file to run with Windows Schedular.

To use Windows schedular you must a command line like below: START c:\"Program Files"\"Microsoft Office"\Office11\Msaccess.exe c:\AC\admin200.mdb /excl /x mac_Update There are three parts: 1) Start Access: START c:\"Program Files"\"Microsoft Office"\Office11\Msaccess.exe 2) Open your data...

Change the Index property of the Record Number in table B to "Yes (No Duplicates)". This will prevent duplicate records from being added.

I think we figured out what happened. We have not installed Service Pack 3 yet. Our IT folks have some problems with it. But they installed what I think is the fix to Service Pack 3 to fix the missing data problem it caused. We tested a new computer without this file installed and the combo box...

Thanks for your tips. I did a separate message to redefine the problem and hopefully get additional more pertinent replies.

The combo box has been working correctly for about 2 years. Now the scroll bar works and you can select an item but cannot see the list of items. When you select an item, it appears in the Combo box. The Combo box is based on a table. I created a new combo box based on a query from the table...

Thank you for your suggestions. I decompiled the database and moved the code to the after update action field. Now what I find is the data is on the drop down list but you cannot see it. When you select an item it appears in the combo box. I checked the fore ground and backgroud colors and they...

I commented the "cboBuno.Value = Null" out. And the problem still exists. Any other ideas.

This is an inspection record form. I use three combo boxes to get the model, vehicle number and part number for the inspection. The vehicle number is where the problem is occurring. When the form opens a model number is selected in Program combo box. The code listed below is in the On Change...

can one user update a record while another user views it? I am using SQL server as my database. This is my first time deisgning an application with access/VBA and I am trying to find the easiest way. Depends on the record locking you set up. Do I have to have everything unbound or can I bound...

Thanks for your suggestion Remou. I decided to take your suggestion and incorporate in the Access query definition. I linked the spreadsheet and added it to the query without linking it to the other tables. The definition looked like this: CSIPart: IIf([PART_NUMBER] Like '*' & [CSI Parts...

Linking the table is easy. The part I could use help on is matching the part numbers, from the spreadsheet, with a substring of the part number field in the database table.

One table in my database has information I down load from a mainframe database on manufacturing information. A field named “Part Number” has part numbers but also contains codes for the manufacturer and other junk. There is no fixed length or layout for this information. My user has a list of...