freeaccess.cjb.net 
 

FreeAccess Newsletter No 7 - April 2002

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

Ezy Dialog Wizard
New The easy way to create Access dialog forms.

Access KB Browser
New The easy way to search the on-line Microsoft Access Knowledge Base.

Ezy Filter 3.0
New Features Easily filter any form or report on the fly.

A new feature for the Newsletter: Tips

 Tips
  • When writing code for controls in Access Form or Report Design View, save keystrokes by, in the Events tab of the Properties Dialog, typing "[" in the selected event and then clicking the adjacent build button, to bring you straight into the selected event procedure in the VBA editor.
  • In Access Form or Report Design View, to attach a linked control label to an orphan control, copy the linked label from an existing control, then select the orphan control and paste the label, which will attach itself to the orphan control.
  • Try PC-Medik freeware to virtually eliminate Windows crashes and incomplete shutdowns.
  • To easily copy an icon from an Access toolbar button, right-click on the Toolbar, and select Customize..., then right-click on the button and select Copy Button Image, and paste the image as required.
  • In Access97 only, create a nicely formatted Message Box using VBA code like this:

    MsgBox "Heading Text@Body Text@Footer Text"


 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 Function Template Wizard

Download

The extraction password for the zip file was included in the subscriber mailing of 10 April 2002.

 Downloads

Stacks of Access Downloads from http://www.developershandbook.com/

 Code samples

From http://www.programmingmsaccess.com/

Finding and SeekingRecords
Programming Main and SubForm Controls
For Each And With End For Forms

 Useful links
Q307760 ACC97: How to Search for Access 97 Articles in the KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307760

Q304880 ACC2000: How to Search for Access 2000 Articles in the KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q304880

Q307759 ACC2002: How to Search for Access 2002 Articles in the KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307759
 
 Coming soon...

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


Extraction passwords for Phantom Microsoft Files for these issues were included in the subscriber mailing of 10 April 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