Improve company productivity with a Business Account.Sign Up

x
?
Solved

Microsoft Office Spreadsheet 9.0 control in Access - problem

Posted on 2004-08-18
2
Medium Priority
?
374 Views
Last Modified: 2007-11-27
I have loaded this control twice and also reloaded Access entirely.  I still encounter the same error message.

I activate a NEW MDB program and create a NEW FORM.  From the toolbox' long list of available controls I choose the MS Office Spreadsheet 9.0 control and apply it to the new form.   I run the form - everything looks good - but when I press the toolbox icon located on the MS Office Spreadsheet control I receive the Spreadsheet Property Toolbox form with the 5 small icon areas X'd in red.

Simultaneously an Internet Explorer Script Error window opens saying "An error has occured in the script on this page."  
The message continues with:
   Line 14
   Char 1
   Error: Object Expected
   Code 0
   URL  its:C:\PROGRA~1\MICROS~2\Office\1033\msowc.sll::/webxl/pbwebcalcrt.htm
   Do you want to continue running scripts on this page?

What am I doing wrong - or what did I not do?  I'll appreciate your help since I would like to use this control.
0
Comment
Question by:ljcor
2 Comments
 
LVL 86

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 11829502
This is a Web Component ... it would have to be run from within an instance of IE (which Access opens for you) ... instead, if you need a spreadsheet, consider using the Excel object (it's there in the same area where you found this control). You'll have a lot more control, and the spreadsheet component doesn't expose near the object library as does Excel.
0
 

Author Comment

by:ljcor
ID: 11837418
Thanks very much for your explanation.  I will try to get into loading the Excel spreadsheet instead.

Jack

0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question