VIEWING APPLICATIONS IN ACCESS

[Beeyen]

Is it possible to view an application such as an excel spreadsheet or a word
document inside of a form, as a part of the form and not a hyperlink.

If so, how can it be accomplished.

Thanks

 

[fredg]

Is it possible to view an application such as an excel spreadsheet or a word
document inside of a form, as a part of the form and not a hyperlink.

If so, how can it be accomplished.

Thanks

You could use an OLEUnbound control to Link to the Word or Excel
object.
However, only the first page/sheet of your Word/Excel workbook will
display.
If you set the control's Enabled property to Yes, and it's Locked
property to No you can click on the control and open the
document/sheet for editing.

Remember to LINK, not embed, to the object.

 

[Jeff Boyce]

Are you trying to "view the application", or view one of the files created
using the application?

If you need to open a, say, Word document, why do you need to "stay" inside
Access while working in Word? I don't understand your business
need/requirement well enough to offer suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Beeyen]

Good Day Mr Boyce,

Thank you for the quick response. It appears that the spreadsheet has
individual qualitative information and needs to be available with the record,
so not create the spreadsheet as a form is not an option.

Thanks again.

 

[chriske911]

Beeyen was thinking very hard :

Good Day Mr Boyce,

Thank you for the quick response. It appears that the spreadsheet has
individual qualitative information and needs to be available with the record,
so not create the spreadsheet as a form is not an option.

Thanks again.

"Jeff Boyce" wrote:

if you need to be able to scroll thru records and show the linked excel
sheet on every new record it may be better to have that data in an
access table

you can then link excel to it, it is the other way around of thinking


grtz