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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1