XL7: How to Return to Microsoft Excel After Using Access Form

ID: Q137739

The information in this article applies to:

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

  1. Open a new Microsoft Excel workbook.


  2. 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


  3. Save your workbook. You must do this before you create a form.


To create a form using a Microsoft Access wizard

  1. Select cell A1.


  2. 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.


  3. In the Create Microsoft Access Form dialog box, choose New Database and then click OK.


  4. In the Form Wizard, double-click each of the fields listed in the Available Fields box, and then click Next.


  5. Choose the Columnar layout type and then click Next.


  6. 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

  1. On the File Menu, click Close. This will close your form.


  2. 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        :

Last Reviewed: May 2, 1999