VIEWING APPLICATIONS IN ACCESS

  • Thread starter Thread starter Beeyen
  • Start date Start date
B

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
 
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
Click to expand...

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.
 
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
 
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.
 
Beeyen was thinking very hard :
Good Day Mr Boyce,
Click to expand...
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.
Click to expand...
Thanks again.
Click to expand...
"Jeff Boyce" wrote:
Click to expand...

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
:D

grtz
 
Back
Top