If you are using MS Access 97 or later, do the following:
1. Menu Tools; "Analyze", "Documenter".
2. Select all of the objects and options that you want to document, then press OK to docuemnt.
3. Once you see the preview, select menu File; "Save As Table". This...
Another way to see this is to design a Query. Join the 2 tables together and double click the join line. Change it to select all from table 1 and only matching from table 2. then on the field selection select all fields you need from table 1 and only the key from...
MichaelRed: I have a response time issue here. Doing all that you mentioned adds too much overhead to the processing. It is working using append queries, I just don't like having to define every field in the query since the table structure could change and then...
WP: Yes, Reading a table in code is using recordsets.<br><br>JARE: I am using Access 97 and cannot seem to find a good resource for the Windows 95 menus used in acMenuVer70. Do you have a list or a resource I can visit? Help text does not help in this...
SQL will not work since I do not want to define every field (56 fields in just one of the tables). I will try the copy paste. I do not know how this works when the records is being read in code not from the form.<br><br>JARE: Will this work my way or is a form required for...
I agree somewhat with Robertd. You should use code to run the queries and not macro's. Some macro actions will allow the next one to run immediately. This can cause the header file purge to begin before the others have ended. If you use code this will...
Most of the time the error problems are due to poor data file relationships. How may tables are in the data file database? Why are you not purging old data? Do you compact the data on a regular basis. Do your users access the data through tables or...
I have a record that I want to duplicate using code and only change the key. I cannot find any way to do this. I ended up writing some append queries to do the trick. This is awkward for what I am doing. Please help!!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.