Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Open Form with instance method & wait to close?

    Hello,
    I am creating forms instances in code, using.

    Set frm = New Form_frmBase (http://allenbrowne.com/ser-35.html)


    frm.Visible = True
    Now frm is visible but code continues run.

    The DoCmd.OpenForm xxx,,,,,acDialog pause execution of code but dot works this form instances.

    When I use below "while wend" loop seems to use up a lot of processor time - the task manager shows access as using 99% of processor time.
    Set frm = New Form_frmDialog
    frm.Visible = True
    While frm.Visible
    DoEvents
    Wend
    Who to make a solution to combine "acDialog" & instances without using 99% of processor time;

    Any idea for this;

    Many thanks
    George Bakoyannis

    from Greece


    P.S.
    I work with MS ACCESS 2000

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    george:

    wait for your answer here: http://www.access-programmers.co.uk/...d.php?t=200025

    that forum has more exposure than this one.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pause / Wait / Countdown / Timer
    By DevGreg in forum Programming
    Replies: 2
    Last Post: 07-19-2022, 06:30 AM
  2. Multiple Instance Form
    By steve.roic@bellsouth.net in forum Forms
    Replies: 0
    Last Post: 05-19-2010, 11:18 AM
  3. Close All but One Form
    By Bruce in forum Forms
    Replies: 4
    Last Post: 04-06-2010, 09:31 AM
  4. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  5. close form
    By taylorosso in forum Forms
    Replies: 5
    Last Post: 08-25-2009, 12:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums