Re: Append query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes Both Append queries run just fine if I just run them from main screen or
from design view. I'll take out the warning.

Ken



"Douglas J Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:eH1iHKjEGHA.2012@xxxxxxxxxxxxxxxxxxxxxxx
> Sounds as though there's something wrong with qryApndIndTable. Does the
> query run if you try running it by itself?
>
> (BTW, you don't need the DoCmd.SetWarnings False and DoCmd.SetWarnings
> True
> if you're using the Execute method)
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Ken Ivins" <ken-27@xxxxxxxxxx> wrote in message
> news:uSK8MBjEGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
>> I am trying to run an Append query from VBA code. Below is the code. I
> used
>> this in the same database to run a delete Query using this code and it
> works
>> great. I just replaced the query name. Now I get a 'Run Time Error 3061
> Too
>> few parameters 1" .
>>
>> Any idea what my problem is?
>>
>> Dim Db As Database
>> DoCmd.SetWarnings False
>>
>> Set Db = CurrentDb()
>>
>> Db.Execute "qryApndIndTable", dbFailOnError
>>
>> DoCmd.SetWarnings True
>>
>>
>> thanks,
>>
>> Ken
>>
>>
>
>


.

Relevant Pages

  • Re: Adding auto-numbered field screws up Table order
    ... Append Queries are very simple, and part of the standard methodology ... Access's query designer is one of the great features. ... I know of no desktop database application tool with the equivalent power ... > things, like finding/isolating/deleting duplicates when ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2000 Make Table Query Warning Box -- use currentdb.execute
    ... currentdb.execute "SQL or action queryname" ... When this query is run, and before it asks the user for the input, I get a warning message that says that the query is about to replace the table with new data, and is the user ok with that?, yes or no. ... As the database designer, I know to answer yes, and it goes through the function with no issues. ...
    (microsoft.public.access.queries)
  • Re: Problem with security permissions being reset for users
    ... Append queries. ... database due to a make-table query that is fired by the ... "Autoexec" macro (anything in a macro with this name fires when the database ... At first I set the Read-Only permission to this table at least to ...
    (microsoft.public.access.security)
  • Re: Cant Update Records
    ... >I've now put both tables in the same database ... You're apparently assuming either that you are the only person asking ... >when I try to edit...I get a warning that someone else has edited the record ... If you'ld care to post the SQL of the query, ...
    (microsoft.public.access.forms)
  • Re: Warn me Not
    ... Use Dirto test if the target file exists. ... Kill it before executing your query. ... I am taking a table in one database and, using a make table query, ... Deletions did not seem to eliminate the warning. ...
    (microsoft.public.access.queries)