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

VBA Code Help in Access 2003

P: 1
I am not a Programmer, but need some serious help with a syntax format for VBA in Access 2003.

I need to update/copy the contents of a single record field to many records with the same field name. The number is unique.
Example: Copy the contents of tblLocation.LocNum in one record to tblProduct.LocNum in 3 records.
Explanation: The contents of that inital field need to be copied to another table with the same field as long as the field is empty.

I know this is a simple task but I can't find the explanation in the reference books I am using.

Any help would be greatly appreciated. If anyone is willing, I have a second issue that is a bit more difficult.

Thanks,
*Jason. in Indy
Oct 17 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
UPDATE tblProduct INNER JOIN tblLocation ON tblProduct.LocNum = tblLocation.LocNum SET tblProduct.FieldName1 = [tblLocation].[FieldName1], tblProduct.FieldName2 = [tblLocation].[FieldName2], etc ;



I am not a Programmer, but need some serious help with a syntax format for VBA in Access 2003.

I need to update/copy the contents of a single record field to many records with the same field name. The number is unique.
Example: Copy the contents of tblLocation.LocNum in one record to tblProduct.LocNum in 3 records.
Explanation: The contents of that inital field need to be copied to another table with the same field as long as the field is empty.

I know this is a simple task but I can't find the explanation in the reference books I am using.

Any help would be greatly appreciated. If anyone is willing, I have a second issue that is a bit more difficult.

Thanks,
*Jason. in Indy
Oct 17 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.