Inserting an Excel Worksheet into an Access form

[E]

I'm working on a project that records various metrics and displays them in a
crosstab type format (date/year as column headings and metric, business unit
as rows). I'd like to insert an excel worksheet in the access form to
display the results of the crosstab query.

So far I haven't been able to make this work. I inserted the Excel sheet as
an object and set the row source type to table/query. I then pointed the row
source to the appropriate query. Thus far I am only able to populate the A1
cell, nothing more. Am I missing something or is there a good reference you
guys can point me towards?

thanks

 

[Arvin Meyer [MVP]]

Why don't you simply use an Access crosstab query?

 

[Tom van Stiphout]

On Tue, 2 Feb 2010 13:51:01 -0800, E <[email protected]>
wrote:

Embedding Excel objects in an Access form is possible, but is
definitely an advanced topic. The rowsourcetype and rowsource
properties have nothing to do with it.
Once embedded, you can get an Excel object reference, and using that
reference and the Excel object model you can further manipulate the
object. As I said, this requires expert VBA skills and knowledge. If
that's not you, Arvin is making an excellent suggestion.

-Tom.
Microsoft Access MVP

 

[E]

I'd like to see the reults embedded in the form. Are you saying embed the
crosstab into the form? I'm not sure how you would do that. Currently, I'm
showing a smaller slice (one month at a time) in a listbox. Usinsg the
listbox they can see the results of their entry and edit or delete as needed.

The other reason I wanted to use Excel is the current sheet they are using
for entry has a color coding set-up based on the results.

 

[Arvin Meyer [MVP]]

A subform in datasheet view, based on the crosstab query should do fine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com