Thought I would start by adding some sample Db's I have (May not be very good). Maybe they can be tranfered to a separate forum when the site is re-done.

Dave

First - a request from a PM, updating a remote back end.

Tree view control as a menu...

How to auto fill a form using a query, simple once you know how, but seems a nightmare for beginners.

Cmdbutton faces (what I have, anyway) NOT MY WORK, credit to the creator

Access as windows explorer

Neat little calendar from Allen Browne.
(I use this all the time)

Images in Access

Custom Search form

Common Dialog Box examples.... was very popular

Returning database objects

And Rich's favorite.

How many sleeps till Santa Cums

Pat Hartmans Useful Date Functions

Animate the way a form opens

G’day all.

Please find attached an A97 demo for the global handling of the on not in list event for combo boxes.

It should suffice for all system event arguments but of course not all events have been tested.

The basic idea is to funnel events through a combo box class module while preserving, by reference, the necessary system arguments. These arguments are passed down and back up the chain by reference but admittedly it is not clear.

The A97 demo should push forward to later versions OK, no references.
(A2K3 users could get a Macro warning but just let it pass.)

Have fun testing and regards,
Chris.

G’day all.

This small project was first written by someone unknown to me, so if you see your baby here just say so (via PM) and we will give all due credit.

It was written in Access version 2 (16-bit) and I was asked to convert it to A97 (32-bit) version. A few things have been added to the original, such as the sequential compact/backups as well as a small amount of online help.

It is important to note that, if you have multiple versions of Access on your machine, this A97 version should be converted to the highest version you have. It should readily convert to any 32-bit version of Access.

It is best viewed at 1024 x 768 screen resolution.

EDIT:
New attachment fixes bug with international decimal separator.

Kind regards to all,
Chris.

G’day all.

A file search facility that you may find useful.

The basic algorithm is to search on selected drive(s) for file extensions like *.* with wild cards.

There is also a facility to scan the selected drive(s) for file extensions, though it does take a little time.
If scan for file extensions is done then simply select an extension and hit the Go button.
The Stop button should terminate any search be it search for files or extensions.
After completion or termination the results are available in the appropriate table.
At that time the tblFilesFound table may be used as you see fit.

Please note:
No DAO or ADO references are required and should be good to go A97->A2K3 MDB or MDE.
This is a read only facility that does not and will never copy/move files, it’s simply too dangerous.
Both File Name and File Path columns WILL, on double click, attempt to activate the file if there is an application associated with that extension.

(WARNING: That means BAT and EXE files along with any other executable file extension that is associated with that file extension.)

As always if you find a bug, within the confines of purpose, please contact me.

Have fun and hope you find it useful.

Regards,
Chris.

G’day all.

This demo creates a Form, in an MDB file, with 676 rectangles in a square configuration of 26 * 26.
You can reduce the number (26) but please do not exceed it.
The size of the rectangles can also be changed.

It really has no purpose apart from the coding exercise of manipulating strings.

It should readily convert to all 32-bit versions of Access but A2K3 users might get a warning because of the AutoExec Macro.

Have fun and regards,
Chris.

Pat Hartmans Useful Date Functions

Was going to post this when spotted this post , can I add this extra note with thanks to the author of the original?

Hope this helps !!:D

First - a request from a PM, updating a remote back end.

After reading all your posts all I can think of is a manual front end!..Please forgive..hehe

I'll check to see what I can submit to this thread, sounds useful since many learn from example, I'm sure.

G’day all.

Well, that’s what it’s about.
(Not much in the way of ‘green gravy’ with this one.)

The last one in the list begs much more math, which I would not understand.
Ultimately it would require the passing of torsibillity and torque to the report.
(OK, there may be only two ‘i’’s but I like three. :) )

Anyway, here it is…warts and all.

Regards,
Chris.

I have tryd "AutoCompact.mdb", thanks for that.
I found it very useful, but I had to change two lines in
"GetProgramVerison" function.

Dim strVersionNumber As String I changed ...As Integer

strVersionNumber = CStr(Nz(DMax("VersionNumber","tblVersions"),0))
I changed
strVersionNumber = Nz(DMax("VersionNumber","tblVersions"),0)

Because, when the forms ("frmSplash" and "frmFileList") where opend,
there was an error number 3075
Syntax error (comma) in query expression 'VersionNumber = 7,1'

MStef alias Štef

Thank you Stef for the feedback.

I can reproduce the bug if I switch regional settings to German, it’s the Decimal symbol in the Numbers section of Regional Options in Control Panel.

I don’t want to change the variable type to Integer because I would like to maintain a floating-point number and also learn how to handle different regional settings.

Can you please confirm your regional settings if not German?

Thank you for your feedback because this is exactly the way to make the product better. :)

Kindest of regards,
Chris.

My regional settings is CROATIAN.

G’day Stef.

Croatian does not seem to be in the list of regional settings in Win2000 but I think I’ve fixed it anyway.

Post # 15 in this thread has the new attachment.

Thanks again for the feedback and regards,
Chris. :)

I just realized I have a handful of sample databases saved. This first one has some examples of button customization.

This is an example of a switchboard front-end to a database.

This database shows examples of working with subreports.

These samples interact with Word. The first has a dialogue box for selecting and opening a Word document to work with, the second performs a Word template merge.

This nifty one shows how to use a calendar to select and pass a date into a field.

This has a form that uses cascading combo boxes.