Results 1 to 4 of 4

Thread: access prompts

  1. Jan 26th, 2004, 01:32 PM #1
    JMM427
    JMM427 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2003
    Location
    Connecticut
    Posts
    257

    access prompts

    Can someone refresh my memory on the command to turn off warning prompts to the user when running queries, etc. from code?
    Reply With Quote Reply With Quote
  2. Jan 27th, 2004, 04:37 AM #2
    BrianB
    BrianB is offline
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    Application.Displayalerts=False

    Make sure you reset it to True again afterwards.
    Regards
    BrianB
    -------------------------------
    Reply With Quote Reply With Quote
  3. Jan 27th, 2004, 11:45 AM #3
    JMM427
    JMM427 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2003
    Location
    Connecticut
    Posts
    257
    It's telling me that displayalerts is not a method of application. I am referencing DAO and ActiveX. Do I need to reference something else?
    Reply With Quote Reply With Quote
  4. Jan 27th, 2004, 12:00 PM #4
    JMM427
    JMM427 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2003
    Location
    Connecticut
    Posts
    257
    Never mind. I found the SetWarnings method of the docmd.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width