Solved

Update query involving 2 tables

Posted on 2013-05-20
2
298 Views
Last Modified: 2013-05-20
access 2013

I have database:
2 tables

tbl_Slang
3 fields
id-autonumber
fldSlang -text
fldDescriptor - text

tbl_Data
3 fields
id-autonumber
fldDescriptor
fldTerm

fldDescriptor is the common field between the two tables




What I need:
I need a vba routine that will update a field in tbl_Data(fldTerm)
with the data from the field fldSlang from the tbl_Slang Table


tbl_Slang:
fldSlang                                     fldDescriptor
TUG BOATS                                Switch Grip-lok Handy Box
TUGGER                                       Cable Puller
VERMITTI                                        Platform Lifter
WHIP                                          Electrode Holder

Before Update:


tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box
Cable Puller
Platform Lifter
Electrode Holder


After Update:

tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box           TUGBOATS
Cable Puller                                  TUGGER
Platform Lifter                              VERMITTI
Electrode Holder                           WHIP

Thanks
fordraiders
0
Comment
Question by:fordraiders
2 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 39182201
See if this works for you:
UPDATE tbl_Data INNER JOIN tbl_Slang ON tbl_Data.fldDiscriptor = tbl_Slang.fldDescriptor SET tbl_Data.fldTerm = [tbl_Slang]![fldSlang];

Open in new window

Flyster
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 39182275
Thanks very much
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question