Filters on a table only or not?

iaccess14 · Mar 21, 2014

Hi I'm a newbie with Access, so my question may be silly.

I've been asked to try to propagate a filter result on all the tables on a database. Hence I'm trying to know if the action of a filter works on a single table only, or if it can work on more than one.

Can anyone help me?

Thx a lot.

jdraw · Mar 21, 2014

Please provide more details. What exactly are the instructions you ae being asked to follow?

You are going to have to get an example --before and after - so that readers can understand what you are trying to do.

iaccess14 · Mar 21, 2014

Thx a lot for the answer.
I try to explain better (i'm not mothertongue). The database of which I'm talking to collects informations about companies (name, phone, address...). In the first table of the database there's a filed called Sector, used to save the information about the sector in which the companies operate (energy, gas & power...) in the second table there's a list of names and contacts of people who work in these companies. I need to know if, filtering the Sector on the first table, I can obtain the contacts of the resulting companies on the second table.

jdraw · Mar 21, 2014

In overview, you have a database. The database has a number of tables. Each table deals with a specific subject, and each table contains information about that subject. Each record in the table represents 1 instance of the subject. For example, the Company table contains information about Companies. Each Company has a unique identifier that identifies one company from all others. The identifier of the company is also in the Contact table signifying that this Contact is related/associated with this Company. Similarly the Sector table relates one or more Sectors to a specific Company.

So,yes you can "FILTER" information in the various tables such that it is all related to a specific Company. This is done by means of Queries.

Again in general terms you could say:

Select the ContactInfo, the SectorInfo and CompanyInfo
from the tables WHERE the Sector = "Oil and Gas"

It is very possible to do this.

iaccess14 · Mar 21, 2014

I do thank you. So you confirm what I suspected: I must necessarily make a query if I want to perform a "filter" that involves more than a table; the perplexity I had was due to the fact that my boss asked me to try to perform the same operation, not by making a query, but just using the filter option.

Thx again.

jdraw · Mar 21, 2014

Check youtube for query tutorials.
Here's one

iaccess14 · Mar 21, 2014

You're really nice, I take a look at the tutorial you suggested me.

Thx.

Simon_MT · Mar 23, 2014

Propagating a Fliter can be done:

Code:

Private Function ClientsFilter() As String

    With CodeContextObject
        ClientsFilter = .Filter
    End With
End Function

Then when opening another Form:

Code:

Function ClientsInterestClient() As String

    With CodeContextObject
        If .[ClientSingle] = True Then
            DoCmd.Close acForm, "Clients Details"
        Else
            DoCmd.OpenForm "Clients Interest Enquiry", acNormal, "", ClientsFilter, acFormEdit, acWindowNormal
            Forms![Clients Interest Enquiry]![CloseInterest].Visible = True
            DoCmd.GoToRecord acDataForm, "Clients Interest Enquiry", acGoTo, .CurrentRecord
            DoCmd.Close acForm, "Clients Details"
        End If
    End With
End Function

The GotoRecord moves to the record in the previous form and as the ClientFilter is the same the same record will be found.

Simon

Filters on a table only or not?

iaccess14

Registered User.

jdraw

Super Moderator

iaccess14

Registered User.

jdraw

Super Moderator

iaccess14

Registered User.

jdraw

Super Moderator

iaccess14

Registered User.

Simon_MT

Registered User.

Similar threads

Users who are viewing this thread