loop through records

Greetings.
Could anyone please help me on this, I have a table that contains a
true/false field. Upon extracting several "false" records by means of a
query how do I make a procedure/macro that would automatically loop through
the records and replace the "false" with "true"

Thank you

There's no need to loop through a recordset; you can use set processing to
get the job done in a fraction of the time it would take using row
processing. In other words, use an action query:

Dim sSQL As String
sSQL = "UPDATE myTable SET myField = False WHERE myField = True"
CurrentDb.Execute sSQL, dbFailOnError
'All done! :-)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"The Iconoclast" wrote in message
...
Greetings.
Could anyone please help me on this, I have a table that contains a
true/false field. Upon extracting several "false" records by means of a
query how do I make a procedure/macro that would automatically loop
through
the records and replace the "false" with "true"

Thank you

All done, except for the fact that you antipodeans always get things
backwards. Must come from walking around upside down... g, d & r

The request was to 'replace the "false" with "true"', so you'd want

sSQL = "UPDATE myTable SET myField = True WHERE myField = False"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Graham R Seach" wrote in message
...
There's no need to loop through a recordset; you can use set processing to
get the job done in a fraction of the time it would take using row
processing. In other words, use an action query:

Dim sSQL As String
sSQL = "UPDATE myTable SET myField = False WHERE myField = True"
CurrentDb.Execute sSQL, dbFailOnError
'All done! :-)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"The Iconoclast" wrote in message
...
Greetings.
Could anyone please help me on this, I have a table that contains a
true/false field. Upon extracting several "false" records by means of a
query how do I make a procedure/macro that would automatically loop
through
the records and replace the "false" with "true"

Thank you

What's 32768 between friends?

-Thanks Doug!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Douglas J. Steele" wrote in message
...
All done, except for the fact that you antipodeans always get things
backwards. Must come from walking around upside down... g, d & r

The request was to 'replace the "false" with "true"', so you'd want

sSQL = "UPDATE myTable SET myField = True WHERE myField = False"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Graham R Seach" wrote in message
...
There's no need to loop through a recordset; you can use set processing
to get the job done in a fraction of the time it would take using row
processing. In other words, use an action query:

Dim sSQL As String
sSQL = "UPDATE myTable SET myField = False WHERE myField = True"
CurrentDb.Execute sSQL, dbFailOnError
'All done! :-)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"The Iconoclast" wrote in message
...
Greetings.
Could anyone please help me on this, I have a table that contains a
true/false field. Upon extracting several "false" records by means of a
query how do I make a procedure/macro that would automatically loop
through
the records and replace the "false" with "true"

Thank you