Hello,
I am currently doing a project on Access and am current stuck in the
"search" process and hoping that you could help me out.
I have got 3 tables designed.
When the user clicks on search option based on the record # (not a
combobox), services, location, date (all combo boxes) the particular
record that is stored in the 'allinfo' table should be displayed. I
would like to know how to fetch the particular record as the service
details are in another table called "service" and the allinfo table
contains only the service id. If a user selects a service, how do I
get the service details, location details, and all the other record
details that are present in the allinfo table. I would like to know
how to use a multi-table query, so I can include fields from all the
related tables needed to search.
Code would be of great help.
Thanks in advance,
vk
1  1472 
VK wrote: Hello,
I am currently doing a project on Access and am current stuck in the
"search" process and hoping that you could help me out.
I have got 3 tables designed.
When the user clicks on search option based on the record # (not a
combobox), services, location, date (all combo boxes) the particular
record that is stored in the 'allinfo' table should be displayed. I
would like to know how to fetch the particular record as the service
details are in another table called "service" and the allinfo table
contains only the service id. If a user selects a service, how do I
get the service details, location details, and all the other record
details that are present in the allinfo table. I would like to know
how to use a multi-table query, so I can include fields from all the
related tables needed to search.
Code would be of great help.
Thanks in advance,
vk
The first thing that comes to mind is to hire a programmer fron this
newsgroup.
You have a table callid AllInfo that contains 1 field which is the Key.
This should be linkable to your service and location detail tables.
You could create a form for listing service details. Then create
another form for location details. Then create a form where the
recordsource is AllInfo and drop in the Service and Location forms. The
common link would be the key in AllInfo.
Your problem is difficult to understand. You could take the concept
above and expand on it. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John Flynn |
last post by:
hi all
i'm going to be quick i have an assignment due which i have no idea how to
do. i work full time so i dont have the time to learn it and its due date
has crept up on me ..
As follows:
Objectives
The purpose of this assignment is to have you practice the design of
object-oriented classes, including one or more of the following concepts
|
by: Rich |
last post by:
Hello,
When I copy a VB web app from my workstation to my laptop (which has the
exact same software as the workstation) or to a different virtual directory
on the same workstation and then try to open the vbProj at this new location,
I get the error message that it can't open the app because some components
may be missing. If I create the same project at the new location from
scratch, it runs fine.
Is there a configuration or some...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: skumar434 |
last post by:
i need to store the data from a data base in to structure
.............the problem is like this ....suppose there is a data base
which stores the sequence no and item type etc ...but i need only the
sequence nos and it should be such that i can access it through the
structure .plz help me .
|
by: narpet |
last post by:
Hello all.
I have a table in Access that has a check box as one of the fields. I want to write a query or code that will check or uncheck that box based on conditions met by other fields in the table. Here are the specifics as well as I can explain it:
I have the following table fields:
EmployerID
Group
Payroll
Yes/No
| | |
by: U S Contractors Offering Service A Non-profit |
last post by:
Brilliant technology helping those most in need Inbox
Reply
U S Contractors Offering Service A Non-profit
show details
10:37 pm (1 hour ago)
Brilliant technology helping those most in need Inbox
Reply
from Craig Somerford <uscos@2barter.net>
hide details 10:25 pm
(3 minutes ago)
|
by: mike |
last post by:
I help manage a large web site, one that has over
600 html pages... It's a reference site for ham radio
folks and as an example, one page indexes over
1.8 gb of on-line PDF documents.
The site is structured as an upside-down tree, and
(if I remember correctly) never more than 4 levels.
The site basically grew (like the creeping black blob) ...
all the pages were created in Notepad over the last
|
by: John Forrest Tomlinson |
last post by:
On Fri, 7 Nov 2008 02:24:45 -0800 (PST), tg <D2Zabcdef@googlemail.com>
wrote:
Do you mean, a pro-apartheid member of parliament? Niiice.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
