Snipplr

(Visual Basic) Close Without Record Save - heislekw

Sun, 01 May 2011 02:47:46 UTC

Performing a Close action on a form can cause you to lose edits without warning. The problem occurs if there is any reason why the record cannot be saved. e.g.: * a required field was left blank; * the record would create a duplicate in a unique index; * the form's Before Update event was canceled; * a Validation Rule was not met. Access simply discards your edits and closes the form without warning that the record was not saved. Develop the habit of explicitly saving whenever you do anything that requires the record to be saved, e.g. applying or removing a Filter or OrderBy property, changing a RecordSource, or moving to another record. You must explicitly save the record before executing a Close action. For example:

(Visual Basic) Printing without saving current edits - heislekw

Sun, 01 May 2011 02:46:23 UTC

Changes to the current record are not saved just because you click a button to perform some other action. Novice Access users often forget to force a record save before executing an action such as OpenReport [or Close, etc.]

(Visual Basic) Subform records with no main form record - heislekw

Sun, 01 May 2011 02:43:47 UTC

You have a table with a primary key, and related table with a foreign key. You have created a relationship between these two tables, with referential integrity. Now you create a main form with a subform for these two tables. Some of the records you enter in the subform seem to disappear never to be seen again. Where have they gone? Referential integrity does not block Nulls in the foreign key. Normally Access fills in the foreign key in a subform to match the primary key in the main form. But if the main form is at a new record, Access merrily accepts the entry in the subform with a Null foreign key. These records never show up again in the subform, since they do not relate to any record in the main form. You must take specific action if you want to prevent this occurring. Solutions: Do either (or both) of the following: * Set the Required property of the Foreign key to True in Table Design. * Use the subform's BeforeInsert event procedure to cancel (or question) the insertion:

(Visual Basic) Detect if form is being edited - Option 1 - heislekw

Tue, 08 Mar 2011 09:42:00 UTC

(Visual Basic) Use PageBreaks instead of tabs - heislekw

Tue, 08 Mar 2011 09:34:47 UTC

On form, insert a Page Break after the first group of fields. This creates two "pages" in the form, which can be toggled using a command button on each.

(Visual Basic) Detect if form is being edited - Option 2 (timer) - heislekw

Tue, 08 Mar 2011 09:30:55 UTC

Set TimerInterval to 1000 Add a command button called cmdUndo, which will be enabled the moment the form is edited.

(Visual Basic) Make popup form close when user clicks outside of it - heislekw

Fri, 11 Feb 2011 09:43:22 UTC

(Visual Basic) Check for duplicate record from many to many table - numeric - heislekw

Tue, 18 Jan 2011 16:03:31 UTC

(Visual Basic) Move cursor to start of date field - heislekw

Tue, 18 Jan 2011 15:50:53 UTC

(Visual Basic) Use arrow key to move through records in a continuous form - heislekw

Fri, 31 Dec 2010 03:54:48 UTC

KeyPreview property must be set to Yes

(Visual Basic) Save changes code, prevent you can't save record error - heislekw

Sat, 24 Jul 2010 02:02:59 UTC

(Visual Basic) Validation for a check box with a corresponding text field - heislekw

Sun, 19 Apr 2009 12:09:38 UTC

(Visual Basic) Validation for a combo box with a corresponding text field - heislekw

Sun, 19 Apr 2009 11:57:50 UTC

(Visual Basic) Use tag property to handle multiple controls - heislekw

Fri, 17 Apr 2009 12:06:08 UTC

(Visual Basic) Change mouse cursor to hand - heislekw

Sun, 23 Nov 2008 12:48:29 UTC

(Visual Basic) Change control's source based on value of other control(s) - heislekw

Sun, 23 Nov 2008 10:49:23 UTC

(Visual Basic) Enable/Disable control based on value - heislekw

Sun, 23 Nov 2008 10:46:01 UTC

Concise version

(Visual Basic) Override Date Confirmation - heislekw

Sun, 23 Nov 2008 10:44:21 UTC

Used with calendar button

(Visual Basic) Check for duplicate value (numeric) - heislekw

Mon, 17 Nov 2008 16:02:49 UTC

(Visual Basic) Check for duplicate value (text) - heislekw

Mon, 17 Nov 2008 16:00:06 UTC

(Visual Basic) Delete confirmation - heislekw

Wed, 22 Oct 2008 16:45:03 UTC

(Visual Basic) Set all controls on a form to null - heislekw

Tue, 21 Oct 2008 12:53:01 UTC