|
Microsoft Access FormsThis page on Microsoft Access Forms, consists of lots of tips, questions/answers about Forms and the use of them in Microsoft Access.If you wish to know the basics on how to create a form, then I suggest you download my free tutorial. This does not only include how to create a form in Microsoft Access, but will step you through the entire process of building your first database in MS Access. To learn the basics of Microsoft Access then:
Click Here
Combo Boxes filteringUsing a Combo Box to filter another Combo Box (Method 1) This tip explains how to use a combo box to filter a another combo box. It uses criteria in a query and the requery function.Vertical Alignment of textVertical Alignment of text in a text boxUse this tip to help position your text in a text box. Can also be used for labels Active X calendar ControlActiveX Calendar ControlClick on the link above to learn how to add an ActiveX Calendar Control to your form. Digital ClockAdding A Clock To a FormThis tip explains how to add a digital clock to a Microsoft Access Form. Message box if no recordsDisplay a Message Box if there is no records in a formUse this tip if you are looking for some code, to cancel the opening of a form and displaying a message box if there are no records in the form you are opening Vertical TextThis tip will show you how to change a property so that your text will display vertically rather than horizontally. New LineThis tip will show you how to set up a memo or text field so as the user goes to a new line when the 'Enter' key is pressed. Form EventsThis tip will give you an overview of all the form events that are available to you when you open a form. An event is where you add code or a Macro to 'do something' with your database. Advanced Conditional FormattingAdvanced Conditional Formatting This tip will give you an overview of how to add some VBA code to enhance your Conditional Formatting to achieve more advanced conditional formatting options. Adding Time fieldsThis tip will explain how to add to separate time fields in a query, form and report. Specifically if the result is going to be greater than 24 hours. It also explains how to sum a time field in a continuous form or in a report. Finished with Microsoft Access Forms - then return to the Simply Access Home Page |
Search Simply Access
Want to learn more for free.
Sign up for Simply Access 'Microsoft Access Tips'. Free useable tips to your in-box each month.
If you wish to learn VBA to expand the possibilities of Microsoft Access then
Click Here Just $7.95 for 56 lessons.