Category Archives: Forms

The OldValue Property

If someone changes a value in a field and that change has repercussions for other fields on the form, you may wish to use the OldValue property. Here is a sample and just to explain, CreditRequired is a Yes/No combo … Continue reading

Posted in Forms | Leave a comment

Subforms

Angela solves a few day-to-day form and report problems, including how to stop dangerous right-clickers and how to dynamically add line numbers. In Access 95 and 97, I’ve noticed that when I have a form with multiple subforms, I sometimes … Continue reading

Posted in Forms | Leave a comment

Smart Search without the Hassles

No database application is complete without a comprehensive search facility. There are many methods of incorporating search routines in a form or a query. In this article, Nirmala Sekhar demonstrates a simple method of searching your data based on a … Continue reading

Posted in Forms | Leave a comment

Positioning a Record on a Form

In this month’s issue,  Peter tackles handling of quotes,  using the RecordsetClone on a form, violating Windows user interface standards, data entry forms, and how to find the First Monday and Last Friday of a month. Here’s my problem: The … Continue reading

Posted in Forms | Leave a comment

Microsoft Access Forms Are All Class

Take Advantage Of The Class Module Features Of Your Forms When Access 97 came out, one of its hidden features is that Form objects now were actually Class modules.   Whoopee do you might say.   Quite a few years on and … Continue reading

Posted in Forms | 1 Comment