Re: How to run a Query from code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I was missing the quotes

Thanks

"Dave" <dave@accessdatapros> wrote in message news:A537C470-AA7A-4FFC-AFCF-C724FFD141A2@xxxxxxxxxxxxxxxx
Access 2007

trying to run an Update query in the on click event of a button (in an If function)

This is what I am using

DoCmd.OpenQuery qryDeleteCallerInfo

do I have the syntax wrong?

Also: Is this correctly written
DoCmd.SetWarnings = True

I want to turn the warnings off once I have the query working properly

Any help here will be appreciated.

Thanks in advance


.

Relevant Pages

  • FPDB: Parameter Update Not Working When Non-Param Works
    ... I have an update query ... The first one gives an error message of: ... Database Results Wizard Error ... I do not get any message about a missing parameter (which you usually get if ...
    (microsoft.public.frontpage.client)
  • Re: brand new here
    ... Takeadoe wrote: ... I'm at the entry level right now, ... (it was missing in the source). ... update query to change the null values to 2005 ...
    (comp.databases.ms-access)
  • Re: SQL Error Help
    ... What you are missing is that an INSERT statement adds records. ... OR perhaps you want an UPDATE query and not an insert query? ... Run-time error 3137: ... Missing semicolon at end of SQL statement ...
    (microsoft.public.access.queries)
  • My function returns true but my code does not execute
    ... I must be missing something obvious. ... I cannot get this function to run the update query on Line 6, ... J Moore ... Prev by Date: ...
    (comp.lang.php)
  • Re: Export to a text file question
    ... it's pretty easy to slap together an UPDATE query that ... >carriage returns. ... >> Dave wrote: ...
    (microsoft.public.access.queries)