Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178

    Question Unanswered: Open a Table Synchronously

    I need to open a table in the middle of a VBA routine for some pretty heavy duty data entry, and I want the code to wait for me 'til I'm finished the data entry before continuing. How can I open the table synchronously?

    Thanks in advance,

    Sam

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You could open a form using acDialog and the code would wait. I would never open a table directly anyway, so that's what I'd do.
    Paul

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    This is a quick and dirty, so I never even considered a form. It's a fine idea, though. Thanks.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •