Results 1 to 2 of 2

Thread: SendKeys

  1. #1
    Join Date
    Jun 2002
    Posts
    59

    Unanswered: SendKeys

    Hello,

    In A2k I use vb to run a series of Queries, e.g.

    SendKeys"{enter}",False
    SendKeys"{enter}",False
    Docmd (to open a delete query)

    This works for several queries like Update, MakeTable, delete etc. However on one Delete query I find that often (not always) I am presented with the pop-up boxes telling me I am about to Delete xxx records etc. I don't want this but wish the actions to take place without prompting.

    Any suggestions as to why this happens with this one query (or solutions)?

    Thanks

    Frank

  2. #2
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244
    Not sure why it's happenning intermittently with one query, Frank, but issue the command

    DoCmd.SetWarnings False

    before running your query, and this will stop the warnings appearing.

    But be careful
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

Posting Permissions

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