| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| visual basic within Access If...Then | Excel Discussion (Misc queries) | |||
| visual basic within Access If...Then | Excel Discussion (Misc queries) | |||
| Inserting Form form Visual Basic... | Excel Programming | |||
| Insert forms created in excel's visual basic into a worksheet or at startup | Excel Programming | |||
| Allow access to visual basic project | Excel Programming | |||
Hybrid Mode
