Solved: Access 07 error - 'the report name '?' you entered in either...

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cxpmgr

Thread Starter
Joined
Jan 11, 2011
Messages
3
I'm not too accustomed to Access and here's my situation. I had an Access 2000 database which I converted to an Access 2007 database. I changed some information (names) within the tables, queries, and forms, and even changed the name of a report. Everything seems to be working fine, except when I try to open one of my reports through the forms pop-up box, I receive this message "'The report name '?' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist." I can open and review the report through the navigation pane, but not through the pop-up box. I've already changed the Record Source name to the new name, but still receiving that message. I have another report that opens just fine through the pop-up box, but I didn't change that name.

Any help would be highly appreciated.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
cxpmgr, welcome to the Forum.
I do not have Access 2007, so I can only suggest that check that the Report name in the VBA code or Macro is spelt exactly the same as the Report itself.
 

cxpmgr

Thread Starter
Joined
Jan 11, 2011
Messages
3
As I stated I'm not too familiar with Access and didn't create the database. There are no macros. I have no clue on how to locate the VBA codes. Could you assist me with locating the VBA codes? Thanks.
 

karlhaywood

Account Closed
Joined
Jan 17, 2010
Messages
680
Open the database and press alt+f11 this will open the VBA editor all the forms and reports are displayed down the left hand side, check through everyone and makesure the names of the reports in the code are the same as the report name.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top