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!

Thursday, March 31, 2011 – Permalink –

Insert Line Breaks with Code

Label Captions

If you've ever needed to insert line breaks in a message box prompt, you most likely built a string that incorporated a line feed or carriage return character. Unfortunately, label objects aren't as forgiving when it comes to using these characters.

If you're setting a label's Caption property with code, you'll find that the special control characters are interpreted as squares, since they're otherwise un-displayable.
To successfully insert a line break in a label caption, you need to include both a line feed character and a carriage return character, entered consecutively.

To do so, you can use the Chr() function, such as:

Me.Label1.Caption = "Line 1" & _ Chr(13) & Chr(10) & "Line 2"

However, you can also simplify your code using an built-in constant:

Me.Label1.Caption = "Line 1" & vbCrLf & "Line 2"

See all Topics access
Labels: Customize, General, Tips, VBA

<Doug Klippert@ 3:29 AM

Comments: Post a Comment

Wednesday, March 30, 2011 – Permalink –

Zoom Box

Better view

Access does not provide much room to enter long expressions in queries, forms, or reports.
You can drag the column wider, but there is a neater, quicker method.

With the insertion point in the field, hit: SHIFT+F2.
A Zoom box opens. Enter the formula and hit OK.

BTW: If you enter Field names in the Zoom box without square brackets. If the fields are recognized, Access will add the brackets.

See all Topics access
Labels: Entries, General, Shortcuts, Tips

<Doug Klippert@ 3:27 AM

Comments: Post a Comment

Wednesday, March 23, 2011 – Permalink –

Place Controls Exactly Where You Want

Works with other apps as well

The Snap To Grid feature is an invaluable tool for aligning controls when you're designing forms and reports. However, when you fine-tune the placement of some controls, you'll probably want to move some of them to positions that aren't exactly aligned with the design grid.

You can temporarily disable the Snap To Grid feature by holding down the [Ctrl] key. Then, you can use your mouse or the cursor arrows to place the controls exactly where you want them.

See all Topics access
Labels: Customize, Forms, General, Tips

<Doug Klippert@ 3:26 AM

Comments: Post a Comment

Thursday, March 17, 2011 – Permalink –

Hardcopy Relationships

Document database

When you're documenting your database applications, you may want to include the same visual diagram of your table relationships that's available through the Relationships window.
In Access 2000 thru 2003, this is easy. Simply display the Relationships window as usual and then choose File>Print Relationships from the menu bar. Doing so displays a report preview that you can then print or save.

In 2007-10, to just print out a report, find Database tools on the Ribbon and click on Database Documenter.

Relationships are at the bottom of the All Object Types tab

See all Topics access
Labels: General, Relationships, Reports, Tips

<Doug Klippert@ 3:37 AM

Comments: Post a Comment

Tuesday, March 08, 2011 – Permalink –

Startup Switches for Access

Your choice

"This article shows you how to customize the way that Microsoft Office Access 2007 starts by adding switches and parameters to the startup command. For example, you can have Office Access 2007 open a specific file or run a specific macro when it starts."

Office.Microsoft.com

Also:

Support.Microsoft.com
VB123.com

See all Topics access
Labels: Customize, General, Shortcuts, Tips

<Doug Klippert@ 3:11 AM

Comments: Post a Comment

Thursday, March 03, 2011 – Permalink –

Use a Table Alias

to change names in a query

When you need to change the table name referenced in an existing Access query, it can be a pain. This is especially true if the query contains a large number of fields.

You typically might use an alias when you need to relate a table to itself or tables have long or unwieldy names.

If you make a practice of always using aliases in your queries, you can easily change which table is used by changing the one occurrence of the original table name in the query's FROM clause.

To set a table alias in the query's Design view,

Right-click on the table field list and choose Properties.

Then, enter the alias name you want to use in the Alias text box.

See all Topics access
Labels: Customize, General, Properties, Relationships, Tables, Tips

<Doug Klippert@ 3:51 AM

Comments: Post a Comment