Unofficial Access Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Thursday, March 27, 2008 – Permalink –
Entry Checker
A second chance

Unlike Word or Excel, Access does not warn you when data is changed.
Unless you make a structural or code change, Access thinks you know what you want to know and allows you to enter or change data and the close the application without a squeak.

There is a way around this:

"In Microsoft Office Access 2007, by default, users are not prompted to confirm changes after modifying and saving records on a form. But often you might want to prompt users to confirm their changes before the record is saved.

You can use a BeforeUpdate event procedure to display a confirmation prompt and handle a user's response to either cancel or continue with the save.

This visual how-to topic illustrates how to display a custom dialog box to prompt users to cancel or continue with saving changes to a record.

User Prompts
(with a video)

See all Topics

access
Labels: Macros, Properties, Tutorials

<Doug Klippert@ 7:33 AM

Comments: Post a Comment

Friday, August 10, 2007 – 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, 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, Properties

<Doug Klippert@ 6:32 AM

Comments: Post a Comment

Tuesday, July 17, 2007 – Permalink –
Flag Access Controls
Tag Property

The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next

See all Topics

access
Labels: Macros, Properties, VBA

<Doug Klippert@ 6:42 AM

Comments: Post a Comment

Monday, April 16, 2007 – Permalink –
Time Interval
Run code at timed intervals

You may occasionally want to run a procedure associated with a form at set intervals. To do so, add the code to the form's Timer event procedure. Then, set the form's TimerInterval property to the number of milliseconds that should elapse between each time the code is run. The maximum you can set is 65,535.
(in Access 2007, the TimerInterval property setting is a Long Integer value between 0 and 2,147,483,647.)

Keep in mind that you shouldn't use a very small TimerInterval, otherwise your application will likely suffer a performance hit. To prevent the Timer event from firing, set the TimerInterval to 0.

Also see:
HOW TO: Create a Stopwatch Form in Access

See all Topics

access
Labels: Macros, Properties

<Doug Klippert@ 6:10 AM

Comments: Post a Comment

Monday, February 19, 2007 – Permalink –
New Line in Memo
Labels and Text boxes

When you're using a form to enter text in a memo field, pressing [Enter] within the text inserts a line break.

However, when you're working with a memo in a table's Datasheet view, pressing [Enter] moves the focus to the next field.

You can force line breaks when you're entering text by pressing [Ctrl][Enter]. This technique also works with text fields and can be applied when you're entering text in labels or text boxes on a form.

To permanently configure a text box so that pressing [Enter] inserts a new line, set its EnterKeyBehavior property equal to New Line In Field.

See all Topics

access
Labels: Entries, Properties

<Doug Klippert@ 6:10 AM

Comments: Post a Comment

Saturday, February 03, 2007 – Permalink –
Properties Report
Record of Records

If you would like a report that includes all of the properties, relationships and permissions of the objects in your database, go to Tools>Analyze and choose Documenter...

Access will create a VERY detailed report.

Ezy Documenter was recommended by Woody Leonard's Access Watch.

See all Topics
Labels: Properties

<Doug Klippert@ 7:14 AM

Comments: Post a Comment