Replacing a field contents 1

[kkarren]

How do I replace the contents of an entire field from 0 to 1 in the events procedures? [sig][/sig]

 

[PaulF]

kkarren Its difficult to figure out exactly what you want to do, if you could provide addtional information, we might be able to assist you.

PaulF [sig][/sig]

 

[kkarren]

I have a text file that I import. There is a blank field in the import that sets to 0 each time I do the import. After the import is completed I want to change the 0 to 1 in all records in the table. What syntax can I use to change all of the records to 1. Thanks for your help. [sig][/sig]

 

[JARE]

Something like this should work, just call from your
macro. replace IMPORT with your table name and Myfield
with the field name


Dim Myrs As Recordset

Set db = CurrentDb
Set Myrs = db.OpenRecordset("select * from IMPORT&quot
Myrs.MoveFirst

Do While Not Myrs.EOF
Myrs.Edit
Myrs!Myfield = 1

Loop [sig][/sig]