On Tue, 02 Dec 2008 12:52:58 GMT, "kapusta117 via AccessMonster.com"
<u47866[ at ]uwe> wrote:
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
[Quoted Text] >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.
|