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!

Monday, March 30, 2009 – Permalink –

Linked Table Problems

Lost functionality

Have you found that you cannot update linked Excel tables in Access 2003?

If you have installed Microsoft Office 2003 Service Pack 2 (SP2):

MORE INFORMATION
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.

Support.Microsft.com:
You cannot change data in linked tables that are to an Excel workbook

You might try reinstalling and then only installing SP1.

Also:

VB123.com:
Guacamole dipped - Access to Excel linked table gotcha

PCWorld.com:
Patent ruling costs Microsoft $8.9 million

"A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages.

See all Topics

access
Labels: Tables, Tips

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Wednesday, March 25, 2009 – Permalink –

Toggle Object Views

Use the keyboard

When you are putting a database together you often want to switch between views of Access objects to see the changes.

For instance, you'll switch the view to examine a Table in Design view and then back to data view. It is can be faster to switch between views using keyboard shortcuts, rather than the View menu.

You can cycle through the views of an open object using the

Ctrl + .

or

Ctrl + ,

shortcut keys.
These shortcuts can be used with tables, queries, forms, reports, and data access pages.

See all Topics

access
Labels: General, Tips

<Doug Klippert@ 3:31 AM

Comments: Post a Comment

Monday, March 16, 2009 – Permalink –

New Default Access Form Template

Set new standards

You can change Access's default form.

To set up a custom template,

Create your template form by specifying all the properties you want to maintain from form to form.

Then, save the form using any name.

Next, select Tools>Options from the menu bar and select the Forms/Reports tab.

Enter your template's name in the Form Template box to replace the Access default (Normal) and click OK.

The next time you create a form, Access will base it on your form template rather than the typical Normal template.

In Access 2007, click the Office button in the upper left corner and the click Access Options.
The design options are located under Object Designers: Forms/Reports.
The same thing can be done with Reports.

(The settings are saved in the Access workgroup information file, not in a particular data base)

Also: MeadinKent.co.uk: Making a report template

Here's a calendar from MeadinKent: Calendar page

See all Topics

access
Labels: Customize, Forms, Reports, Tips

<Doug Klippert@ 3:13 AM

Comments: Post a Comment

Monday, March 09, 2009 – Permalink –

Change Properties in Form View

Alterations on the run

As you work with a form, you will, sometimes, find controls would benefit from minor tweaking. You may want to change the color of a text box, change the font that's used, or remove scroll bars.

You may have been told switch to Design view to make changes. However, you can display the property sheets for a control while you're in Form view.

To do so, click the Properties on the View menu, Right-click, or press [Alt][Enter].
As in Design view, the displayed properties relate to the control that is selected on the form. The property changes you make are reflected on the fly.
You will be prompted to resave your form when you close it.

See all Topics

access
Labels: Forms, Properties

<Doug Klippert@ 3:49 AM

Comments: Post a Comment