Solved

Update query involving 2 tables

Posted on 2013-05-20
2
295 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Refreshing a form in Access when saving data? 3 42
Adding New Records into SQL Server Table from MS Access 4 30
access 7 21
Access coding 2 7
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now