Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Warning messages (2003)

    Is there a way to stop the warning messages from appearing when appending data to a table? I have several macros that select data, deletes it and then imports a new file and copies and paste append.

    I would like all this to take place without the user seeing the messages.

    Thanks,
    Deborah

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Warning messages (2003)

    In your Macro, prior to manipulating data, select set warnings and set to off.

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Warning messages (2003)

    In addition to Gary's reply, don't forget to have another Set Warnings action at the end of the macro to turn it on again, otherwise warnings will remain turned off for the rest of the session, which may not be desirable.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Warning messages (2003)

    Hans,

    It works great from my computer..I am running the full version. The users have run-time version and they are still getting the messages. Is there a way to turn them off for the run-time?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Warning messages (2003)

    As far as I know, the Set Warnings action should work in Access Runtime too, but I cannot test it.

    As an alternative, you could use VBA code. The instruction

    CurrentDb.Execute "QueryName"

    will execute an action query without displaying warnings.

Posting Permissions

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