Append queries

[ckpoll2]

Hello,

Is there a way to get rid of the information boxes when I run an append query? I wand to use it as part of a macro that just happens when it is clicked, but I don't want the user to have to hit OK and Yes to a bunch of information boxes. How can I get rid of this necessity?

Thanks,

Charlie

[ckpoll2]

I just realized that I said append queries, but I actually meant update queries. Any suggestions?

[Denburt]

BE CAREFULL with the setwarnings you might find yourself deleting things and not receiving a prompt.



DoCmd.Hourglass True
DoCmd.SetWarnings False

Your Code here

DoCmd.Hourglass False
DoCmd.SetWarnings True

[ckpoll2]

I'm not sure I understand. The SQL code I have is:

DELETE [Personal Property Hours].[Transaction Number ID], [Personal Property Hours].Date, [Personal Property Hours].Name, [Personal Property Hours].Site, [Personal Property Hours].Type, [Personal Property Hours].[Tech Input Items], [Personal Property Hours].Items, [Personal Property Hours].Hours, [Personal Property Hours].Notes
FROM [Personal Property Hours]
WHERE ((([Personal Property Hours].Type) Is Null));

When I put the top section above it and the bottom below, it gives me an error message. What am I doing wrong?

[Denburt]

What does the error message say? Also if there is a debug button hit it and tell me what line is highlighted.

[nico5038]

The docmd statement is risky as it will (after a dump) stay active.

Personally I prefer to run the query from code like:

currentdb.execute ("<place your query text here within the quotes>")

This won't trigger the messages and not have the disadvantage of the docmd statement.

Nic;o)

[MMcCarthy]

I'm not sure I understand. The SQL code I have is:

DELETE [Personal Property Hours].[Transaction Number ID], [Personal Property Hours].Date, [Personal Property Hours].Name, [Personal Property Hours].Site, [Personal Property Hours].Type, [Personal Property Hours].[Tech Input Items], [Personal Property Hours].Items, [Personal Property Hours].Hours, [Personal Property Hours].Notes
FROM [Personal Property Hours]
WHERE ((([Personal Property Hours].Type) Is Null));

When I put the top section above it and the bottom below, it gives me an error message. What am I doing wrong?

In a delete query you cannot decide to delete certain columns you have to delete the whole record. In other words ...

DELETE * FROM [Personal Property Hours]
WHERE ((([Personal Property Hours].Type) Is Null));
 

Mary