Tablecreate Query

[Great_milenko]

I've made a form that when it saves executes a tablecreate_query,
because this table already excists and has to to be ovewritten it
gives a prompt message that it deletes the table, my question now is
how to remove this prompt message? I've managed to remove all the
other prompt messages when it saves and stuff by just deselecting this
options in the access menu bar but that doesn't remove this one

[Bas Cost Budde]

Great_milenko wrote:

I've made a form that when it saves executes a tablecreate_query,
because this table already excists and has to to be ovewritten it
gives a prompt message that it deletes the table, my question now is
how to remove this prompt message? I've managed to remove all the
other prompt messages when it saves and stuff by just deselecting this
options in the access menu bar but that doesn't remove this one

Maybe it helps if you delete the table before you execute the query? I
think the statement is

docmd.deleteobject actable,"yourTableName"

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

[MacDermott]

Are you really creating a table with the same name, but different fields?
If the fields are the same, it will be faster to run a Delete query followed
by an Append query.

Also -
Have you removed the checkbox beside Confirm - Document Deletions on the
Edit/Find tab of your Options dialog?

- Turtle

"Great_milenko" <ki**********@hotmail.com> wrote in message
news:ae**************************@posting.google.c om...

I've made a form that when it saves executes a tablecreate_query,
because this table already excists and has to to be ovewritten it
gives a prompt message that it deletes the table, my question now is
how to remove this prompt message? I've managed to remove all the
other prompt messages when it saves and stuff by just deselecting this
options in the access menu bar but that doesn't remove this one