Learn how to create continuous forms in Microsoft Access. Otherwise known as List Forms, these allow you to scroll up and down and view all of the products in a table or query. We will create a continuous form to display a list of our products. I'll also show you how to click on one of the products, and then click on a command button to open up the single form for that specific product.
Wyatt from Anchorage, Alaska (a Gold Member) asks: How can I display all of my products in a list so that that I can scroll up and down through them. I'd also like to be able to click on one to open up that product's form. A total count of products and my total inventory value would also be nice to see, too. Thanks!
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to calculate a line total (qty on hand * unit price) in addition to form footer totals for the total value of your inventory and the total number of products on hand.
MEMBERS ONLY VIDEO:
[ Ссылка ]
BECOME A MEMBER:
[ Ссылка ]
LINKS:
Get on my Mailing List: [ Ссылка ]
AutoNumbers: [ Ссылка ]
What is a Form: [ Ссылка ]
Open Form Specific Record: [ Ссылка ]
Open Specific Report: [ Ссылка ]
On Dbl Click Event: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
FREE Blank Customer Template: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
TechHelp: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, continuous forms, form header footer, what is a continuous form, columnar form, how to create continuous form, creating continuous forms, open specific record, find specific data to display
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Ещё видео!