The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Merging Filters

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Merging Filters

Resolved · Urgent Priority · Version 2003

ReplyThu 14 May 2009, 11:03Delegate Vinay said...

Merging Filters

I have created about 4 combo box drop down filters on a form, but i would like to know how to merge them so i can Select information from one filter, and then another filter which will eliminate results.

What is the easy way to do this? and how can I do this?

Please Help

For upcoming training course dates see: Pricing & availability

ReplyFri 15 May 2009, 12:02Trainer Jacob said...

RE: Merging Filters

Hi Vinay

To help you with this request we can either work on your database remotely and deliver the result, though you won't have knowledge as to how this was done.

Alternatively you will be able to gain the necessary skills by attending our 2 day MS Access VBA course.

Regards

Jacob

Fri 22 May 2009: Automatically marked as resolved.

Access articles

· Help Business To Go Global With Shared Databases
· How To Use A Parameter Query In Access
· A Greater Understanding Of Your Business With Access Reports
· How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?
· Discover The Easy Way To Create And Modify A Table In Access 2010

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

How do I create a page number for each tab in a workbook i.e. tab 1 is Page 1 of 6, tab 2 is Page 2 of 6, tab 3 is page 3 of 6 e.t.c.

» Forum post: Page numbers for each tab

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions