A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Invalid Reference" message



 
 
Thread Tools Display Modes
  #1  
Old September 29th, 2005, 05:38 PM
Susan
external usenet poster
 
Posts: n/a
Default "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  
Old September 29th, 2005, 07:05 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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  
Old September 29th, 2005, 07:22 PM
Susan
external usenet poster
 
Posts: n/a
Default

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  
Old September 30th, 2005, 04:05 PM
Susan
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 10:07 PM
How do I find "invalid external reference"? excel M Worksheet Functions 3 January 19th, 2004 05:39 PM


All times are GMT +1. The time now is 12:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.