W
Wayne Emminizer
I have 35,000 records with 10 columns of specifications.
For each specification there is an abbreviation. For
example Fillet is Flt. I have written the code to grab
those abbreviations and concatenate them into one
description field (NewItemName). This works fine. My
problem is that it is pulling the abbreviations for the
current record in the form and updating all of
the "NewItemName" fields to this same description. How
do I make it check the specs for each record and update
that records NewItemName value to reflect the specs of
that record only. The code is below:
DoCmd.RunSQL "UPDATE tblItemMaster SET NewItemName='" &
sqlString & "'" & "WHERE [ManagementGrp]='01';"
The concatenated name is called "sqlString". For testing
purposes I am working on this in a group at a time
(ManagementGrp).
Any ideas would be greatly appreciated....thanks
For each specification there is an abbreviation. For
example Fillet is Flt. I have written the code to grab
those abbreviations and concatenate them into one
description field (NewItemName). This works fine. My
problem is that it is pulling the abbreviations for the
current record in the form and updating all of
the "NewItemName" fields to this same description. How
do I make it check the specs for each record and update
that records NewItemName value to reflect the specs of
that record only. The code is below:
DoCmd.RunSQL "UPDATE tblItemMaster SET NewItemName='" &
sqlString & "'" & "WHERE [ManagementGrp]='01';"
The concatenated name is called "sqlString". For testing
purposes I am working on this in a group at a time
(ManagementGrp).
Any ideas would be greatly appreciated....thanks