XL7: How to Return to Microsoft Excel After Using Access Form
ID: Q137739
|
The information in this article applies to:
-
Microsoft Excel for Windows 95, version 7.0
SUMMARY
In Microsoft Excel, if the AccessLinks add-in is installed, you can use the
Microsoft Access Form Wizard to guide you through building a data entry
form for a Microsoft Excel list. Once the form is created, it may not be
clear how to return to your Microsoft Excel worksheet.
The "More Information" section of this article describes how to create a
sample list in Microsoft Excel, how to create a sample form in Microsoft
Access, and how to return to your Microsoft Excel worksheet after you've
finished working with the form.
MORE INFORMATION
To create a sample list
- Open a new Microsoft Excel workbook.
- Create a sample list in Sheet1:
A1: NAME B1: CITY C1: AMOUNT
A2: Bob B2: Dallas C2: 10
A3: Sue B3: Miami C3: 9
A4: Mary B4: Buffalo C4: 8
- Save your workbook. You must do this before you create a form.
To create a form using a Microsoft Access wizard
- Select cell A1.
- On the Data menu, click Access Form.
If the Access Form command does not appear on the Data menu, make sure
the AccessLinks add-in is installed.
- In the Create Microsoft Access Form dialog box, choose New Database
and then click OK.
- In the Form Wizard, double-click each of the fields listed in the
Available Fields box, and then click Next.
- Choose the Columnar layout type and then click Next.
- Choose any of the Style types and then click Next.
You should now have a complete form. You can use the form to scroll all of
your current records and to enter new records (new records will be
automatically added to your Microsoft Excel list).
To return to Microsoft Excel
- On the File Menu, click Close. This will close your form.
- On the File Menu, click Exit.
REFERENCES
For more information about creating Microsoft Access Forms in Microsoft
Excel, click the Index tab in Microsoft Excel Help, and type the following
text
Access Form
click the Display button to go to the "Use AccessLinks forms and reports
with Microsoft Excel" topic.
Additional query words:
links howto
Keywords : kbualink97
Version : 7.00
Platform : WINDOWS
Issue type :