473,230 Members | 1,855 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

Yet another Query Linking Question

I'm sorry to populate the server with yet another question about
linking multiple tables and queries, howerver I have not been able to
find the right criteria.

My problem.

I am trying to either link 3 tables together in a select query, and
maintain the editablity that I get when linking two tables and creating
a form. I know there is a way to link 3 tables through multiple queries
however I have yet to be able to get it to work.

More specifically.

I have a form that only requires two tables to come together through a
query, this way the form or records are editable. My report for this
form has one function bound (unbound with a function in the control
source) text box that requires I pull information from a table outside
of my two table query form. I am a beginner and have no clue as how to
write code. So is there a way to reference information stored on a form
that is closed at the time it is needed to be accessed, through the
control source or a macro? Please let me know if you need for
information. Thanks again everyone.

Nov 13 '05 #1
1 1976
I don't know all of the specifics, however, if you need to pull a value from
a table outside the record source query, one alternative would be to use the
DLookup function. The third parameter of this function allows you to
specify the criteria for the value, which you can tie to one or more fields
in your record source query. Depending on the exact circumstances, this
would have the same effect as joining the table with the other two in the
record source query. The following link gives more information on the
DLookup function.

http://msdn.microsoft.com/library/de...HV05187182.asp

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
<hm*****@hartford.edu> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I'm sorry to populate the server with yet another question about
linking multiple tables and queries, howerver I have not been able to
find the right criteria.

My problem.

I am trying to either link 3 tables together in a select query, and
maintain the editablity that I get when linking two tables and creating
a form. I know there is a way to link 3 tables through multiple queries
however I have yet to be able to get it to work.

More specifically.

I have a form that only requires two tables to come together through a
query, this way the form or records are editable. My report for this
form has one function bound (unbound with a function in the control
source) text box that requires I pull information from a table outside
of my two table query form. I am a beginner and have no clue as how to
write code. So is there a way to reference information stored on a form
that is closed at the time it is needed to be accessed, through the
control source or a macro? Please let me know if you need for
information. Thanks again everyone.
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Joe Makowiec | last post by:
MySQL 4.14 on FC4 I have a database for a soccer team; simplified: Roster - serial (bigint) - name (varchar) goals - serial (bigint) - gameNumber (bigint) // for linking to a schedule
4
by: sheree | last post by:
I have 3 tables (amoung a few others) in a small access database. The tables are as follows: == AEReport -------- AEID (PK) RptCatelog GCRCID PatientID EvntDate
6
by: Rudy Ray Moore | last post by:
I work with a multi-project workspace. One project (the "startup" project) has a "Configuration Type" of "Application (.exe)". The other 40 projects have a "Configuration Type" of "Static Library...
7
by: J-P-W | last post by:
Hi, in the past I've spent ages writing VB routines to get around this problem, is there a simple way? I have three tables for a membership system: tblMembership - MembershipNumber; Names etc...
2
by: jalmar | last post by:
Hello....I'm back again with the same question. I still haven't been able to figure out why my query isn't working. I am linking a table to an Excel spreadsheet, that part is fine, it is even...
11
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
11
by: Stuart Owen | last post by:
Hi, I'm a relative beginner to Access, and have just found out how to construct a 'query by form' using the SQL, Select/From/Where approach. With the addition of a few wildcards, I've got a form with...
6
by: Darren | last post by:
I'm trying to build a query but struggling on how to achieve the linking. For examples, I have a table and a view similar to this.. Table: Accounts ACC_REF Char(3), DESCRIPTION VARCHAR(30),...
4
by: franc sutherland | last post by:
Hello, I am using Access 2003. I am having trouble trapping the "can't append all the records in the append query" error message when appending data to a query from a table which is linked to...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.