[AccessD] Prompt after Form loads

Charlotte Foust cfoust at infostatsystems.com
Wed Sep 1 13:21:43 CDT 2004


I've used them under protest, but they tend to cause screen flickers and
various other odd behavior and they fight with other form events.  The
form timer isn't implemented very well in Access, unlike the timer
controls you can use in VB.

Charlotte Foust


-----Original Message-----
From: Jim DeMarco [mailto:Jdemarco at hudsonhealthplan.org] 
Sent: Wednesday, September 01, 2004 11:12 AM
To: Access Developers discussion and problem solving
Subject: RE: [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".
************************************************************************
***********

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



More information about the AccessD mailing list