freeaccess.cjb.net 
 

FreeAccess Newsletter No 8 - May 2002

  Free Access Tools and Databases AAD CONSULTING Sydney Australia_ | _Advanced Access Development
     
What's New at FreeAccess?

SmartToolbar New!
Smarter than Smart Form! Automatically adds full record navigation and autofiltering to any Access data form.

Table Warehouse New v1.1
Choose from 120 tables. Now users can add their own tables to the Warehouse.

Super Button Builder 2000 Update
For Access 2000/2002. Updated 1 May 2002.

Access KB Browser
Articles archive was updated on 22 April 2002.
Download the Latest Article Table

Document Tracker Database New Version 2.3
Now with an optional automated Word front-end.
Document management system. Automatic document referencing and creation.

 Tips

Use the GetRows method of the Recordset object to quickly dimension and fill an array of records.

 Phantom Microsoft Files - for subscribers only

Hard to find files that are no longer on the Microsoft web site - new files in each newsletter

Access97 Balloon Builder Wizard

Download

The extraction password for the zip file was included in the subscriber mailing of 14 May 2002.

 Downloads

Access Freeware Downloads from http://www.peterssoftware.com

 Code samples

Use DoCmd.Echo as a quick way to tell users of what is happening during long-running processes. The syntax is DoCmd.Echo(EchoOn,[StatusBarText]). For example:

Sub BatchUpdate()
On Error GoTo BatchUpdate_Error

'Turn on hourglass, turn off screen redraw and set status bar text
____DoCmd.Hourglass True
____DoCmd.Echo False, "Batch update in progress. This may take a few minutes."
________...[code]
____DoCmd.Echo True
____DoCmd.Hourglass False

Exit_BatchUpdate:
Exit Sub

BatchUpdate_Error:

____'IMPORTANT - Reset user environment if an error occurs
____DoCmd.Hourglass False
____DoCmd.Echo True

____MsgBox Err.Description

____Resume Exit_BatchUpdate

End Sub

 Useful links
Access Utilities

NJH's Accessory - Developing Tools and Libraries

Access VBA Central

 Coming soon...

Developers Toolbar
Access AddIn for developers

A new version of the Document Tracker database
Incorporating new MS Word front-end

A new Access HRIS database application
A comprehensive leave and training tracker

A new version of the Project Management database
Incorporating daily time management

Also on the drawingboard:
Instant Invoicer Wizard
Consolidation Query Wizard
Call Logging Database
Currency Exposure Manager Database

_Back Issues

 

No 1 September 2001
No 2
October 2001
No 3
November 2001
No 4
Dec/Jan2002
No 5
Feb2002
No 6
March2002
No 7
April2002

Extraction passwords for Phantom Microsoft Files for these issues were included in the subscriber mailing of 14 May 2002.

 

Top

Top

 
CONTENTS:
What's New
Tips
Phantom Microsoft files
Downloads
Code samples
Useful links
Coming soon...
Back Issues

Subscription to this newsletter is free.

This newsletter may contain links to sites on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of any such third-party site.

Any files are provided "as is", without warranty of any kind. AAD CONSULTING does not assume any liability for use or the consequences of use.

To unsubscribe from this mailing list, enter your email address:

Have questions or comments?
Send them to us.

Access is a trademark of Microsoft Corporation.

©2001-2002
Anthony D'Ambra.
All rights reserved.

Top