Learn Access -6- Create a Continuous Form in Microsoft Access
Learn how to design forms in Access efficiently. Create a continuous form using Microsoft Access to add and edit data stored in tables.
Create a Multiple Items form, also called a Continuous form, to display many records at a time. Modify, add, name, select, align, resize, and best-fit controls. Switch between Form View and Design View. Use the Property Sheet and set properties. Learn how to change a textbox to a combo box, hide the first column, show the second column, and set the RowSource using the query designer. See how field descriptions from the table design are used for Status Bar Text. Use Shift-F2 to pop up the Zoom box to see more data. Share custom Quick Access Toolbars. Write VBA to update the dtmEdit tracking field with the date and time a record was edited. Learn Access effectively.
(00:26) The form we create today will be designed to use as a subform.
(02:11) This screenshot shows a mainform with subforms for Addresses, Phones, Email addresses, and Websites.
(03:00) Forms should be patterned after data structure - separate form for each main table
(04:03) To create a form for the Phone table, select it in the Navigation Pane, and choose the Create ribbon.
(04:10) In the Forms group, drop the choices for More Forms and choose Multiple Items. The wizard makes a form that we can now modify.
(04:27) The form header section is displayed once at the top of the form.
(04:32) The controls in the detail section are repeated for each record.
(04:38) The form footer section is displayed once at the bottom of the form.
(05:07) To quickly select them all, I click in the ruler to the left of the labels.
(05:29) Using the Property Sheet, set the Top property to 0 (zero) and the labels move up to the top.
(05:57) click (+) to select the grouped controls
(06:15) dtmAdd and dtmEdit tracking fields
(07:12) Shift-click toggles the selection status of a control.
(07:23) space that the deleted controls were taking in the layout closes up
(07:31) make detail section taller
(07:43) make detail section shorter
(07:53) best-fit controls
(08:42) change control type to combo box
(08:53) build RowSource for combo box
(10:25) use Notepad to type ColumnWidths while looking at datasheet view
(11:22) what is before colon(:) is the column name
(12:09) set Column Count, Column Widths, Column Heads, List Width
(13:10) Now I close the extra space at the bottom of the detail section by dragging its bottom border up.
(13:17) drag the right border to the left to close the extra space on the side
(13:25) Save and name the form
(13:36) I will start the form name will a little f_
(14:38) how to make forms look nice
(17:36) StatusBarText shows Field Description from Table design
(18:36) use the alignment icons on the Quick Access Toolbar
(22:24) use form Before Update event to set the date/time a record was edited
(22:36) [Event Procedure]
(23:23) write VBA code
(24:09) Intellisense
(24:56) Now() is the function for the current system date/time
(26:06) Relationships window
(27:54) Shift-F2 to pop up the Zoom box
** Original Music **
April Kelly - singer/songwriter, Houston, Texas
http://www.AprilKellyMusic.com
Blow Me Away single: http://itunes.apple.com/us/album/blow...
http://www.BandOfGoldMusic.com
** Links **
download - free Contact Template for Access
http://msaccessgurus.com/Contacts.htm
video - Access QAT (Quick Access Toolbar): Alignment Icons (cc)
• Access QAT (Quick Access Toolbar): Al...
video - Add Save As Icon to QAT (cc) - Français, Dutch, Deutsch, English
• Tip: Add Save As Icon to QAT, Quick A...
download - Crystal's QAT customization file for Access
2007, 2010: http://www.msaccessgurus.com/Download...
2013+:
http://www.msaccessgurus.com/Download...
Learn Access Playlist on YouTube
http://www.youtube.com/view_play_list...
Access Basics book
http://www.accessmvp.com/strive4peace
let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!
visit MsAccessGurus and contact me today!
http://msaccessgurus.com
I look forward to hearing from you ~
warm regards,
crystal
Remote Programming & Training -- connect to me, let's built it together
~ have an awesome day ~