Strange Behavior

[Ernst Guckel]

Hello,

I have an Access app that opens up maximized. There are buttons that
change the source of a subform control. When I click on the inventory
commanc button all is fine but two strange things happen. One there is a
control thats Control source is =Weekday([txtInvDate]) it does not work
unless I minimize access and then restore it. The second is I have a
calendar control that when I click it should open a calendar form but it
opens behind access. If I minimize access then restore it the calendar works
fine as well... Strange behavior???

Any Ideas?
Ernst.

 

[James]

Hello,

  I have an Access app that opens up maximized.  There are buttons that
change the source of a subform control.  When I click on the inventory
commanc button all is fine but two strange things happen.  One there is a
control thats Control source is =Weekday([txtInvDate]) it does not work
unless I minimize access and then restore it.  The second is I have a
calendar control that when I click it should open a calendar form but it
opens behind access.  If I minimize access then restore it the calendar works
fine as well...  Strange behavior???

Any Ideas?
Ernst.

If you have buttons that change the sources of controls/forms/reports
then you more than likely will need to refresh them first which may be
happening when you minimize etc. Why not add in the following line to
your code to refresh it:
DoCmd.Requery

Regards

 

[Ernst Guckel]

Ok... I have added a requery to each button but nothing... Here is what
happens when I click on a commandbutton on frmStartup:

Me.lblHeader.Caption = STR_INV

sForm = FORM_BYDATE
cldMain.SourceObject = FORM_BYDATE

'Hide buttons not for Inventory
HideEmp
HideSales

'Show Inventory buttons
ShowInv

Application.SetOption "Move After Enter", 2
DoCmd.Requery


??? Still confused a bit...

Ernst.

Hello,

I have an Access app that opens up maximized. There are buttons that
change the source of a subform control. When I click on the inventory
commanc button all is fine but two strange things happen. One there is a
control thats Control source is =Weekday([txtInvDate]) it does not work
unless I minimize access and then restore it. The second is I have a
calendar control that when I click it should open a calendar form but it
opens behind access. If I minimize access then restore it the calendar works
fine as well... Strange behavior???

Any Ideas?
Ernst.

If you have buttons that change the sources of controls/forms/reports
then you more than likely will need to refresh them first which may be
happening when you minimize etc. Why not add in the following line to
your code to refresh it:
DoCmd.Requery

Regards