Consulting

Results 1 to 3 of 3

Thread: How to avoid turning-off warnings in a timer event making warnings appearing when oth

  1. #1

    How to avoid turning-off warnings in a timer event making warnings appearing when oth

    I want to run an append query on a form's timer event and will turn warnings off just before running it and turn them on just after running it.
    If the timer is called while some other code is running (e.g. as a result of the user pressing a button), will that code then have warnings appearing on screen and can this be avoided? Thank you!

  2. #2

  3. #3
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,088
    Location
    I am fairly certain that once the Timer event starts running and the warnings are set to off then no warnings will occur until the query runs and the timer event turns them back on.
    Unless of course the other code sets the warnings to on.

Posting Permissions

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