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 bkrike 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: PinnacleDan
- Content: Threads
- Order by date
-
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 "...- PinnacleDan
- Thread
- Replies: 11
- Forum: Visual Basic (Classic)
-
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 "...- PinnacleDan
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- PinnacleDan
- Thread
- Replies: 3
- Forum: Microsoft: ActiveX
