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!

Wednesday, April 12, 2017 – Permalink –

Progress bar on Forms

Show movement

You can display computer time by using the Microsoft Progress Bar Control. In earlier versions of Access, it can be found by using the "More Controls icon in the Toolbox. In Access 2007 it's under "Insert Active X Control".

Here are the instructions from FunctionX.com:
Progress Clock

See all Topics access
Labels: Customize, Forms, General, Graphics, Reference, Tips, Tutorials

<Doug Klippert@ 3:07 AM

Comments: Post a Comment

Sunday, January 08, 2017 – Permalink –

Change Splash

Make it your own
A splash screen appears when you start Access. Here is how to customize what is displayed.

Adding Splash

See all Topics access
Labels: Customize, General, Graphics, Reference, Tips, Tutorials

<Doug Klippert@ 3:05 AM

Comments: Post a Comment

Saturday, November 26, 2016 – Permalink –

Picture Controls

How to
Pictures can add interest and understanding to Forms and Reports.
This article covers the pertinent details you'll need to know.

Use images in your Access forms, reports, and controls

See all Topics access
Labels: Customize, Graphics, Reference, Tips, Tutorials

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Wednesday, November 11, 2015 – Permalink –

Graphics from the '50s

Remember it the way you want to

Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.

"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com

See all Topics access
Labels: Graphics

<Doug Klippert@ 3:25 AM

Comments: Post a Comment

Saturday, October 24, 2015 – Permalink –

Clip Art Gallery

Sprinkle carefully

Judicious use of Clip art can spice up a document. Here's an article about how to customize existing pictures including:

Display clip-related toolbars

Customizing your clip art

Cropping

Sizing

Adding text wrapping

Blurring

Rotating and flipping

Adding a drop shadow

Edit clip art in Word

Halloween clips

See all Topics access
Labels: Graphics, Reference, Tips, Tutorials

<Doug Klippert@ 3:03 AM

Comments: Post a Comment

Thursday, June 18, 2015 – Permalink –

Pictures in Forms

It can still be done

Photo Editor was an Office component prior to Office 2003.
In Access/Office 2003/2007 MS Photo Editor was replaced, and Office no longer includes an OLE server for images.

To work around this issue, reinstall Photo Editor.
To do this, follow these steps:

Insert the Microsoft Office XP CD-ROM into your computer's CD-ROM or DVD-ROM drive.

If the Office XP Setup program does not start automatically, follow these steps:

Click Start, and then click Run.

In the Open box, type drive:\Setup.exe, where drive is the letter of your CD-ROM or DVD-ROM drive.

Start to step through the Setup process, and then select Customize for the type of Setup to perform.

When you reach the Selecting Features step, set each node of the Setup tree to Not Available.

Under Features to install, expand Office Tools.

Click Microsoft Photo Editor, and then click Run from My Computer.

Click Install Now.

Click OK when Office XP Setup has completed successfully.

Microsoft Support Article: 817095

Also: Ammara.com:
Pictures in Access Forms & Reports
OLE Object Photo & Image Problems & Solutions

Access MVPS.org: Handle/Display images in forms/database

"While it's possible to actually store the images within the database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information about the object (such as its parent application) that Access needs to store in order to render the object properly."
Displaying photos in a form

See all Topics access
Labels: Forms, Graphics, Reference, Tips, Tutorials

<Doug Klippert@ 3:19 AM

Comments: Post a Comment