I'm am running a couple of querys, to append data to 2 different tables (depend on result of query) if OK.value = -1 then that data goes to OKrecords table if Error.value = -1 then that data goes to Errorrecords table. That works fine the problem comes when I try and delete the data from then Checkrecord table. Once I have run the above queries I then run the Delete query, so I am not searching on data already checked, Access will run the query and then dump me out of the program ?? I have checked and I don't ask Access to Quit when I finsh running the queries Please Help
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!
Running a delete query dumps me out
- Thread starter Newuser26
- Start date
Is this a VB6 question or an Access VBA question
If it is a VB6 question can you show us some relevant code. faq222-2244 gives guidance on forum usage
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
As this forum is specifically for VB6 programs that interface with Microsoft databases, you'll get better answers to VBA questions in one of the many Access forums. Check out forum702, forum705 and forum707 to see which best suits.Newuser26 said:
If it is a VB6 question can you show us some relevant code. faq222-2244 gives guidance on forum usage
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Thread starter
- #3
Andy,
If you check OP's profile you will see he moved this question (as suggested) to thread702-1248743
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
If you check OP's profile you will see he moved this question (as suggested) to thread702-1248743
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Status
