Access VBA: Is it possible to execute VBA code when the Access DB opens?

Question

I have 2 forms I'd like to open when the Database opens based on a condition.

Basically If 'table1' exists in the database, then open form1
Else open form2

Is there a way to get this functionality right when the database first opens?

AMissico · Accepted Answer · 2011-08-17 19:19:36Z

3

You can use the AutoExec macro and "run form". Create a macro called "AutoExec". Do what is needed in the macro.

There is also a "Display Form" under the "Application Options" that you can use.

answered Aug 17, 2011 at 19:19

AMissico

21.8k7 gold badges80 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shubham Over a year ago

There is no "run form", but there is "open form" but that only lets me open one form unconditionally.

Shubham Over a year ago

I tried doing "run code" on a function in a module that opens the right form based on a condition, but when I start my databse, i get the error "The expression you entered has a function name that Access can't find"

Shubham Over a year ago

Nevermind figured it out! For anyone interested: the function name cant be the same as the module name.

Collectives™ on Stack Overflow

Access VBA: Is it possible to execute VBA code when the Access DB opens?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related