By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

update query error

P: 68
I have an update query that runs from an option group. I added another option and the update query for that option. This query is the same as another option so I copied it from the existing option. When this option runs I get an error message:
"The Microsoft Jet database engine cannot find the input table or query ". Make sure that it exists and that its name is spelled correctly."
The exact same query runs fine in the other option.
Here is my code:

Expand|Select|Wrap|Line Numbers
  1. Dim CapStock As String         'set InService to False
  3.                 CapStock = _
  4.                     "UPDATE tblTires " & _
  5.                         "SET tblTires.InService = False " & _
  6.                         "WHERE (((tblTires.TireID)= " & intOldTire & "));"
  8.                 CurrentDb.Execute RemoveToStock, dbFailOnError
Is there something that I'm missing?
Sep 23 '13 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,610
Shouldn't Line# 8 be:
Expand|Select|Wrap|Line Numbers
  1. CurrentDb.Execute CapStock, dbFailOnError 
Sep 23 '13 #2

P: 68
Yes that was it!
Sep 23 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.