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 SkipVought 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: *

  1. sshah254

    Error Linking to SQL Table

    I have seen this as a problem with Access and ODBC connectivity. Try to connect to the same tables via Excel and you will not see the #DELETED# error. Some of the problems that we have to live with in the "MicroSoft" world. Sandip shahs@microdental.com
  2. sshah254

    Add Sum Column to table

    Inspite of the above warnings, if you still want to do what you asked for, then use the docmd.runsql "Alter Table TableName Add Column ColumnName Double;" and Docmd.Runsql "Update TableName Set ColumnName = ...;" Sandip shahs@Microdental.com
  3. sshah254

    HELP - HELP - HELP!!!!!!

    Since this was a working database and has stopped working, it implies that something outside the database changed. I would check the references section (open the module (the code on the form in this case) that has the code -- then Tools and References). It seems like something got updated on...
  4. sshah254

    Need help with inefficient coding

    I think that the best option is to link the tables and run update queries. If you are going to be somehow linking and updating all the 22 databases, then you a. Create all the links and keep them b. Create the links on the fly, update the databases and then delete the links. This does not...
  5. sshah254

    Scheduling Access97 to start and run macro

    There is a command line switch "/x:MacroName" that you can use to start a particular macro on loading. Of course there is also the Autoexec Macro. Sandip shahs@microdental.com

Part and Inventory Search

Back
Top