Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Warning (Access 2003)

    I have a button that you click and it appends rows to a table. The message always comes up that "this will append 3 rows to the table...". How can I stop the message and still have it populate the table.

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

    Re: Warning (Access 2003)

    Insert a line

    DoCmd.SetWarnings False

    at the beginning of the code behind the command button, and

    DoCmd.SetWarnings True

    at the end.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Warning (Access 2003)

    Thanks!

  4. #4
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Warning (Access 2003)

    Hello Hans,

    From Access 2000 help:
    <hr>When the macro finishes, Microsoft Access automatically turns the display of the system messages back on.<hr>
    Is it really necessary to add the final DoCmd.SetWarnings True line?

    Thanks
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  5. #5
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Warning (Access 2003)

    <hr>at the end.<hr>
    Re-reading your post, I believe that's meant to be "at the end of the code behind the command button", not "at the end of the code of the whole sub". Sorry, my bad.
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

Posting Permissions

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