Insert Object Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having two problems when using insert object.

First I am trying to insert a Excel Spreadsheet that has math formulas build
in to it.
I created a blank form and in design view selected Insert Object, then
selected Create from File, then I selected my spreadsheet, when everything is
done I end up with a photo image of my spreadsheet, none of the cells can be
clicked on.

Next I am trying to insert a premade 4 page Adobe report that allows you to
tab to all the fields and enter the info.

Again I created a new report in design view and selected Insert Object, then
Create from File, Then selected my Adobe Report, when all is done I get an
image of the first page and thats it - the remaing three pages are missing
and the first page is just an image does not allow you to type in any of the
fields.

What am I doing wrong ?

Thanks - George
 
Hi George,

That's how it works. When you use Insert Object on a form or report,
Access creates an UnboundObjectFrame control to hold it. This (like the
related BoundOjectFrame) normally just displays an image of all or part
of the first page of the document you've assigned to it.

If you want to see more you have to "activate" the document in its
parent application, usually by double-clicking on the control. The Verb
property of the control determines whether the document opens inside the
control (in which case its parent application's menus will take over
from Access's) or in its own window.
 
Back
Top