Strange Behavior

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernst Guckel - 01 Apr 2008 05:31 GMT

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.

Reply to this Message

James - 01 Apr 2008 17:26 GMT

On 1 Apr, 05:31, Ernst Guckel <ErnstGuc...@discussions.microsoft.com>
wrote:

> Hello,
>
[quoted text clipped - 9 lines]
> 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

Reply to this Message

Ernst Guckel - 01 Apr 2008 19:27 GMT

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.

> On 1 Apr, 05:31, Ernst Guckel <ErnstGuc...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 19 lines]
>
> Regards

Reply to this Message