strSQL (1 Viewer)
- Thread starter PWG
- Start date
- Local time
- Yesterday, 23:38
- Joined
- Oct 29, 2018
- Messages
- 21,447
Hi. Since I can't see your computer screen and I don't know what you're trying to do, I don't understand your problem. If you're getting an error message, can you post the error message? It might also help if you could post a screenshot of what you're seeing. Is this a database you created?
It was the northwind data base I have been changing it to meet my needs. I no longer have a customer it is now a machine table. The Customer Extended Query is now a machine extended Query. I have been able to change every thing so far to get it to work but this one has be stumped.
I dont know how to attach a screen shot this is what it says
The Microsoft Access database engine cannot find the input table or query
'Customer Extended" Make sure it exists and that its name is spelled correctly.(3078)
strSQL='SELECT*FROM [Customer Extended]WHERE [ID]=2'
I know that the query does not exists so I need to find the code to change it
I dont know how to attach a screen shot this is what it says
The Microsoft Access database engine cannot find the input table or query
'Customer Extended" Make sure it exists and that its name is spelled correctly.(3078)
strSQL='SELECT*FROM [Customer Extended]WHERE [ID]=2'
I know that the query does not exists so I need to find the code to change it
- Local time
- Yesterday, 23:38
- Joined
- Oct 29, 2018
- Messages
- 21,447
As another option, you could try using this little utility to search your database.
AccessBlaster
Registered User.
- Local time
- Yesterday, 23:38
- Joined
- May 22, 2010
- Messages
- 5,911
If it's code try this:
Press and hold ALT,F11 on the keyboard. Once the Visual Basic window opens press and hold Ctrl,F
In the find what box type strSQL =
On the left side of the menu pick current project, then press find next. This should loop you through all instances of strSQL = you shoud be able to spot the offending code.
HTH
Press and hold ALT,F11 on the keyboard. Once the Visual Basic window opens press and hold Ctrl,F
In the find what box type strSQL =
On the left side of the menu pick current project, then press find next. This should loop you through all instances of strSQL = you shoud be able to spot the offending code.
HTH
Last edited:
