FreeAccess Access Add-Ins/Wizards

Ezy Filter 2.0 Now includes reports!
Easily filter any form or report on the fly.

Table Warehouse 1.0
The ultimate source for pre-designed Access tables.
Subscriber Tip: Add your own tables to Table Warehouse. Export tables from your databases to tblwh97.mda or tblwh2k.mda in the normal way. When you run the add-in it will display all tables in the .mda in the table import list.

Super Switchboard 1.0
Super Switchboard is an explorer-like popup switchboard that automatically replaces the standard Access Switchboard.

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

Access97 Knowledge Base
A full compendium of Access97 Knowledge Base Articles compiled into a Help file
The extraction password for the zip file was included in the subscriber mailing of 5 November 2001.

Subscriber Tip: Access97 owners checkout the solutions.mdb in the \samples subfolder of the Access folder.

Try Mr. Access for some useful files.

Calculate Time Totals

'---------------------------------------------------
' This function accepts a time interval and returns
' a value, such as "55:23" for 55 hours and 23 minutes.
'---------------------------------------------------

Function HoursMinutes(Hour As Variant) As Variant
Dim Hrs As Long, Mins As Integer

If IsNull(Hour) Then
______HoursMinutes = Null
Else
______Hrs = Int(Hour * 24)
______Mins = CInt((Hour * 24 - Hrs) * 60)
______If Mins = 60 Then
____________Mins = 0
____________Hrs = Hrs + 1
______End If
______HoursMinutes = Hrs & ":" & Format(Mins, "00")
End If

End Function


Store the function in a module, which you can use, for example, to calculate the total of a worker's daily hours as set in this query:

Access Tutorials

Access® Software
ABus -Access Page

Ezy Exporter Access Add-In
Provides equivalent functionality as the Access import wizard

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

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

New versions of:
SmartForm Wizard
Vizual Einstein
Web Tarantula 

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

 

No 1 September 2001
No 2 October 2001

Extraction passwords for Phantom Micosoft Files for these issues were included in the subscriber mailing of 5 November 2001.

 

Top

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:

Unsubscribe

Have questions or comments?
Send them to us.

Access is a trademark of Microsoft Corporation.

©2001 Anthony D'Ambra.
All rights reserved.

Top