Full Version: Deleting a field entry in table
UtterAccess Forums > Microsoft® Access > Access Forms
gear
I have searched the forum but could not get the answer.
I have two fields in table
REVIEW – Checkbox (Yes/No field)
REVDATE – Date field
This is a reminder service where the user checks the box and enters the date by which certain action is required. When DB is opened a list pops up if there is anything for review on that day. If action is completed, user unchecks the box and deletes the date.
Most of the times, action for all items in the list are complete and user clears the field entries one by one. I would like to automate this through a command button so that REVIEW and REVIEWDATE in the Reminder List is cleared in one go. Grateful for code help.
HiTechCoach
I would use an update query.

Maybe something like:

CODE
If Me.Dirty Then Me.Dirty = False
CurrentDb.Execute "UPDATE MyTable SET  REVIEW  = No, REVDATE  = Null WHERE  REVDATE  = Date();"
Me.Requery




Edited by: HiTechCoach on Sun Feb 24 23:08:35 EST 2008.
gear
Thanks a lot
It is working
HiTechCoach
You're welcome!
Glad we could assist.
uarulez2.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.