By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Update Query with serialized Field

P: n/a
Hello -

I am trying to execute an update query, updating 4 fields in one table.
Is there a way that I can enter the first value for each field, and
then serialize the first field for a given qty, while duplication the
other 4? I want to avoid having to enter every single record manually.

Example:

Serial Batch Part Tech
123 500 A1 ABC
124 500 A1 ABC
125 500 A1 ABC
Thanks!

Apr 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
the way I usually handle this is to create an unbound form and then
write some code to loop from StartSerial to EndSerial and then just use
a recordset to fill the table.

for lngSerial = val(me.controls("StartingSerialNo")) to
val(me.controls("EndingSerialNo"))
rs.AddNew
rs.Fields("Serial")=lngSerial
rs.Fields("Batch")=me.Controls("txtBatch")
rs.Fields("Part")=me.Controls("txtPart")
rs.Fields("Tech")=Me.Controls("txtTech")
rs.Update
next lngSerial

Apr 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.