Access 97

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 (Access 97)

Info about the above Downloads

Items 1 to 9 are Access 97 databases in *.mdb format

Download Item #1

Validate UK Postcode
This example is a bit well rough to say the least! Will tidy it up some day… You can go into scoot, select records, save as text, then import into Access. Then use the queries to correctly format the data...

You must select Add ID column when importing, and if the import only has the fields: ID,Field1,Field2,Field3,Field4:
you need to add a field Field5

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

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

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 (8KB).
Last updated: February 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 (Access 97)

File Formats

Back to Top