Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
10 Commandments 

In Memoriam

Terms of Use

VB Petition

Forms: Index Of Articles

Use Variables in SQL behind forms

Proper syntax for concatenating values stored in typed variables into a SQL statement

Find out if a form is open

Use the Syscmd function (or cycle through the Forms collection) to determine whether a form is currently open in design or runtime mode

Cycle through controls with common names

Simulate control arrays in Access

Enumerate all controls on a form

How to generically cycle through all the controls in a form

Have the form move to the record selected in List/Combo box

Use the Bookmark property to move to a record

Return Strings from Option Groups

Use the AfterUpdate event of the option group to map integer values to strings

Use Multi-Select List boxes as query parameters

Use the ItemsSelected collection to construct a dynamic SQL statement

Grab what the user has typed in a control (uncommitted value)

Use the Text property when the Value property of a textbox will refer to old data

Fill Fields automatically on form based on a control's value

Perform automatic lookups

Detect new record in a form

Determine when the user is positioned at the end of a recordset in a bound form

Move cursor to the end of text in a textbox

Prevent automatic selection of text in a textbox

Carry current value of a control to new records

Use the DefaultValue property of a control to carry over the last typed information

Form doesn't open as Modal even though Modal property is set to true

Use the Modal window argument value to suspend code in the calling form

Suspend code until a popup form is closed

Use the Modal window argument value to suspend code in the calling form

Add item to combo box using OnNotinList event

Allow the user to enter new values in a bound combo box

Disable PgUp/PgDown keys in a form

Use the KeyDown event to filter out keystrokes

Determine name of parent form

Use the OpenArgs argument to pass the name of the calling form

Resolve #Name error in a form/report

Avoid circular references in a form or a report

Use ControlTipText to display textbox value

Display the value of a control as the control's ControlTipText

Make a label flash

Use a form's Timer event to simulate flashing of a label

Delete current record

How to delete the current record

#Error when the Subform has no records

Prevent Null values from showing up as #Error in a subform

Cannot ApplyFilter on SubForm

Use code to dynamically generate the SQL to filter a subform

Colors and Continuous forms

Sample of how to perform conditional formatting in subforms

Refer to Controls on a tabbed form

Proper syntax for referring to tabbed controls

Duplicate "Record x of y"

Build your own navigation buttons

Ask before saving record

Simulate a "Save Event" for a form

Limit content of combo/list boxes

Filter combo boxes and list boxes from code

Hide a subform if no records present

How to use the RecordsetClone object to hide a subform

Handle/Display images in forms/database

Information on how to properly display images in an Access database

Refer to Form and Subform properties and controls

Proper syntax for referring to controls (or walking object heirarchies)

Create a clock on a form

How to use a form's Timer event to simulate a clock

Determine selected records in datasheet view

How to use SelTop, SelHeight properties to determine the selected rows

Open a form in an external database

Use automation to open an external form

Set defaults for Find Dialog Box

How to set defaults for the Find Dialog box

Form only allows new records to be entered

Set a form's Data Entry property appropriately

OnMouseOver Effect

How to use OnMouseMove event to highlight a control similar to the web browsers

Control Arrays in Access

How to simulate control arrays in Access

Tooltips don't seem to work

How to bring appropriate controls to the foreground at design time

Close all open forms and "For Each" syntax

How to properly close all the open forms

Make Numeric and Date fields respond to Plus or Minus keys

Simulate Up-Down control functionality in an Access form

Move and Resize form windows from code

Use Windows API to move and position forms from code

Adding 'All' to a listbox or combobox

Add a custom value as one of the options present in a listbox or combobox

Displaying photos in a form

Information on how to properly display images in an Access database

Adding a Search form to a database

A generic search form that allows the user to create/view/export ad hoc SQL queries (uses DAO)

Display a dialog box for a specified duration

How to implement a timeout for a dialog box

Changing the Background Color of the Current Record in a Continuous Form

Another sample of how to perform conditional formatting in subforms

First Control in a Read Only subform retains focus

Simulate a locked subform by moving the focus to a tiny control

Callback function for a Multi Column List box

How to fill a multi-column, multi-row listbox with a callback function specified in the RowSourceType property of the listbox

Mini Calendar

Generic Calendar form that allows the user to select a specific date; uses other samples from this site

Clock From Around The World

Shows you your Local Machine Time, Universal Coordinated Time (UTC) and a time from a Time Zone that you choose from a combo box

Calendar Month View

Draw Calendar MonthView control directly from the APIs

Shaped Forms

Use Win32 API to give your forms irregular shapes

TSI Subforminator!

Workaround for in place editing of subforms in Access 2000

Continuous Forms

Solid Block Font for use on continuous forms in Access 97.

Update All Open Forms

Requery all open forms and return to last record.

Calendar without ActiveX

Date Picker without ActiveX control.

Use the Column Property of a Combo Box

Use the Column Property of a Combo box to fill a text box.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer