If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Invalid Reference" message
I have designed a database in Access 97. It includes a report switchboard on
which I can select the report (via checkboxes) I want to print. It also has a combo box and other items which are either visible or not vislbie, depending upon the report selected (by using a macro which sets the value to visible yes or visible no). It works great on my PC and on another one running Access 97. However, one user has Access 2003 installed, and when he tries to select a report to print, he gets a message that "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object you specified." Does anyone have any idea why this doesn't work on Access 2003, and what I can do to fix it? Thanks! |
#2
|
|||
|
|||
Access 97 applications do not work well in 2003. Your best bet is to upgrade
to 2003. In fact, the very best solution is to first convert 97 to 2000 then to 2003 "Susan" wrote: I have designed a database in Access 97. It includes a report switchboard on which I can select the report (via checkboxes) I want to print. It also has a combo box and other items which are either visible or not vislbie, depending upon the report selected (by using a macro which sets the value to visible yes or visible no). It works great on my PC and on another one running Access 97. However, one user has Access 2003 installed, and when he tries to select a report to print, he gets a message that "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object you specified." Does anyone have any idea why this doesn't work on Access 2003, and what I can do to fix it? Thanks! |
#3
|
|||
|
|||
Hmmm...not what I wanted to hear. But thanks for the response and info!
"Klatuu" wrote: Access 97 applications do not work well in 2003. Your best bet is to upgrade to 2003. In fact, the very best solution is to first convert 97 to 2000 then to 2003 "Susan" wrote: I have designed a database in Access 97. It includes a report switchboard on which I can select the report (via checkboxes) I want to print. It also has a combo box and other items which are either visible or not vislbie, depending upon the report selected (by using a macro which sets the value to visible yes or visible no). It works great on my PC and on another one running Access 97. However, one user has Access 2003 installed, and when he tries to select a report to print, he gets a message that "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object you specified." Does anyone have any idea why this doesn't work on Access 2003, and what I can do to fix it? Thanks! |
#4
|
|||
|
|||
Klatuu or anyone...(Gort, maybe?)...If I would update the two 97 pcs to
Office 2003, how would i fix the switchboard so that I could still have the controls visible or not visible...would I just re-do the entire macro? Thanks! "Klatuu" wrote: Access 97 applications do not work well in 2003. Your best bet is to upgrade to 2003. In fact, the very best solution is to first convert 97 to 2000 then to 2003 "Susan" wrote: I have designed a database in Access 97. It includes a report switchboard on which I can select the report (via checkboxes) I want to print. It also has a combo box and other items which are either visible or not vislbie, depending upon the report selected (by using a macro which sets the value to visible yes or visible no). It works great on my PC and on another one running Access 97. However, one user has Access 2003 installed, and when he tries to select a report to print, he gets a message that "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object you specified." Does anyone have any idea why this doesn't work on Access 2003, and what I can do to fix it? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Message recall | Erin | General Discussion | 5 | September 12th, 2005 05:11 PM |
'Invalid Argument' error message | Ericka G: Baltimore, MD | General Discussion | 0 | June 24th, 2005 05:58 PM |
"Invalid Argument" Error Message | General Discussion | 1 | July 16th, 2004 02:28 PM | |
Getting around the Invalid reference Error | abxy | Worksheet Functions | 1 | February 19th, 2004 09:07 PM |
How do I find "invalid external reference"? | excel M | Worksheet Functions | 3 | January 19th, 2004 04:39 PM |