Report Will Not Open

Sorrels22

New member
Local time
Today, 14:36
Joined
Mar 7, 2011
Messages
2
Hello, I have created two databases in Access 2007 and initially created queries, forms and reports from the tables fine. If I save my database and exit Access, when I open the database again the table and query open fine, but the report will not open. I don't even get an error message. When I try to open the form I receive the error message "the Microsoft Access database engine could not find the object [name of my form]. Make sure the object exists and you spell its name and path correctly." I Googled key terms for the problem and make sure the path to the database is a trusted source.

The databases are very basic - one table in each. I recreated the databases from scratch again in case the file was corrupted for some reason. Same problems. Any suggestions you have to help me determine the cause of the problem will be greatly appreciated.
 
The name you've put in the DoCmd.OpenReport line is incorrect. Look in the Click event of the button and check the name in the code or macro.
 
Thank you! I'm embarrassed to admit that I am a self taught novice at Access, so I am not familiar with Visual Basic coding.

I don't understand why the name would be incorrect when I did not change the table, query or form names after I created them. Is there an easy way for me to access DoCmd.OpenReport to correct the problem if I do not have the Access developer knowledge base?

thanks again for your help.

fyi I have signed up for a several day course in Access in April. :)
 
Is there an easy way for me to access DoCmd.OpenReport to correct the problem if I do not have the Access developer knowledge base?
Your version of Access should have the help files already installed. Just click F1. I've already explained how to get to that command here:
Look in the Click event of the button and check the name in the code or macro.
Have a look at the image in the following link too if it helps:

http://baldyweb.com/FirstVBA.htm

Have fun at the course
smile.gif
 

Users who are viewing this thread

Back
Top Bottom