Unofficial Access Stuff

Book

Suggestions

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, January 11, 2010 – Permalink –

Merge Access with Word

Database integration

"You can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."

Office.Microsoft.com

See all Topics

access
Labels: Forms, Merge, Reports

<Doug Klippert@ 3:43 AM

Comments: Post a Comment

Thursday, January 07, 2010 – Permalink –

Automate Shutdown

Close everything
It's generally considered good form to close all forms and reports when you're shutting down a database.
Here's a link to some code that takes care of it for you.

TechRepublic.com

See all Topics

access
Labels: Customize, Forms, Reports, VBA

<Doug Klippert@ 3:01 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

Saturday, May 03, 2008 – Permalink –

Sample Queries, Forms, Reports

Examples to part out

This sample queries database contains examples of useful database queries, including the crosstab query, the union query , and the join query

Sample: query topics database

Here are some other sample databases. They are all for Access 2000, but the installed base is predominantly in that format. Access 2000 is also the default format for Access 2002 and 2003.
Sample Access databases that you can download and adapt

Database of Access 2000 sample forms
The sample forms in this database demonstrate a variety of form types and techniques, including how to manipulate data, use controls, and create undo and redo operations.

Some forms include:

Bring a subtotal from a subform to a main form
Create a running sum
Create a stopwatch form
Display line numbers on subform records
Fill current record with data from previous record automatically
Hide the combo box drop-down arrow
Simulate drag-and-drop capabilities

Database of Access 2000 sample reports
The sample reports in this database demonstrate a number of techniques, including how to shade every other row or every nth row in a report, how to create a table of contents or an index for a report, and how to create a top 10 report.

See all Topics

access
Labels: Forms, Queries, Reports

<Doug Klippert@ 6:15 AM

Comments: Post a Comment

Wednesday, February 06, 2008 – Permalink –

Quick Subforms and Subreports

Drag 'em on over

When you need to create a subform or subreport, you probably use the Subform/Subreport tool from the Toolbox to draw where you want to add the control.

You can also create subform and subreports using drag and drop.

Simply open the main form or report in Design view, then drag the appropriate form or report from the Database window to where you want the control created.

Note that you'll still need to set Link Child Fields and Link Master Fields properties on the new control.

See all Topics

access
Labels: Forms, Reports, Shortcuts

<Doug Klippert@ 7:03 AM

Comments: Post a Comment

Saturday, September 01, 2007 – Permalink –

Total Footer

Sum() it up

If you would like to show a total in the footer or each page of a report, you may have a problem. Access does not allow the SUM() function in the footer.

The way around this is to put a SUM() function in an unbound text box in another part of the report.

Choose Properties and set the visible property of the control to No.

In the footer, create another control using the "calculation" text box as the ControlSource.

The Sum() function, as well as the other aggregate (totals) functions can reference only a field and not a control.

From the Microsoft Knowledge base:

How to Sum a Calculation in a Report

How to Display and Total Subtotals from Subreports

How to Print a Group Footer at a Specific Location

See all Topics

access
Labels: Functions, Reports

<Doug Klippert@ 7:50 AM

Comments: Post a Comment

Wednesday, March 07, 2007 – Permalink –

View multiple pages of an Access report

More than one at a time

When you preview an Access report, you may want to see several pages at one time to examine the layout of the report.
You may know that you can do so by choosing View >Pages from the menu bar. However, this technique limits how you view the pages -- you can only view 1, 2, 4, 8, or 12 at a time.

For more control over how the pages are displayed, right-click on the report preview itself, and choose Multiple Pages from the shortcut menu.

The default layout grid is 2 x 3 pages. However, if you click and drag with your mouse, you can select a range of up to 4 x 5 pages.

See all Topics

access
Labels: Reports

<Doug Klippert@ 6:17 AM

Comments: Post a Comment