Collections:
Other Resources:
Creating a Standard Tabular Form
Using Columnar as the layout for a form as shown in the previous tutorial is good to enter new records or editing existing records. But the columnar layout only shows one record at a time. It is not convenient for browsing records or comparing records.
So how to create a form to edit multiple rows at the same time?
✍: FYIcenter.com
The answer is to use the standard tabular form. This tutorial shows you how to create a standard tabular form on an existing table.
0. Continue from the previous tutorial to create the columnar form.
1. Click "Forms" in the Objects list. Then "Create form by using wizard". The "Form Wizard" dialog box shows up.
2. Select "Table: Account" in the Tables/Queries list. Then click ">>" icon to select all Available fields. Click Next. The layout selection shows up.
3. Select Tabular and click Next. The style selection shows up.
4. Select Standard and click Next. The title question shows up.
5. Enter "Account List" as the title and click Finish. The simple standard tabular form is created for the Account table.
6. You can modify any existing records displayed.
You can also insert a new record by entering data in the last empty row as show in the picture below:

2010-04-10, ≈25🔥, 0💬
Popular Posts:
What is the scheduled task "\Microsoft\Windows\Wini net\CacheTask"on my Windows 7 computer? "\Micros...
This is what I do Charms bar >Settings> Change my PC settings > User > "Trust this PC" When I get my...
Can I disable Windows service "EvtEng" to speedup my computer? Windows service "EvtEng" - Intel Even...
Can I remove startup application "shstat.exe - VirusScan On-access scanner statistics" to speedup my...
I have created a table in MS Access. How do I create a form to help enter data into the table? Assum...