+ Reply to Thread
Results 1 to 3 of 3

Excel Userform to Access

  1. #1
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Excel Userform to Access

    I wrote a fairly simple userform which collects data and puts the data in an Excel worksheet.

    Does Access use userforms?

    And if so, how difficult would it be to convert an Excel userform so it could be used in Access?

    For those who might not know me. I have a fair grasp of VBA, but my knowledge of Excel is okay/weak, and my knowledge of Access is none.

    Maybe I'm being naive (and if so, I want to be told so), but it seems to me that all I have to do is translate lines like:

    Please Login or Register  to view this content.
    And instead of writing the information into an Excel worksheet, write the information into Access.

    What do you think?
    Last edited by StevenM; 07-17-2012 at 09:11 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel Userform to Access

    Access does use user forms but they are not the same as the rest of the Office programs so you can't simply copy across or import/export. In any event the Access object model is naturally totally different to Excel so you will likely have to rewrite most things anyway (Access controls are naturally more data aware so easier to work with in that respect)
    Remember what the dormouse said
    Feed your head

  3. #3
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Excel Userform to Access

    Thanks for the input!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1