[AccessD] Prompt after Form loads

A.D.

I don't know that I've ever used form's timer but why is it considered desirable to avoid?

Thanks,

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of A.D.Tejpal
Sent: Wednesday, September 01, 2004 1:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Prompt after Form loads


Francisco,

    As far as practicable, it is considered desirable to avoid activation of form's timer. Following course of action is suggested.

    Use a plain temporary form (it need not have any controls at all) to open the main form (named F_Main). Put the code given below in Open event of this form. 

    Now, whenever you open the the temporary form, the main form will be displayed normally along with the prompt - as desired. (In the meanwhile the temporary form will close by itself - the user will not become aware of it).

Regards,
A.D.Tejpal
--------------
================================
Private Sub Form_Open(Cancel As Integer)
    DoCmd.OpenForm "F_Main"
    MsgBox "Pl Check The Values"
    Cancel = 1
End Sub
================================

  ----- Original Message ----- 
  From: Francisco Tapia 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, September 01, 2004 21:58
  Subject: Re: [AccessD] Prompt after Form loads


  On Timmer w/ a static variable is what I ended up using (plus after it
  fires I shoot the timer interval to 2hrs (more than enough time)  so
  it hopefully won't fire again until after their session is done.

  On Wed, 1 Sep 2004 08:41:20 -0700, Francisco Tapia <fhtapia at gmail.com> wrote:
  > Just tried it and the OnCurrent event also fires before the form is
  > loaded :(, gonna try the OnTimmer...
  > 
  > 
  > 
  > On Wed, 1 Sep 2004 08:35:54 -0700, Francisco Tapia <fhtapia at gmail.com> wrote:
  > > I will try this option Gustav, thanks :D.
  > >
  > > btw, Rocky... What I meant by autoload was that in the Form_Load event
  > > I have code that loads data to the form. because it was in the
  > > form_load event, the prompt was occuring before the user had a chance
  > > to see the form.
  > >
  > > On Wed, 1 Sep 2004 12:34:56 +0200, Gustav Brock <gustav at cactus.dk> wrote:
  > > > Hi Andy and Francisco
  > > >
  > > > I would suggest OnCurrent.
  > > > To prevent multiple prompts, set a static flag:
  > > >
  > > >   Static booIsPrompted As Boolean
  > > >
  > > >   If booIsPrompted = False Then
  > > >     ' Ask if you user wish to load data.
  > > >     <code>
  > > >     booIsPrompted = True
  > > >   End If
  > >
  > > --
  > > -Francisco
  > >
  > 
  > 
  > --
  > -Francisco
  > 


  -- 
  -Francisco
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************