Problem with a "open_form" macro created with Access 2002!

[Wolfgang Kriegl]

Hi!

I am developing a database for users using both Access
2000 and Access 2002 under Windows 2000 and Windows XP.
In general there are no problems when developing the
database in the Access 2000 format, but one macro gives
me grief lately.

I created a new macro within Access 2002 which does
nothing but opening a certain form that contains text and
a mailto-hyperlink. The macro is meant to be executed
from within another form by pressing a button.

Well, in Access 2002 this worked fine of course. But in
Access 2000 I get the error message that "Microsoft
Access can't find the macro." The macro is sure there!

The strangest thing is, that another macro, used to close
that same for I mentioned above by pressing a button on
that form, works just fine with Access 2000. Why the
other macro is giving me such grief is beyond me!

Please, if anybody can shed some light onto this mistery,
then please help me out and share your knowledge. Thank
you very much!


Wolfgang Kriegl

 

[Steve Schapel]

Wolfgang,

One possibility is that you are somewhere using some functionality
that is included in Access 2002 but not Access 2000. Are you sure it
is the macro to open the form that Access is objecting to? Do you
have any macros or VBA code running on the second form's On Open or On
Load or On Current events? What exactly are the actions in the macro?

- Steve Schapel, Microsoft Access MVP

 

[Wolfgang Kriegl]

Steve,

Thank you for your reply and insight.
That is very much appreciated!

The underlying form which contains the button that is
supposed to run the macro when pressed, does contain
a "On Laod" and a "On Current" event, both VBA procedures.
They work fine with Access 2000 and contain a
DoCmd.Maximize and some If -> Else statements regarding
content filtering.

The macro that is reported as not existant contains a
OpenForm action with options to display in Form View,
Edit Data Mode and Dialog Window Mode. And that is all!

I found out that, when I open the macro in design view on
a Access 2000 installation and save is unchanged, the
application can then work with it without any problems.

Is there a difference in how Access 2002 stores the macro
inside the MDB-File compared to Access 2000? And why is
the problem affecting the OpenForm macro action but not
the Close action in the other macro that I added the same
day?

Thank you again for your help!

Wolfgang

 

[Wolfgang Kriegl]

Hello again!

I thought you might find this information usefull to help
me out, so I'll include it as well.

The form that is supposed to open with the macro does not
include any events for "On Open" or "on Click" and so
forth. There is one button on that form however, that has
a "On Click" event, starting the close_macro for that
form. That work fine in Access 2000. I tested it by
opening the form directly and then pressing that button.
The form closed and no error messages where displayed.

The other thing is, that the database I work on is being
hosted by Replication Manager and synchronized using
internet synchronization.

I was able to get the OpenForm macro to work within
Access 2000 by opening it in design view and saving it
again, without doing any changes to it. It then was
executed flawlessly.

When I synchronize that exact database that I got the
macro to work on, and then open another version of the
database and synchronize that as well, the macro gives
the same error message again.

This is annoying and I do not know why it happens.
Any ideas?


Wolfgang

 

[Wolfgang Krieigl]

Hello Steve!

Thank you for your reply.
I was not able to solve my problem with the macro, so I
implemented the functionality I want in VBA.

If possible, I would like to ask you to forward this
Newsgroup thread as feedback or bug report to the
appropriate team within Microsoft. I understand that
Office 2003 is near release now, and maybe this problem
has already been solved with this new release, but if
not, please fix this. Thanks!

Regards,
Wolfgang Kriegl