Welcome to SPN

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

Sign Up Now!

Creating a template for an Access form in Excel

Discussion in 'Information Technology' started by cathywoodford@personainternet.com, Jul 28, 2006.

  1. cathywoodford@personainternet.com

    Guest

    Hi. Just wondering if I can create a template for an Access form in
    Excel? If yes, can someone give me some ideas on how to do this.

    Thanks,
    Cathy
     
  2. Loading...

    Similar Threads Forum Date
    Canada Ottawa weighs creating ambassador for religious freedom Breaking News Oct 4, 2011
    India SGPC Accused of Creating a Row Breaking News Jan 20, 2011
    Pacific International Gathering of Young Sikhs Focuses on Creating Good Citizens Breaking News Jan 8, 2011
    Are We Creating New Devtas? Sikh Sikhi Sikhism Aug 21, 2009
    Sikh News Sharif warns against creating instability in Punjab (Express India) Breaking News Sep 19, 2008

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    I'd be extremely surprised if you could.

    Excel forms and Access forms are extremely different animals.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    <cathywoodford@personainternet.com> wrote in message
    news:1153232910.049340.69400@h48g2000cwc.googlegroups.com...
    > Hi. Just wondering if I can create a template for an Access form in
    > Excel? If yes, can someone give me some ideas on how to do this.
    >
    > Thanks,
    > Cathy
    >
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

    It would be almost as easy to convert "buttons" on your microwave oven
    to become "buttons" on your stereo.

    Ron
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    I want that song to play at Defrost for 15 seconds, please!

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Ron2006" <ronnemec@hotmail.com> wrote in message
    news:1153238578.161620.253890@h48g2000cwc.googlegroups.com...
    > It would be almost as easy to convert "buttons" on your microwave oven
    > to become "buttons" on your stereo.
    >
    > Ron
    >
     
  6. James A. Fortune

    James A. Fortune
    Expand Collapse
    Guest

    cathywoodford@personainternet.com wrote:
    > Hi. Just wondering if I can create a template for an Access form in
    > Excel? If yes, can someone give me some ideas on how to do this.
    >
    > Thanks,
    > Cathy
    >


    Hi Cathy,

    I haven't worked with forms in Excel, but Excel is capable of using
    Automation to control Access. If Excel forms are capable of running
    Excel macros you can have the macro open Access, manipulate some data in
    Access using information from the Excel form, then close Access. Since
    Access can create it's own forms programmatically, Excel can tell Access
    to do that also. It's an interesting concept but one that not many
    Access developers are forced to use. If you mean creating an Access
    form directly from Excel without using Access at all, perhaps you can
    use, IIRC, the undocumented methods SaveAsText and LoadFromText in
    Access to see what the text storage of a form looks like for Access. An
    Excel macro would be used to create a similar text file. I've never
    tried that either.

    Hope this helps,

    James A. Fortune
    MPAPoster@FortuneJames.com
     

Share This Page