update query

[rawandjamal]

i have an access database and it contain table and this table has a large number of record now i have a problem
that is a problem :


in field1 when you see i has a blank cell now i want update this blank cell whith a previous record
i mean i want to update the blank cell whith w,sam and stop it in A,smith and coninues to A,smith and stop in p,edward ....etc
are any code that let me do this whithout manualy because the record is very large
please help

[pbaldy]

To my knowledge, it can't be done with an update query. You can do it in VBA with a recordset loop of the records, making sure they're in order. Set a variable to the first value, then inside the loop test the variable against the current record. If the record field is empty, set it to the variable's value, else change the variable to the field's value (not being empty would indicate a new value). You'll want a recordset and a Do...Loop; more info on both in VBA help if you're not familiar.

[rawandjamal]

thanks mr.paul i think its a solution if i use a vba but can u tell me any website or any thing that tell me how do it with vba code i that is very kind of you if you told me

[kennejd]

You could use an update query....just use the record id for the range of records for your update...then manually put the name you want to update the blank's to. It would work if this is a 'one-time' clean-up. Otherwise you will definitely want some vba code.

[pbaldy]

Here's an example of a recordset loop:

http://www.granite.ab.ca/access/email/recordsetloop.htm