Run-Time error 2447 with Access 2003 for 2002 Access switchboard

[Eric Kim via AccessMonster.com]

Hi,
I have read all the relative discussions not to ask you the same relavant question again, but I couldn't find it.

I'd very much appreciate if you could help me with this.

Our office has been using Access 2002 and one of our staff just got a new computer with MS Office 2003.

When the staff tries to open the Acess (the first page is switchboard), a pop-up message(security warning) comes up that says "This file may not be safe if it contains code that was intended to harm your computer"

- I don't want this if I can...

Then, When I hit open button, The Run-Time Error 2447 message pops up saying "There is an invalid use of the dot or ! operator or invalid parentheses."

When I hit "Debug" button, the yellow hight lighted area in VB is like this:

If Forms ! frmAdmin.txtAdministrator.Value = "Yes" Then

The rest of us can use the d/base with no problem with their 2002 Access version even with the same code. Only the ones with 2003 has it.

What do you think is the problem ?

I have spent about two days doing the reseach on the web, with no avail.

I would really appreaicte if you could help me with this.

 

[Guest]

For your firts problem, go to tools, macros, set security to low, and that
should solve that.
For the seconf problem, I'd go to the form the debugger is pinting you to
and compare 2002 to 2003. See if it can be fixed in 2003 and what the
difference is. It could be something very little, such as rebuilding parts
of that form in design. I've had to do that between two users using the same
version of Access. Don't ask....

 

[John Vinson]

When I hit "Debug" button, the yellow hight lighted area in VB is like this:

If Forms ! frmAdmin.txtAdministrator.Value = "Yes" Then

The rest of us can use the d/base with no problem with their 2002 Access version even with the same code. Only the ones with 2003 has it.

What do you think is the problem ?

If that's literally what you see - with spaces around the exclamation
point - then the syntax is wrong. Try editing this line to

If [Forms]![frmAdmin]![txtAdministrator] = "Yes"

Some of the changes I suggest - brackets, removing the default .Value
property - are not essential but would be more consistant with Access
best practices.

John W. Vinson[MVP]

 

[Eric Kim via AccessMonster.com]

Thank you John,

Actually there's no space around exclamation point.

But I'll try your suggestion this afternoon when I have exclusive access to the database.

Does 2003 need different syntax from 2002 ?
I'm just curious because all the other 2002 users to the d/base have no problem at all...

Thank you for your time and the tips.

 

[Eric Kim via AccessMonster.com]

Thank you for the security level tips.

I compared the two for the run-tme error problem, and they are the same....

Thank you anyway.

 

[Eric Kim via AccessMonster.com]

Wow,,,,

I set the security level down to low just to get rid of the fist warning pop-up and it fixes all my problems.

Thank you. all.

 

[John Vinson]

Thank you John,

Actually there's no space around exclamation point.

But I'll try your suggestion this afternoon when I have exclusive access to the database.

Does 2003 need different syntax from 2002 ?
I'm just curious because all the other 2002 users to the d/base have no problem at all...

Thank you for your time and the tips.

In my experience the syntax is exactly the same. I really wonder if
this one user's instance of the database is corrupt; compact and
repair won't solve all corruption problems. You might try Decompiling
or some of the other hints at Tony Toews' corruption FAQ:

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson[MVP]