MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Folder functions

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

Add a Size Grip to a form	Add a Size Grip to a form, and have it work just like a standard windows form, without subclassing.
Close a specific form instance	How to close a specific instance of a form, without using DoCmd.Close.
EnableDisableControls	Enable or disable all form controls, or a ParamArray of controlnames
Detect column click	Detect the number of the column clicked in a datasheet form.
Detect Activate & Deactivate events	How to detect a popup form's Activate & Deactivate events.
Fade Access	How to fade the Access application window.
Fade forms	How to fade an Access form.
Form position	How to find the position of a form.
IsFormInstantiatedAsObject	How to determine if a form has been instantiated as an object.
IsLoaded	How to determine if a form is loaded.
Centre form on form/control	Centre an Access form over another form, or over a control.
Animate form	Animate an Access form
Flash the TitleBar	Flash a form's TitleBar.
Add custom icons to forms	How to add a custom icons to different forms, replacing the standard icon.
Form position?	How to determine the position of an Access form.
Form position!	How to open an Access form at a specific position.
Resize datasheet columns	How to resize datasheet columns to fit the available space.
Save and delete bound records	How to save & delete records in a bound form.
Wrap subforms in transactions	How to wrap a bound subform in a transaction.