Solved

Filtering of information of database using other database

Posted on 2011-02-18
8
875 Views
Last Modified: 2012-05-11
hello experts,

I have 2 database (Maindb and weldersdb), and a form (MAINFRM), eventually mainfrm is linked to maindb, now some information i need to show from weldersdb in mainfrm based on the data i typed
example
Weldersdb information

Welders     Process
ERS-001         S
ERS-002         F
ERS-003         S

now, if i type 'S' in the fileds 'process' in mainfrm the welders will show only 'ERS-001' and 'ERS-003', and if i type 'F', 'ERS-002' is the only welders that will show.

Can anybody help me with this.

Thank you

CZHER  
 
0
Comment
Question by:Czher
8 Comments
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 34931527
If you have linked tables, then you can create parameter queries on any field in the table and filter it as you please.

http://www.ehow.com/how_2020612_create-parameter-access.html
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34931529
you create a link from Maindb to the table in weldersdb

file > external data > linked tables


once you have created the link, you can then use the linked  table like a local table
* as a record source of a form
* as row source of a combo/list  box

i don't exactly understand what you meant by this

<now, if i type 'S' in the fileds 'process' in mainfrm the welders will show only 'ERS-001' and 'ERS-003', and if i type 'F', 'ERS-002' is the only welders that will show.>
0
 

Author Comment

by:Czher
ID: 34931557
capricorn1,

in mainfrm there is a fields (welders, date, process),

This is the informaiton you're gonna see in weldersdb

Welders     Process
ERS-001         S
ERS-002         F
ERS-003         S

This is the information you're gonna see on MAINFRM

Welders       Date       Process
ERS-001   01/01/11        S


as ive mentioned above

if i type in mainfrm 'process' = 'S' the welders in combo box that will show is 'ERS-001' and 'ERS-003', but if i typed in mainfrm 'process' = 'F' the welders in combo box that will show is 'ERS-002'

in other words welders that will show only in combo box in mainfrm is depending on the process i will typed.

I hope this is clear

0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 40

Expert Comment

by:als315
ID: 34931912
Can you upload you DB with sample of data?
0
 

Author Comment

by:Czher
ID: 34932281
I uploaded the DB, if you check the Welderdb each welder has a corresponding process, what i want to do in mainfrm is when i type or select in process field 'S' or 'F' or anything, not all welders will show but only those welders with the same process  that i type will only appears.

I hope this file will help you understand what i need.

Thanks
WeldSys.mdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34933175
use this codes in the afterupdate event of combo Process


Private Sub Process_AfterUpdate()
Dim sql
sql = "SELECT ID,Welder, Process"
sql = sql & " FROM WELDERDB Where Process ='" & Me.Process.Column(1) & "'"

Me.Welder.RowSource = sql
End Sub



WeldSys.mdb
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34933342
See my Fancy Filters database for an example of filtering a subform by a number of different values (different data types).  Here is a link for downloading it:

http://www.helenfeddema.com/Files/accarch129.zip

and here is a screen shot of the main form:
Fancy-Filters-Form.jpg
0
 

Author Comment

by:Czher
ID: 34935802
Capricorn1,

Thank you verymuch for the help, but why everytime i add a line and select a process, those previous line i already  selected, the welder is disappearing?
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 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