Downloads

This page contains links to files I am making available for download. Click on the appropriate link to begin downloading. Most are in *.zip format. To extract the files you will need WinZip which is available from the following link:- Download WinZip Here

A definition of the file formats is available at the bottom of this page. All file sizes are approximate.

Access Databases *.mdb format (Need minimum of Access 2000)

Info about the above Downloads

Download Item #1

Validate UK Postcode
This example is a bit well rough to say the least! Will tidy it up some day…

Format: zip (65 kb).
Last updated: September 2003.

Download Item #2

Time Control A form that pops up to allow entering the time in to a field

Not my work I'm afraid, I just modified it a bit.....

Contact access@gr-fx.com http://www.gr-fx.com/

Format: zip (159 kb)
Last updated: September 2003 .

Download Item #3

Time Management Matrix

In this example I'm trying to load "Instances” of a form as a sub-form , but I can’t get it to work. However I made this Time Management Matrix in the attempt. I have a thread running at “Access World Forums” http://www.access-programmers.co.uk/forums/

The actual thread about the problem is at: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54476

Any help or comment should be directed to this thread. And any help will be greatly appreciated…

Download Item #4

Word Count Function

This is a function you can use to count how many words are in a string. I have seen another function for this somewhere.

Format: zip (32 kb)
Last updated: December 2003

Download Item #5

Space before Capital Letter

This is a function you can use to add a space before a Capital Letter

Why would you want to put a space before a Capital? I wrote this piece of code in answer to a question on a forum. The person asking the question had a situation where they had a list of reports with names in the normally excepted format of : rptMyExampleReportName

As you can see each word starts with a capital, so the question was “how do I take away the prefix and then add a space before each word so that in my combo box where the user selects the report name they see a nice list of normally looking named reports”. The benefit for the programmer was that you didn’t have to worry about naming the reports, or even worry about what happened if you change to a report name, Your code still worked.

Format: zip (15 kb)
Last updated: March 2004

Download Item #6

Multiple Combo Boxes to Select Records

This is an example of one way to use multiple combo boxes to select a set of records in a query. The example uses a simple function, a union query in each combo box and a query.

The union query in the combo boxes is similar to this:-

SELECT DISTINCTROW tlkpCustMup.CustMupID, tlkpCustMup.CustMupLongDesc FROM tlkpCustMup UNION SELECT "*","<ALL>" FROM tlkpCustMup;

This is the function:-

Public Function fCboSearch(vCboSearch As Variant)

If IsNull(vCboSearch) Or vCboSearch = "" Then
fCboSearch = "*"
Else
fCboSearch = vCboSearch
End If
End Function

For and against list
For:
I like this method as its quite straight forward to implement.
No global variables are needed or used.

Against:
Can’t do “OR” only does “AND”

Interesting:
I’m working on an example to do “OR” and “AND”. At first I thought it would be difficult, if not impossible, but now I think I can do it with “OR” and “AND”.

I have combo boxes, cbo1Customer, cbo2Material, cbo3Lorry
and option groups, opt1Customer, opt2Material, opt3Lorry all of which I think I can develop in to a working system given enough time. However it may be too complicated to be useful so we will see….

Format: zip (163Kb)
Last updated: December 2003

Download Item #7

One Form instead of Three
I picked up the following idea from a Smart Access newsletter and have adapted it. Basically if you start creating multiple forms to operate on the same table or query, then you have a nightmare when you want to make a small change. Let’s say you’ve made three forms to perform on a table, one for adding data, one for looking up data and one for editing data. Now you suddenly find that you need to add a couple of fields for some extra data. You have to modify all three forms. So if you can, Use this technique, have one form, and change it’s look and function when you open it.

Format: zip (2660 kb).
Last updated: February 2004.

Download Items 8 and 9

Encryption Using Vigenère
(UPPER CASE)
The original function that I based this function on got its characters from the character set. I wanted to use this routine for producing a password. I found that letting the routine get characters from the character set produced unusual characters not suitable for Passwords so I modified the routine so that it would only return the characters I wanted.
(UPPER & LOWER CASE)
I then decided to modify the routine so that I could encrypt and decrypt my diary entries. My diary is stored in an Access Memo field, and memo fields contain strange characters. This caused unpredictable results when I encrypted and decrypted my entry. So Instead of starting form scratch I just adapted what I had and ended up with this long winded way of doing it. (My life story really!!!!)
This method possibly has some other advantages over accessing the character set directly, over and above the advantage in password processing, but I don't know what they might be.

Format: zip (30KB).
Last updated: February 2004.

Download Item 10

Financial Year selection used in a "Z" Report form

I originally wrote this in a DOS based program called Alpha Four. Then I upgraded it to Microsoft Access.

Many small businesses use a till to record their cash transactions. It is possible and sometimes necessary to group stock into “departments”. At the end of a day you print out a “Z” Report which lists how much is sold by each department. You can take the printed out paper record of the day’s takings and key them into this program from which you can produce a monthly report showing each day’s takings, and a yearly report showing each month takings.

The program can be set up to any financial year you want by selecting the start date and end date of the financial year on a form.

Format: zip (113KB).
Last updated: March 2004.

File Formats

.bas    Visual Basic source file, in text format
.exe    Windows executable program
.ps     PostScript file
.ps.Z   compressed PostScript file, for UNIX
.tar    UNIX archive file
.tar.Z  compressed UNIX archive file
.zip    Windows archive file

Access Databases *.mdb format (Need minimum of Access 2000)

File Formats

Back to Top