Results 1 to 3 of 3
  1. 04-07-2015, 03:37 AM #1
    Esmatullaharifi
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40

    Question Update query running notifications

    I am using a lot of update queries using forum buttons but every time running the queries i must click yes - yes - yes and so on. How can I prepare these answers to update query using VBA or another way.
    My main purpose is this that when running an update query the records must be update without asking me with one click.
    I am looking forward for your answers.
    Thanks,
    Reply With Quote Reply With Quote
  2. 04-07-2015, 06:38 AM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Research currentdb.execute method
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  3. 04-07-2015, 07:34 AM #3
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Turn OFF notifications...in the macro (or code)
    macro: SetWarnings off

    vba: docmd.setwarnings false
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Need to update a field to '0' that is running off a query
    By LanieB in forum Forms
    Replies: 2
    Last Post: 06-26-2012, 10:31 AM
  2. Running an Update Query from a Macro
    By michaelb in forum Queries
    Replies: 7
    Last Post: 06-02-2011, 09:46 PM
  3. Running an update query
    By markod in forum Queries
    Replies: 3
    Last Post: 11-11-2010, 01:24 PM
  4. Running update query in access 2010
    By dbansal in forum Queries
    Replies: 1
    Last Post: 09-03-2010, 10:57 AM
  5. Help Automatically running and Update Query
    By JohnRandolphSTL in forum Queries
    Replies: 8
    Last Post: 04-13-2010, 02:08 PM

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

Other Forums: Microsoft Office Forums