Strange Behavior

E

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

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
 
E

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.

James said:
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
 

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


Top