This demo-MDB introduces a module that enables you to receive multiple return-values from a form, working as wrapper for all calls to DoCmd.OpenForm().
In addition to the above this sample shows you how to avoid the nasty effects arising from the unpredictable usage of a mouse-wheel - without using any API-calls or additional DLLs.

This is one of the older entries that can also be found on the original Access-site.

Download: Form_RetVals.zip (115.75 kb)

Introduces a way for smaller tables resp. amounts of queried data to be shown all together in a continuous form, i.e., without a vertical scrollbar. The form will adjust its height to show all records while removing the scrollbar - thus avoiding the display-'bug' (or just strange behaviour by design?) in conjunction with continuous forms.

This is one of the older entries that can also be found on the original Access-site.

Download: ContinuousNoScroll.zip (38.73 kb)

This demo shows how to setup a (smooth!) progressbar without any OCX or even API - simply by integrating a prepared subform and a couple of lines of code.
Just insert this sample's subform into your own form and you're ready to go.
This sample A97-mdb includes full source-code and a demo showing the use with two concurrent bars.

This is one of the older entries that can also be found on the original Access-site.

Download: ProgressBar_Demo.zip (63.71 kb)

Shows how to easily setup your own input-form to query a user's input instead of using the built-in inputbox [~shudder~]. All you'll need is one line of code in order to receive input from a user.
This is an A97-MDB but can easily be converted into later versions.

This is one of the older entries that can also be found on the original Access-site.

Download: UserQuery.zip (29.34 kb)

This is a sample-MDB with an easy to use class that'll allow to bring up a form displaying something like "Please hold on a moment..." plus a status-message.

All that's needed is to instantiate the class and call the class' method to send a message - especially useful where a progressbar doesn't make sense or may not be used.

This is one of the older entries that can also be found on the original Access-site.

Download: PleaseHoldOn_A2K.zip (35.10 kb)

This demo shows how to retrieve the current coordinates of the mouse-pointer, relative to the Access-window's position (helpful i.e. for self-defined tooltips).

This is one of the older entries that can also be found on the original Access-site.

Download: MousePos_AccessRelated.zip (40.76 kb)