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
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
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
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
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
