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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visual Basic Editor Opening and Closing for User 14
Disable/Enable the Shift Bypass Key 3
"Trust Access to Visual Basic Project" checked but getting error 6 2
File freezing - Trust access to Visual Basic Project setting 2
Disable AllowBypassKey 4
Access Command to run access, open to specific form and specific record 1
Excel VB to open Access DB 1
Bypass Startup Display Form? 2

Top