Menu doesn't open after TransferDatabase

[ghillie30]

Hi - Recent new guy here. in Access 2007 db, I'm using a menu form instead of switchboard. When I create a new db using transferdatabase, the menu form is copied but stays in the nav pane, it doesn't open when the db is opened. It can be opened after opening the nav pane, but I'd like it to open like switchboard as soon as the db is opened.



I'm using

DoCmd.TransferDatabase acExport, "Microsoft Access", filename, acForm, "menu","menu",False

Is there an argument I'm missing, or should I export it as something other than a form?

Thanks in advance for any help.

[June7]

The original db probably has setting in project Options for the form to open by default. Click the Office button > Access Options > Current Database, look at the Display Form item.

Why are you creating new database?

[ghillie30]

Thanks for the quick response. Yes, the menu opens by default in the initial db. These dbs are for training records, whenever a new session begins, users will be creating a new db which uses existing forms, queries, reports, and lookup tables but blank data tables. I'm hoping to have the new db look identical to the old.

[June7]

Did you check the setting I described for the new db?

Still don't know why a separate db for each training session.

[ghillie30]

After the new db is created, I can open it and change the settings to have the menu open at start. But, I was hoping to have the new db import the same settings as the initial so that users can start as soon as they create it. We start new dbs for each session because the personnel list is totally different from session to session.

[June7]

Instead of project setting, would have to use code to open default form.

I have customized ribbon so I use:
Sub OnRibbonLoad(ribbon As IRibbonUI)
' Callbackname in XML File "onLoad"
DoCmd.OpenForm "Login"
End Sub

An AutoExec macro should also be able to do this. Check out:
http://www.vb123.com/toolshed/05_map/ch04_autoexec.htm
http://office.microsoft.com/en-us/ac...010336239.aspx

[ghillie30]

Totally did not think about a macro, I loaded an AutoExec to open the menu and it works fine. Thanks for the help.