OPEN FORMS

[AFKAFB]

Hi
I've a database where i want a form to open when the db is opened.

The code i've written does not call activate the form when the db is
opened

Option Compare Database

Public open_db()

DoCmd.OpenForm (Form_Frm_Issue s_Log,acnormal)

End Sub

[CDMAPoster]

On Jan 24, 12:24 am, "AFKAFB" <chris.by...@cb a.com.auwrote:

Hi
I've a database where i want a form to open when the db is opened.

The code i've written does not call activate the form when the db is
opened

Option Compare Database

Public open_db()

DoCmd.OpenForm (Form_Frm_Issue s_Log,acnormal)

End Sub

The way I do this is with a macro called AutoExec. In the AutoExec
macro select OpenForm for the action and put the name of the form to
open in the Form Name box. An AutoExec macro, which runs automatically
if present when Access is opened, is the only macro I ever use
(pre-2007). I almost always use one Action line -- either OpenForm or
RunCode. Some people like to use the Startup options instead to
specify an initial form to open. I usually put quotes around the form
name when using DoCmd.OpenForm so I'm not sure if your syntax will work
or not. For example, I use:

DoCmd.OpenForm "frmQuotes" , , , , , , strQuoteID

Post back if you have any questions.

James A. Fortune
CD********@Fort uneJames.com

[CDMAPoster]

On Jan 24, 12:24 am, "AFKAFB" <chris.by...@cb a.com.auwrote:

Hi
I've a database where i want a form to open when the db is opened.

The code i've written does not call activate the form when the db is
opened

Option Compare Database

Public open_db()

DoCmd.OpenForm (Form_Frm_Issue s_Log,acnormal)

End Sub

One more thing. Is your form actually named Form_Frm_Issues _Log? If
so, do you realize that the Form_ syntax has a special meaning in
Access and your form name can be misinterpreted as a class reference to
a form called Frm_Issues_Log?

James A. Fortune
CD********@Fort uneJames.com

[Tim Marshall]

AFKAFB wrote:

Hi
I've a database where i want a form to open when the db is opened.

You can use the autoexec macro as James describes or go to
Tools->StartUp. There is a drop down (combobox) on the right entitled
"Display form/page". Choose the name of the form you want to be opened
when your mdb is opened.

The settings in startup can be bypassed when opening the mdb by holding
the shift key down while you open the mdb.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me