Open form command in Access

[jd20005]

I have the following code in a module which is set to Execute when the Database opens.

---------------------------
Function HelloKaren()

Dim MyDate As Date
Dim Noon As Date

MyDate = Time
Noon = #12:00:00 PM#

If MyDate < Noon Then
MsgBox &quot;Good Morning Karen&quot;, vbOKOnly, &quot;Welcome Karen&quot;

Else

MsgBox &quot;Good Afternoon Karen&quot;, vbOKOnly, &quot;Welcome Karen&quot;

End If

End Function

------------------------------------
It works fine.

I was just wondering if there was anyway to add code that would open up my Form_MinaMenu as part of this function. Instead of me having to specify it in the Tools, Startup, Display Form/Page box in the Toolbar.

 

[MakeItSo]

It's easy:
DoCmd.OpenForm &quot;Your Form&quot;, Filter if necessary

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[jd20005]

Thank you, that command worked very well!