Customs system message on Update Query

Question

Hello,

I have created an update query that clears all check boxes on one field. I would appreciate guidance if anyone has done this before on how to customize the msg that comes up after click to run UPDATE query. In addition, in instances when all the checkboxes are cleared for that particular field, there is a system msg that comes up "Microsoft Access can't update all the records in the update query". Any suggestions on how I can handle this error.

Thanks.

Answer 1

Understood.

As requested Here is the SQL text:

UPDATE [TBL_CreditSales] SET [TBL_CreditSales].PrintRep = "";

I have a button on my CreditSales FRM to which I have assigned an OpenQuery macro to execute the update query. I should note that once the query runs it updates the records on the form without any issue at all. What I need help on is how to customize the messages and handle situations where there are 0 record to update.

Answer 2

Correct the error in the query, or in the context (when and how the query is run).

For help doing so please open the query in SQL view and post the SQL text here, and tell us (in detail, not just "from a form") how you are running the query. 

Do note that an UPDATE query will not be able to update a record if it is currently open for update on a Form; I suspect that's the source of the error here. You may need to move off the current record before running the query.

Answer 3

Iam executing the query via a form

Answer 4

You can suppress that message, but not change it. We need to see your code that is running the Update query.

Answer 5

How are you executing the query? If you're using a form, there may be a way to trap the error.