Recent content by tsman

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...

What line in the code is being highlighted.  Can you show and example?

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,&nbsp;&nbsp;Reading a table in code is using recordsets.<br><br>JARE:&nbsp;&nbsp;I am using Access 97 and cannot seem to find a good resource for the Windows 95 menus used in acMenuVer70.&nbsp;&nbsp;Do you have a list or a resource I can visit?&nbsp;&nbsp;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).&nbsp;&nbsp;I will try the copy paste.&nbsp;&nbsp;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.&nbsp;&nbsp;You should use code to run the queries and not macro's.&nbsp;&nbsp;Some macro actions will allow the next one to run immediately.&nbsp;&nbsp;This can cause the header file purge to begin before the others have ended.&nbsp;&nbsp;If you use code this will...

Most of the time the error problems are due to poor data file relationships.&nbsp;&nbsp;How may tables are in the data file database?&nbsp;&nbsp;Why are you not purging old data?&nbsp;&nbsp;Do you compact the data on a regular basis.&nbsp;&nbsp;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.&nbsp;&nbsp;I cannot find any way to do this.&nbsp;&nbsp;I ended up writing some append queries to do the trick.&nbsp;&nbsp;This is awkward for what I am doing.&nbsp;&nbsp;Please help!!!