Open Form Properties using more than 1x criteria

  • Thread starter Karen Yeung/Holland
  • Start date
K

Karen Yeung/Holland

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
 
K

Karen Yeung/Holland

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
 
S

sherriffpoker

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...
 
Top