Categories:
Administration (161)
Adware Spyware (43)
Apache (20)
Bluetooth (127)
DOS Commands (2)
Edge (28)
General (5)
Internet Connection (21)
Internet Explorer (224)
Media Center (14)
Media Player (135)
Mozilla Firefox (22)
MS Access (9)
Performance (204)
PHP (25)
Programming (36)
Security (109)
Silverlight (22)
Tips (144)
Tools (312)
Tutorials (39)
Windows 10 (168)
Windows 7 (1411)
Windows 8 (1712)
Windows Phone (33)
Windows Server 2008 (165)
Windows Server 2012 (84)
Windows Server 2016 (23)
Windows Vista (71)
Windows XP (23)
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, 16818👍, 0💬
Popular Posts:
I have created a table in MS Access. How do I create a form to help enter data into the table? Assum...
I have a program called (Default) with no description as to what it is for. Listed in the administra...
Why am I getting this authentication failed message when adding my cell phone as a bluetooth device ...
How do I know what cookies a Website is sending to my computer? When you are visiting a Website, it ...
How can I tell the number of CPU or logical processors on my Windows Server 2012? To find out how ma...