Sample Db thread (1 Viewer)

[Oldsoftboss]

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.

 

[Oldsoftboss]

Tree view control as a menu...

 

[Oldsoftboss]

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

 

[Oldsoftboss]

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

 

[Oldsoftboss]

Access as windows explorer

 

[Oldsoftboss]

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

 

[Oldsoftboss]

Images in Access

 

[Oldsoftboss]

Custom Search form

 

[Oldsoftboss]

Common Dialog Box examples.... was very popular

 

[Oldsoftboss]

Returning database objects

 

[Oldsoftboss]

And Rich's favorite.

How many sleeps till Santa Cums

 

[Oldsoftboss]

Pat Hartmans Useful Date Functions

 

[Oldsoftboss]

Animate the way a form opens

 

[ChrisO]

Pass and return system event arguments to/from public procedures.

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.

 

[ChrisO]

Auto compact and backup.

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.

 

[ChrisO]

A File Search Utility.

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.

 

[ChrisO]

Create a Form on the fly with Form source code.

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.

 

[Brianwarnock]

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?

 

[GaryPanic]

YT20zip (Your Tree)

Hope this helps !!

 

[drobinson]

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.