By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,728 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 IT Pros & Developers. It's quick & easy.

Excel like autofilter query

P: n/a
CCC
Our company have used Excel to filter out documents base on date,
from_company, type_of_document, country to generate a list of where
the documents physical location is. The number of records have grown
to 8000 and I think it is time to use Access 2000 to handle those
records.

I am completely new to Access. So far I managed to make the selection
in combobox1 narrow down the list in combobox2, and combobox2 narrow
down combobox3 and so on. by adding some code in the afterupdate
property and source field of each combobox.

I am stuck on

1) how do I similate Excel autofilter feature that you don't need to
make your selection sequentially. for example, you can make selection
in any field and all other field's list is updated.

2) After I have made all the correct choice in each combobox of the
form I create, how do I list all records that match the query, and
print it out?

I have studied Access for 2 weeks and is completely clueless. Please
show me the direction.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try Filter by Form. Form the Access Help file:

"Filter By Form: A technique for filtering data that uses a version of
the current form or datasheet with empty fields in which you can type
the values you want the filtered records to contain."

On main menu select: Records > Filter > Filter by Form.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQfXerIechKqOuFEgEQLHNQCgljR02NwNpWMb1inDNlS9zB vLa2cAnR9a
Rzk90Bkwy0/Hp1OG4PIyvgA0
=fH0R
-----END PGP SIGNATURE-----
CCC wrote:
Our company have used Excel to filter out documents base on date,
from_company, type_of_document, country to generate a list of where
the documents physical location is. The number of records have grown
to 8000 and I think it is time to use Access 2000 to handle those
records.

I am completely new to Access. So far I managed to make the selection
in combobox1 narrow down the list in combobox2, and combobox2 narrow
down combobox3 and so on. by adding some code in the afterupdate
property and source field of each combobox.

I am stuck on

1) how do I similate Excel autofilter feature that you don't need to
make your selection sequentially. for example, you can make selection
in any field and all other field's list is updated.

2) After I have made all the correct choice in each combobox of the
form I create, how do I list all records that match the query, and
print it out?

I have studied Access for 2 weeks and is completely clueless. Please
show me the direction.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.