AutoExec Macro and openForm method word Under access 2000 and not under Access 2007..

kapusta117

New member
Local time
Yesterday, 18:24
Joined
Nov 28, 2008
Messages
3
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
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 help to give to all the members and forum invited people..



I used an 'Autoexec' qu I makes it possible to launch the form to
the demarage Under access 2000 in which j' develeoppé my application all
functions well. On the other hand when j' tried to test my application under
access j' have an error on the level of macro Autexec which makes it possible
to launch the form according to the code:
 
Try setting the said form to open using the Tools > Startup menu.
 

Users who are viewing this thread

Back
Top Bottom