Microsoft Access Office VB VBA Help and Examples
 HOME     MS ACCESS     MS OUTLOOK     MS EXCEL     VB and VBA     FREE PROGRAMS     iPAQ     PERSONAL 
 ACCESS     GENERAL     QUERIES     FORMS     REPORTS     MODULES     RANTS     TUTORIALS 

Query Add-in for Autonumbers and Running Sums

NOW WITH ACCESS XP (2002) VERSION

The link below is an add-in wizard which will help you to build any query that needs an autonumber generated within it, a running sum query, a running average query or a moving average query. This wizard uses sub select SQL rather than Domain functions which can be very slow for large recordsets. Please be aware that even sub select queries are slow with large recordsets, but they are accepted to be the fastest way of achieving these goals. You may also find that looping through the recordset in code to create the desired result will get you there faster.

Download the link below and save it anywhere. Open access and open any existing database you have. From the tools menu choose add-ins add-in manager. Choose add new and browse to the location you saved the downloaded file and double click on it. Close the add-in manager. Open the database you need to create the query in. Go to the queries tab and click new. You will see the new wizard listed in the options as Running Total Query. Click on it and click OK.

Follow the onscreen instructions. Please note the query will not let you continue until you have selected the requested information.

This is version 1.2.0 of this add-in. If you would like to be informed of updates or have a suggestion for the next version contact Email Help

This is a free add-in. If you have found it so useful you feel obliged to send money then use the Donate link. This will help the development of new add-ins.

You are free to use this add-in for your personal use, however commercial use and distribution is strictly prohibited. If you wish to distribute commercially or use this add-in within a commercial environment please use the following form Email Webmaster

PLEASE NOTE I HAVEN'T BEEN ABLE TO GET THIS TO WORK WITH ACCESS 2000.

 

QueryCreator.mda FOR ACCESS 97 (138kb)

QueryCreatorXP.zip FOR ACCESS XP (2002) (23kb)

Versions
1.2.0 Corrected the problem with not being able to handle huge numbers of queries.
1.1.0 Test in house version Not Released
1.0.0 First Release.

 
HOME   SEARCH SITE   PRIVACY POLICY   CONTACT
The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.