Search results for query: *

Hi- I am trying to add a dreary task to a macro and I'm stuck... In my Access 97 database, there are 10 or so tables which get refreshed (from an inventory mgmt. package) every few days. I need to append data related to new information only (from ORDER TABLE)to a separate table (HOLD STATUS)...

Hi- I have a macro launched at night which deletes/appends lots of different tables and then the database is compacted. After the database is compacted, the switchboard is displayed (per the Startup options). I need to quit Access as the last step in the process but if I add this command to...

I have some similar forms and queries. They way I accomplished this was as follows: My forms have an unbound text box for users to input criteria (for your example, product). The criteria for the field product in the underlying query is as follows: Like Form!(form name)!(unbound text box...

Hi -<br><br>I was able to get my switchboard to display the last time a particular macro was run by a long, round-about process.&nbsp;&nbsp;I'm thinking there must be an easier way.<br><br>The way I did it was to create a table called Last Update with one record (Date).&nbsp;&nbsp;Then I created...

I tried both suggestions but I am still unable to get all the results I need.<br><br>Zelandakh, your suggestion worked great as an &quot;OR&quot; criteria but when I tried to make it into an &quot;AND&quot; criteria, it didn't work.&nbsp;&nbsp;Any other ideas?

Hi -<br><br>A simplified version of my challenge is this...<br><br>I want to use a parameter query to select records that match two different Field2/Field 3 criteria.<br><br>Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field3<br>lot...