Search results for query: *

I am preparing a table for export to fixed with ASCII file and need to automatically change a table field property from number to text. I have tried macros and update queries but have been unsuccessful. I prefer using macros and queries to code because I'm not that good with VB. Any...

Make sure the field has a unique index.

I have had to add dummy text fields to contain zeros and using them for the leading zeros. I then run a macro that runs a series of update queries to put the correct number of zeros into the column. update to: 00000 criteria - between 10 and 99 update: 0000 criteria - between 100 and 999 etc.

Splitting the database with both FE and BE on the network is not so outrageous. I have made tweaks and changes to a similar system for 2.5 years. I would have to recopy the FE to 75 machines in 3 buildings over 2 miles every time I made a change to the front end. Any network/access experts? It...

Thanks, I didn't see that before.

I need to convert Access date fields to yyyymmdd to export to a text field. I can change the format but when I export to text, it goes back to mm/dd/yy. Any suggestions?

The secret (without programming) is in the query. Link the two tables with the common field. Use the foreign key in the grid instead of the primary key. Run and test the query by entering an existing customer number into this field. The other fields should fill in. Create the form using this...

There is a problem in your relationships somewhere. Most likely there is a Primary Key or a foreign key field that is not in the grid and should be, especially if you have are using an autonumber. A way out of the mess is to rebuild your query one step at a time. Test the steps as you go along...

This is WEIRD. When I click on the Sorting and Grouping button in Access 97 Report Design: 1) the main design window loses the focus (title bar goes from blue to gray), 2) the status bar shows "Press F6 to switch panes", 3) BUT THE WINDOW DOESN'T SHOW UP ANYWHERE! Has this ever...

This is weird. When I put in a commercial cd-rom with autorun (like an AOL disk) it starts up perfectly. However, when I try to access the cd from RUN or My Computer or Windows Explore, I get the message about the drive is not ready. No matter how many times I hit the retry key, it still does...

I cannot verify this, but I read that Access is designed for peak efficiency at 100,000 records.

Build the report from a query. Change the