How to bypass startup form of access db via visual basic app/XL
 

I am creating a macro that opens an access database and updates some
information. My problem is that there is a lengthy startup form/process that
I want to bypass. Right now I am using

app.OpenCurrentDatabase "location_of_database"

as the vb programming statement to open the database. I know you can bypass
the startup if you manually open the database by pressing the Shift key, but
I do not know how to program this via visual basic within an excel macro.

How to bypass startup form of access db via visual basic app/XL
 

Try: Application.EnableEvents = False



"Nancy at AD STD" <Nancy at AD schreef in
bericht ...
I am creating a macro that opens an access database and updates some
information. My problem is that there is a lengthy startup form/process
that
I want to bypass. Right now I am using

app.OpenCurrentDatabase "location_of_database"

as the vb programming statement to open the database. I know you can
bypass
the startup if you manually open the database by pressing the Shift key,
but
I do not know how to program this via visual basic within an excel macro.