reset fields in multiple records

  • Thread starter Thread starter Vandenee
  • Start date Start date
V

Vandenee

Hi,

I have an application where I have defined a field (yes/no). In a form
this checkbox can on or off .
I would like to have a button in this form which will reset this field
for all the records.
Is this possible?
 
Vandanee,
Use a button to run an Update Query. This sample Update query changes
the [TestYN] in tblCustomers to all True.

Private Sub cmdSetTestYNToTrue_Click
DoCmd.RunSql "UPDATE tblCustomers SET tblCustomers.TestYN = True;"
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
 
Vandanee,
Use a button to run an Update Query. This sample Update query changes
the [TestYN] in tblCustomers to all True.

Private Sub cmdSetTestYNToTrue_Click
DoCmd.RunSql "UPDATE tblCustomers SET tblCustomers.TestYN = True;"
End Sub
--
hth
Al Campagna
Microsoft Access MVPhttp://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."




Hi,
Click to expand...
I have an application where I have defined a field (yes/no). In a form
this checkbox can on or off .
I would like to have a button in this form which will reset this field
for all the records.
Is this possible?- Tekst uit oorspronkelijk bericht niet weergeven -
Click to expand...

- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

Al,

Thanks for your suggestion, it did the job.

Michiel
 
Back
Top