can EXCEL file sick on the FORM?

#1 (**permalink**) 28-Jul-2006, 08:14 AM

How can I "stick" one of my own WORD file or EXCEL file on an ACCESS FORM ?

When the users open this FORM, they only need to click the WORD(or EXCEL)
icon to open my WORD or EXCEL file.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10651-can-excel-file-sick-on-form.html

Thanks!

*

#2 (**permalink**) 28-Jul-2006, 08:14 AM

Ayon kay Martin (Martin Lee):
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
> How can I "stick" one of my own WORD file or EXCEL file on an ACCESS FORM ?
>
> When the users open this FORM, they only need to click the WORD(or EXCEL)
> icon to open my WORD or EXCEL file.
>
> Thanks!

hi martin,

you can open an excel file using this vba.
say you have a commandbutton, copy and paste the
code below to the click event of that button.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651

Dim ExcelApp As Object
Set ExcelApp = CreateObject("Excel.Application")
Shell ExcelApp.Path & "\excel.exe " & "C:\book1.xls"
Set ExcelApp = Nothing

you have to replace "C:\book1.xls" with the path of your
excel file.

if you would like to open a word document use this instead

Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
Shell WordApp.Path & "\winword.exe " & "C:\arthur.doc"
Set WordApp = Nothing

HTH

#3 (**permalink**) 28-Jul-2006, 08:14 AM

No, this is not I want. I want the EXCEL file be carried by the ACESS file.
So that I could send e-mail to my friends only attach one ACCESS file (which
contain the EXCEL file in it).

Thanks anyway.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
"Arthur"
??????:1149138185.018655.102220@i40g2000cwc.google groups.com...
>
> Ayon kay Martin (Martin Lee):
>> How can I "stick" one of my own WORD file or EXCEL file on an ACCESS FORM
>> ?
>>
>> When the users open this FORM, they only need to click the WORD(or EXCEL)
>> icon to open my WORD or EXCEL file.
>>
>> Thanks!
>
> hi martin,
>
> you can open an excel file using this vba.
> say you have a commandbutton, copy and paste the
> code below to the click event of that button.
>
> Dim ExcelApp As Object
> Set ExcelApp = CreateObject("Excel.Application")
> Shell ExcelApp.Path & "\excel.exe " & "C:\book1.xls"
> Set ExcelApp = Nothing
>
> you have to replace "C:\book1.xls" with the path of your
> excel file.
>
> if you would like to open a word document use this instead
>
> Dim WordApp As Object
> Set WordApp = CreateObject("Word.Application")
> Shell WordApp.Path & "\winword.exe " & "C:\arthur.doc"
> Set WordApp = Nothing
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
>
> HTH
>

#4 (**permalink**) 28-Jul-2006, 08:14 AM

Hi martin

Use the Unbound Object Frame.

Create a form in design view then
add a unbound Object frame in that form
then a wizard will be prompted to you.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651

in that wizard choose "Create from files"
then browse for the file you want to embed
and dont forget to checked the "Display as Icon"

then after you have added the control you need to
set its property

special effect = flat
back color = same with back color of the form
border color = same with back color of the form
enabled = Yes

after that run the form
double click the icon.

hope this will help

#5 (**permalink**) 28-Jul-2006, 08:14 AM

Thank you!
This two attribute is extremely easy to forget:

enabled = Yes
lock = No

"Arthur"
??????:1149141842.299055.271960@g10g2000cwb.google groups.com...
> Hi martin
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
> Use the Unbound Object Frame.
>
> Create a form in design view then
> add a unbound Object frame in that form
> then a wizard will be prompted to you.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10651
> in that wizard choose "Create from files"
> then browse for the file you want to embed
> and dont forget to checked the "Display as Icon"
>
> then after you have added the control you need to
> set its property
>
> special effect = flat
> back color = same with back color of the form
> border color = same with back color of the form
> enabled = Yes
>
>
> after that run the form
> double click the icon.
>
> hope this will help
>