Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Surpress Confirmation Messages while updating records with VBA

Discussion in 'Information Technology' started by Rasmus, Nov 15, 2005.

  1. Rasmus

    Rasmus
    Expand Collapse
    Guest

    Hi everybody,

    I am updating records with a VBA skript. While the script is running access
    keeps bothering me with confirmation messages. Is it possible to surpress
    these messages?

    Any help would be aprechiated.
    thx
    Rasmus
     
  2. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    If you are using DoCmd methods to execute queries or SQL statements, try
    using CurrentDb.Execute or CurrentProject.Connection.Execute instead. See
    the help file for details.

    --
    Brendan Reynolds

    "Rasmus" <daqraz@web.de> wrote in message
    news:OFYYptT6FHA.4076@tk2msftngp13.phx.gbl...
    > Hi everybody,
    >
    > I am updating records with a VBA skript. While the script is running
    > access keeps bothering me with confirmation messages. Is it possible to
    > surpress these messages?
    >
    > Any help would be aprechiated.
    > thx
    > Rasmus
    >
     
  3. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    Look up DoCmd.SetWarnings in Access help.

    Generally you turn warnings off just before your code
    actually starts doing stuff to records then turn them back
    on again at the end.


    --
    Nick Coe (UK)
    Available - Will work for money :)
    http://www.alphacos.co.uk/ AccHelp + pAnimal
    http://www.pjandcoe.co.uk/ Online Store

    In news:OFYYptT6FHA.4076@tk2msftngp13.phx.gbl,
    Rasmus typed:
    > Hi everybody,
    >
    > I am updating records with a VBA skript. While the script
    > is
    > running access keeps bothering me with confirmation
    > messages.
    > Is it possible to surpress these messages?
    >
    > Any help would be aprechiated.
    > thx
    > Rasmus
     
  4. Ofer

    Ofer
    Expand Collapse
    Guest

    If you want to remove the messages for all action queries, without using the
    set
    warnings, then in the menu bar select
    Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
    selection)

    But you have to know that it will never prompt with the message event when
    you are using the queries dirrectly
    --
    I hope that helped
    Good Luck


    "Rasmus" wrote:

    > Hi everybody,
    >
    > I am updating records with a VBA skript. While the script is running access
    > keeps bothering me with confirmation messages. Is it possible to surpress
    > these messages?
    >
    > Any help would be aprechiated.
    > thx
    > Rasmus
    >
    >
    >
     

Share This Page