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!

  • Congratulations Chriss Miller 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. PinnacleDan

    Last inserted record not found

    I hope I am in the right forum. I have a VB program that first clears an Access table. Then, using a recordset opened to another database, inserts several records into it. Set WK = CreateWorkspace("", "admin", "", dbUseJet) Set DB2 = WK.OpenDatabase(MasterFile) SQL = "Delete * From Materials "...
  2. PinnacleDan

    Last inserted record not found

    I was transfered to this forum and hope I am in the right category. I have a VB program that clears an Access table then, in a loop, inserts several records into it. Set WK = CreateWorkspace("", "admin", "", dbUseJet) Set DB2 = WK.OpenDatabase(MasterFile) SQL = "Delete * From Materials "...
  3. PinnacleDan

    Last inserted record not found

    I am new to this forum and hope I am in the right category. I have a program that clears an Access table then, in a loop, inserts several records into it. SQL="Insert Into Materials (JobCode, Item)" SQL=SQL & "Values ('" & CurJob & "','" & CurItem & "')" DB2.Execute SQL...

Part and Inventory Search

Back
Top