Microsoft KB Archive/166352: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 88: Line 88:
# On the Data menu, point to Get External Data, and then click Create New Query.
# On the Data menu, point to Get External Data, and then click Create New Query.
# Select your data source and click OK.
# Select your data source and click OK.
# Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
# Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
# Click "Return Data to Microsoft Excel" to select it, and then click Finish.
# Click "Return Data to Microsoft Excel" to select it, and then click Finish.
# In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
# In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
# Save the workbook as Book1.
# Save the workbook as Book1.
# On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the &quot;Symptoms&quot; section.<br />
# On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the "Symptoms" section.<br />
<br />
<br />
NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in.
NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in.
Line 102: Line 102:
== REFERENCES ==
== REFERENCES ==


For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for &quot;AccessLinks add-in,&quot; and then &quot;Convert a Microsoft Excel list to a Microsoft Access database.&quot;
For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for "AccessLinks add-in," and then "Convert a Microsoft Excel list to a Microsoft Access database."


</div>
</div>

Latest revision as of 10:03, 21 July 2020

Article ID: 166352

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Access 97 Standard Edition



This article was previously published under Q166352

Moderate: Requires basic macro, coding, and interoperability skills.


SYMPTOMS

When you try to create a Microsoft Access form in Microsoft Excel by using the AccessLinks add-in program, and you are using data from a Microsoft Query data source, you may receive the following error message:

Cannot start Microsoft Access form or report wizard

CAUSE

You cannot use external data with the AccessLinks add-in.

RESOLUTION

When you create Microsoft Access forms in Microsoft Excel by using the AccessLinks add-in program, use only internal data for your data source.

MORE INFORMATION

Steps to Reproduce Behavior


  1. In Control Panel, create an ODBC data source to the Northwind database.
  2. Open Microsoft Excel and be sure Microsoft Query has been installed.


NOTE: If you have installed Microsoft Excel from Microsoft Office 97 Professional Edition, you will need to choose the Data Access option to install Microsoft Query.

  1. On the Data menu, point to Get External Data, and then click Create New Query.
  2. Select your data source and click OK.
  3. Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
  4. Click "Return Data to Microsoft Excel" to select it, and then click Finish.
  5. In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
  6. Save the workbook as Book1.
  7. On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the "Symptoms" section.


NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in.


REFERENCES

For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for "AccessLinks add-in," and then "Convert a Microsoft Excel list to a Microsoft Access database."

Keywords: kberrmsg kbprb KB166352