r3m5p3p6t

[kapusta117 via AccessMonster.com]

Hello evrybody


I have created an application with forms, Macros , as well vba codes
(modules) and SQL request ) under access 2000...i'm a beeginner in Access
and VBA too.

I used an AutoExec Macro wich open a form called 'Menu' at the opening of
database .
This is the code that allow me open the form :

----------------------------------------Begenning of Code
Once the form opened i used an event :
Public Function demarer()
DoCmd.Minimize

DoCmd.OpenForm "Menu"
Forms("Menu").Visible = True
DoCmd.Maximize

End Function
-------------------------------------------finish of code

Once the form opened ..This event ( open_form ) launche the creation and show
of a Menubar ( with commandbarr) called 'Mabarre'..

Althing is working good under Access 2000 (Autoexec as well) ...But
Unfortunatelly when tried to test my Application Under Access 2007... I meet
a window message Error calling me that the execution of 'AutoExec' has falled
and that there is a probleme with the method 'OpenForm' (has falled to ..).

I'm a little astonished how the application ( autoexec and openform ) could
work under access 2000 and not Access 2007..and I m fund of resolving the
enigm ( heh)..

Thank you for Helping me..and for the heping all the members and forum
invited people..

See you later.

 

[Tom van Stiphout]

On Tue, 02 Dec 2008 12:52:58 GMT, "kapusta117 via AccessMonster.com"

Next time you may want to use a better subject line. I typically
delete messages with gibberish subjects.
There is nothing wrong with DoCmd.OpenForm "Menu" in A2007. But you
may have another object somewhere with the name Menu. Change it to
frmMenu and try again.
Also comment out DoCmd.Minimize and try again.

-Tom.
Microsoft Access MVP

 

[kapusta117 via AccessMonster.com]

Sorry ...For gibberish subject..In fact it was a mistake not voluntary..i
have made a control V and put a mistake value there ..and unfortunatlly
doesnt know how i validate the post ..may be i put down a button without any
attention.....You know this mistake happens somtime UNVLUNTARY.
I m sorry ...
Thank for your response...Next time i will be more carful about subject..