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, November 19, 2009 – 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: Forms, Properties, Tips

<Doug Klippert@ 3:31 AM

Comments: Post a Comment

Sunday, November 15, 2009 – Permalink –

Color News

A multidiscipline subject

Here is a study about how color effects a reader's choice of concentration.

It was intended for newspaper publishers, but the same knowledge can be used in Web design, PowerPoint, or any other reporting application. Word and Excel will also benefit.

Color, Contrast, and Dimension in News Design

ColorProject

The Poynter Institute is a school for journalists, future journalists, and teachers of journalists.
Poynter.org

See all Topics

access
Labels: Tips

<Doug Klippert@ 3:06 AM

Comments: Post a Comment

Friday, November 13, 2009 – Permalink –

Link to Office Documents from Access

Click to Word, PowerPoint, Excel

You can create hyperlinks in Access that jump to other Office documents. The process of specifying the document and the bookmark you want to jump to can be cumbersome.

There's an easy way to specify where in a Word, Excel or PowerPoint document that a hyperlink should jump to, without even having to open the Insert Hyperlink dialog box.

Open the target document and the Access table that contains a hyperlink field.

Select some of the text at the beginning where you want the hyperlink to jump.

Hold down the Ctrl key, drag the selection to the Access hyperlink field you want to set up.

When you release the mouse button, the previously selected text is used as the hyperlink text and the link becomes active.

See all Topics

access
Labels: Shortcuts, Tables, Tips

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Thursday, November 05, 2009 – Permalink –

Change Code to Comments

Fast solution

When you're testing procedures, you can temporarily convert a block of VBA code to comments that will be ignored during a trial run.

Doing so manually by inserting an apostrophe before each line of code can be a real chore.

To simplify this task,

Open any module in the Visual Basic Editor (VBE)

Choose View >Toolbars>Edit from the menu bar to display the Edit toolbar.

Select the lines of code that you want to turn into comments.

Click the Comment Block button on the Edit toolbar (it's the sixth button in from the right end of the toolbar).

Each line of the selected code is now preceded with an apostrophe. To convert the comments back to executable code, select the appropriate lines and click the Uncomment Block button, which is immediately to the right of the Comment Block button.

See all Topics

access
Labels: VBA

<Doug Klippert@ 3:42 AM

Comments: Post a Comment