Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BLPandAJF
  • Content: Threads
  • Order by date
  1. BLPandAJF

    Automate an append query based on dates

    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)...
  2. BLPandAJF

    Exit Access after Compacting (at night by macro)

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

    Including last date/time a macro was run on a switchboard

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

    Parameter query..multiple criteria..AND....multiple fields...Access 97

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

Part and Inventory Search

Back
Top