Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

Filtering of information of database using other database

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
Czher
Asked:
Czher
1 Solution
 
Jerry MillerCommented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
CzherAuthor Commented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
als315Commented:
Can you upload you DB with sample of data?
0
 
CzherAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
Helen FeddemaCommented:
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
 
CzherAuthor Commented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now