If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VIEWING APPLICATIONS IN ACCESS
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 |
#2
|
|||
|
|||
VIEWING APPLICATIONS IN ACCESS
On Mon, 20 Apr 2009 07:21:02 -0700, Beeyen wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
VIEWING APPLICATIONS IN ACCESS
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" wrote in message ... 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 |
#4
|
|||
|
|||
VIEWING APPLICATIONS IN ACCESS
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: 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" wrote in message ... 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 |
#5
|
|||
|
|||
VIEWING APPLICATIONS IN ACCESS
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: 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" wrote in message ... 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 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 |
Thread Tools | |
Display Modes | |
|
|