Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

can EXCEL file sick on the FORM?

Discussion in 'Information Technology' started by Martin \(Martin Lee\), Jul 28, 2006.

  1. Martin \(Martin Lee\)

    Martin \(Martin Lee\)
    Expand Collapse
    Guest

    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!
     
  2. Loading...

    Similar Threads Forum Date
    Canada Sukhdeep Kaur Chohan of Brampton Wins PM Award for Teaching Excellence Breaking News Mar 5, 2014
    India Sikh Regiment's Passion for Excellence Breaking News May 19, 2013
    Leisure Excellence -skills-Attitude Business, Lifestyle & Leisure Feb 14, 2010
    Katha Excellent Katha by Bhai Ram Singh Kathavachak Videos Aug 8, 2009
    [SPN] Celebrating Five Years of Excellence & Learning Announcements Jun 3, 2009

  3. Arthur

    Arthur
    Expand Collapse
    Guest

    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

    HTH
     
  4. Martin \(Martin Lee\)

    Martin \(Martin Lee\)
    Expand Collapse
    Guest

    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.

    "Arthur" <arthurjr07@gmail.com>
    ??????:1149138185.018655.102220@i40g2000cwc.googlegroups.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
    >
    > HTH
    >
     
  5. Arthur

    Arthur
    Expand Collapse
    Guest

    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.

    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
     
  6. Martin \(Martin Lee\)

    Martin \(Martin Lee\)
    Expand Collapse
    Guest

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

    enabled = Yes
    lock = No

    "Arthur" <arthurjr07@gmail.com>
    ??????:1149141842.299055.271960@g10g2000cwb.googlegroups.com...
    > 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.
    >
    > 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
    >
     

Share This Page