VBA to automate various processes upon opening a database

Hi Mark,

Thank you for your question.

I am currently training on-site and will have a look at the question later today.

Regards

Simon

Hi Mark, thanks for your query. When it comes to forms, it depends on whether you are talking about an Access database form or a VBA form. Treat an Access database form exactly the same as a Switchboard form, but use the statement frmMain.Show (for example) to show a VBA form.

As for how to trigger it off automatically, this ties into your first point about setting application properties such as Overlapping Windows from the word go. A full explanation is beyond the scope of this forum, but essentially, you need to create an AutoExec subroutine. This is not as simply as it is in Excel or Word VBA but an outline of how to do so can be found here:

http://www.vb123.com/toolshed/05_map/ch04_autoexec.htm

Simon has worked out the line of code needed to switch off Overlapping Windows (it is a particularly obscure line of code) and this statement will need to go into the AutoExec subroutine. I'll get him to post it as soon as he is free.

I hope this helps. Let us know how you get on.

Anthony