Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Saturday, August 20, 2016 – Permalink –

Combo Box Queries

How to

Parameter queries add flexibility to filtering records in a database. To make it easy, take a look at this approach from Martin Green's Office Tips site:

Drop down box in a Parameter Query

Build a dialog box with as many combo boxes as you need.

Design a query to read its criteria from the information on the dialog box.

Create a macro or visual basic procedure to tell them both what to do.

Also:
Base Combo Box on Parameter Query to Filter Values

See all Topics access
Labels: Combo, Queries, Reference, Tips, Tutorials

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Sunday, July 24, 2016 – Permalink –

Control Access Text Alignment

Distribute Text Evenly Within Controls

When you add form or report controls, the Text Align property defaults to General setting: characters align to the left while numbers and dates align to the right.

When you set up controls to act as headings or titles, you can achieve interesting visual results by changing the Text Align setting to Distribute (This is called Justify in Word).

This setting distributes characters within the control evenly to span its entire width.

If you apply this setting to a textbox control, the alignment switches to Left alignment when you click inside the control to allow for easy data entry.

General (Default)

The text aligns to the left; numbers and dates align to the right.

Left

The text, numbers, and dates align to the left.

Center

The text, numbers, and dates are centered.

Right

The text, numbers, and dates align to the right.

Distribute

The text, numbers, and dates are evenly distributed.

See all Topics access
Labels: Combo, General, Properties, Reference, Tips, Tutorials

<Doug Klippert@ 3:14 AM

Comments: Post a Comment

Saturday, March 07, 2015 – Permalink –

Cascading Combo Boxes

Everything's connected

"Cascading combo boxes are used to help aid the user in determining a choice when entering data into a form.
They help to breakdown the options available into selectable sub-groups such a State & City, Product Type & Product, Department & Employees.
The user can select, for example, Customer Services in a combo box and the second combo box's list will reflect this selection and only list those employees within Customer Services.

Switch to Finance and all the Finance employees become selectable, etc."

A cascading combo box solution:

Roger J. Carlson

CascadingComboBoxes.mdb (beginner)
CascadingComboInSubform.mdb (intermediate)

See all Topics access
Labels: Combo, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:48 AM

Comments: Post a Comment