Finding the Count in an Update Query
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I have an update query that should only have 1 record to update or no records
to update when kicked off by a command button in my form. How can I find the
count of records to be updated to create my own message box, if the count is
zero instead of using the warning message box that Access brings up showing
the number of rows to be updated?
Option 2 How can I edit the message in that message box?
Thanks in advance.
--
SC from Lubbock, Texas
.
Relevant Pages
- Re: Yet another area of interest
... concealed weapon in the state of Texas. ... I doubt Amistad would command it to whack me ... just for amusement. ... Yet you have NO worries that such a thing would happen. ...
(rec.collecting.coins) - Re: update queries and forms
... > should enter an incorrect account number. ... > and makes your validation much easier. ... > OK - so what we want the command button to do is to run the update query. ...
(microsoft.public.access.tablesdbdesign) - RE: Running an Update query before closing a form
... place the following command: ... update query and couldn t save all records because of various violations ... the update query before closing? ... I have not written an SQL in codes. ...
(microsoft.public.access.formscoding) - RE: Event procedure does not execute without break point?????
... I am not familiar with that command. ... > whoever answers will probably ask as I have what you need to accomplish. ... I will further assume that the SQL statement works in an ... >>> update query, but not from a command button. ...
(microsoft.public.access.forms) - Re: When to run an update query from a form?
... > I have a form is used to input data and when the user has input a ... > record we need to run an update query to update another field in the ... > the AfterUpdate property of the form or when all records have been ... Or should we consider a command ...
(microsoft.public.access.forms) |
|
