Results 1 to 2 of 2

Thread: Archive (A2000)

  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Archive (A2000)

    I use an Append along with a Delete query to archive my data, the annoying thing though is when the queries are run, the information messages pop up, telling me how many records I am updating and deleting.

    Is there a way to stop these default messages.

    I would rather no message at all.

    Dave

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Archive (A2000)

    Use a
    DoCmd.SetWarnings False
    before the delete instruction and
    DoCmd.SetWarnings True
    after the delete instruction.
    Francois

Posting Permissions

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