Re: Access 2000 Make Table Query Warning Box -- use currentdb.execute

Hi Jennifer

instead of using DoCmd, use this form

currentdb.execute "SQL or action queryname"

this operates as
docmd.echo false
docmd.setwarnings false
docmd.openquery qname
docmd.echo whatever it was
docmd.setwarnings whatever it was


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

ProCad Jen wrote:
I am using Access 2000. I love this program, except.....

I have create a couple of make table queries which ask for input from the user. 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.

I don't WANT the warnings to show up, so I went into the Tools>Options>Edit/Find and cleared the "Action Queries" box under the confirm section. I have applied it. I have ok'd it. I have done this on every possible table, query, form etc. that is involved with these two queries. (not that it is a different menu with each one, but I was grasping at straws.) I have restarted the program multiple times. I have rebooted the computer multiple times.

The check boxes are EMPTY, but the warnings keep coming up. Is this a problem with Access? or am I missing something. I will be authorizing non-Access users to enter data into this database; I have been working on this massive user-friendly, smooth-flowing database for almost two months, and I don't want to have to say "just answer "yes" to the warning - I can't make them go away."

If anyone knows of a fix, or SOMETHING to make these things go away, please share!!!

Jennifer

.

Relevant Pages

  • 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)
  • Re: SQL statement in Perl doesnt work
    ... The last answer by Brian McCauley made me look again at the query result from the database. ... By changing the range of records I got the results I expected in the first place, so I apparently misinterpreted the warning. ...
    (comp.lang.perl.misc)
  • Re: Append query
    ... Yes Both Append queries run just fine if I just run them from main screen or ... I'll take out the warning. ... >> I am trying to run an Append query from VBA code. ... >> this in the same database to run a delete Query using this code and it ...
    (microsoft.public.access.formscoding)
  • Cross-product and join question
    ... I'm designing a query with DBArtisan against a Sybase database. ... I receive the following 'Warning' from DBArtisan: ...
    (comp.databases.sybase)