By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

I have a user/pc specific problem in access.

P: n/a
I have a user/pc specific problem in access.

This doesn't occur on any other ( windows xp pc) that I have used the
..mbd on.

This involves a query that's using a range of dates as a parm. This
query uses a form for the date range to be entered.

The date form uses a macro to verify that the dates are entered.

This is the macro code.

I think the macro checks to see if the dates are entered .
Not IsLoaded("OpenByDateRange") --checks the form here

Then visble is set to no , producing the box you see below.
(only on on pc however)

" Invalid reference to the property 'visible' "
I assume this is on the "OpenByDateRange" form.

The form w/ dates goes entered should turn 'not visible' and the query
results will then show based on the date range selected.

Why would this only happen on one windows xp box here?

The mdb has been converted to access 2003.

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Open any code window. Click on Tools - References.
1. Check if any are shown as "Missing". If so, uncheck the reference, close
the references window, reopen the references window, scroll down to find the
reference you unchecked and check it again, close the references window and
retry the database.
2. If you do not find "missing", are the references checked on the aberrant
machine the same as the other machines?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jwa6" <jw*****@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I have a user/pc specific problem in access.

This doesn't occur on any other ( windows xp pc) that I have used the
.mbd on.

This involves a query that's using a range of dates as a parm. This
query uses a form for the date range to be entered.

The date form uses a macro to verify that the dates are entered.

This is the macro code.

I think the macro checks to see if the dates are entered .
Not IsLoaded("OpenByDateRange") --checks the form here

Then visble is set to no , producing the box you see below.
(only on on pc however)

" Invalid reference to the property 'visible' "
I assume this is on the "OpenByDateRange" form.

The form w/ dates goes entered should turn 'not visible' and the query
results will then show based on the date range selected.

Why would this only happen on one windows xp box here?

The mdb has been converted to access 2003.

Nov 13 '05 #2

P: n/a


thanks for the reply!!!

I did as you suggested. I didnt see any missing items . I did add one
libray

this is the list

v b for apps
ms access 11.0 obj lib
ole auto
ms dao 3.6
ms vb for apps ext 5.3
ms active x data obj lib 2.1

jim



PC Datasheet wrote:
Open any code window. Click on Tools - References.
1. Check if any are shown as "Missing". If so, uncheck the reference, close the references window, reopen the references window, scroll down to find the reference you unchecked and check it again, close the references window and retry the database.
2. If you do not find "missing", are the references checked on the aberrant machine the same as the other machines?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jwa6" <jw*****@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I have a user/pc specific problem in access.

This doesn't occur on any other ( windows xp pc) that I have used the .mbd on.

This involves a query that's using a range of dates as a parm. This
query uses a form for the date range to be entered.

The date form uses a macro to verify that the dates are entered.

This is the macro code.

I think the macro checks to see if the dates are entered .
Not IsLoaded("OpenByDateRange") --checks the form here

Then visble is set to no , producing the box you see below.
(only on on pc however)

" Invalid reference to the property 'visible' "
I assume this is on the "OpenByDateRange" form.

The form w/ dates goes entered should turn 'not visible' and the query results will then show based on the date range selected.

Why would this only happen on one windows xp box here?

The mdb has been converted to access 2003.


Nov 13 '05 #3

P: n/a
Did you retry the database?
"jwa6" <jw*****@yahoo.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...


thanks for the reply!!!

I did as you suggested. I didnt see any missing items . I did add one
libray

this is the list

v b for apps
ms access 11.0 obj lib
ole auto
ms dao 3.6
ms vb for apps ext 5.3
ms active x data obj lib 2.1

jim



PC Datasheet wrote:
Open any code window. Click on Tools - References.
1. Check if any are shown as "Missing". If so, uncheck the

reference, close
the references window, reopen the references window, scroll down to

find the
reference you unchecked and check it again, close the references

window and
retry the database.
2. If you do not find "missing", are the references checked on the

aberrant
machine the same as the other machines?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jwa6" <jw*****@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I have a user/pc specific problem in access.

This doesn't occur on any other ( windows xp pc) that I have used the .mbd on.

This involves a query that's using a range of dates as a parm. This
query uses a form for the date range to be entered.

The date form uses a macro to verify that the dates are entered.

This is the macro code.

I think the macro checks to see if the dates are entered .
Not IsLoaded("OpenByDateRange") --checks the form here

Then visble is set to no , producing the box you see below.
(only on on pc however)

" Invalid reference to the property 'visible' "
I assume this is on the "OpenByDateRange" form.

The form w/ dates goes entered should turn 'not visible' and the query results will then show based on the date range selected.

Why would this only happen on one windows xp box here?

The mdb has been converted to access 2003.

Nov 13 '05 #4

P: n/a
I changed the macro - using the 'build' wizard. This way I could set
the path {form!){this form) etc..

I then recieved a different error message that led me to think - when
access was installed - 'sandbox' was set. I went thru help files and
found out among other things that macros have their very own security
settings. 'tools'- macro -security. This pc had a security setting of
'high'. The default seems to be 'medium'. I set to the 'medium setting.
this was developed in access 2.0 I think.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.