Open Form Properties using more than 1x criteria

G

Guest

I've a form used as a main menu for my data base inserted with an ActiveX
Control Calendar thereon.
I've an event procedure with On Load: (I learned this from this Discussion
Web.)

Private Sub Form_Load()
Me.UserCalendarT1.Today (UserCalendarT1 is my calendar's name)
End Sub

to open the Calendar showing the current date when users open the Data Base.
It works out fine.
It's because my Form (Main Menu) doesn't open in full when the Data Base is
open, therefore I've added a macro to open the Form with the Action
"Maximize" and placed the Macro with On Open.
The result is : the Form opens in Maximized window but the Calendar doesn't
function to the current date upon opening anymore.

Would anybody please help. I am not good in event procedure writing nor any
visual basic writing, I have created this Data Base (Timesheet) all the way
through macros for command buttons using Access 2K only.

thanks in advance,
Karen
 
G

Guest

Thanks for your reply, Rob.
I am sorry I didn't understand at all. As I said, I don't know anything
about the VBA and I created the DB all the way using macros. I did try
what's on this Tip#13 but didn't work out. Is there anything more is
simplier than this? You would say this is already simple, but I must admit I
am stupid to understand this. sorry.
Karen
 
R

Rob

Karen

First.... there's no such thing as a stupid question.

Second... we'll get through to a solution you can work with... = )

Where you have this code:
Private Sub Form_Load()
Me.UserCalendarT1.Today (UserCalendarT1 is my calendar's name)
End Sub

Add this line before calling the "Me.UserCalendarT1":
DoCmd.Maximize


Try that and let me know how it works out for you.


--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/
 
G

Guest

Karen Yeung/Holland said:
I've a form used as a main menu for my data base inserted with an ActiveX
Control Calendar thereon.
I've an event procedure with On Load: (I learned this from this Discussion
Web.)

Private Sub Form_Load()
Me.UserCalendarT1.Today (UserCalendarT1 is my calendar's name)
End Sub

to open the Calendar showing the current date when users open the Data Base.
It works out fine.
It's because my Form (Main Menu) doesn't open in full when the Data Base is
open, therefore I've added a macro to open the Form with the Action
"Maximize" and placed the Macro with On Open.
The result is : the Form opens in Maximized window but the Calendar doesn't
function to the current date upon opening anymore.

Would anybody please help. I am not good in event procedure writing nor any
visual basic writing, I have created this Data Base (Timesheet) all the way
through macros for command buttons using Access 2K only.

thanks in advance,
Karen
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Open Form with WhereCondition 6
Open Form in Add Mode 1
Cannot open a form using "Docmd Openform" 1
Multiple combo boxes on form to open another form 4
Behaviour depends on the placement of DoCmd Close, acform... 2
default value for calendar on data entry form 2
my own "switchboard" form 3
multiple instances of form in Access 2007 2

Top