Button to export and run update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

socasteel21 - 03 Apr 2006 14:34 GMT

I have a database that is used to process warranty claims. Each record in my
main table (tblClaim) represents a claim. Each claim has a status of Paid,
Unpaid, or Pending. I would like to add a button that would automatically
export a query containing all information that our accounting department
would need. It would also need to run an update query (which I have already
built) that changes all "Unpaid" claims to "Paid" and inserts the current
date into a field called "Export Date".

As an extra safeguard, I would like to have a Message box that asks if I'm
sure if I would like to continue with two buttons "Yes" and "No". Lastly, I
don't want any other users to be able to use this button.

Any help would be appreciated.

Thanks,

Shannan

Reply to this Message

David Mitchell - 05 Apr 2006 23:14 GMT

Shannan, you need to be a bit more specific. What information do your
Accounts Dept require? Is it based on one record that you are viewing
or all records? What criteria is your update query based on? I assume
that it will only select those that have been paid and change them from
"unpaid" to "paid"? If so perhaps a bit of code in the after update
event of the field would change the claim to "paid" without the need of
a query.

Finally, do you have some sort of login for the others who use the
database so you can prevent anyone else using the button by limiting
there access or view of it?

David A Mitchell

Reply to this Message