+ Reply to Thread
Results 1 to 7 of 7

Data Access Pages and Userforms?

  1. #1
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Data Access Pages and Userforms?

    Hi
    Does anyone know the difference between a data access page and a userform in terms of their uses. I have an idea of something I want to build using a userform but think it would be better as a data access page. What would be the disadvantage of using a data access page and can it do all the same things a userform can. If so, then why do we use userforms?

    Thanks.
    Last edited by danny2000; 04-10-2009 at 08:28 AM.

  2. #2
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Data Access Pages and Userforms?

    Get some information about Data Access Pages and Userforms:

    http://www.wcape.school.za/subject/C...ages/intro.htm

    http://msdn.microsoft.com/en-us/library/aa155729.aspx
    ExlGuru

  3. #3
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Re: Data Access Pages and Userforms?

    Thanks, though is there anything I can't do on a data access page that can only be achieved on a userform.

    Basically I want to build and interface with Embedded linked excel worksheets, textboxes and the usual buttons etc. I think the Data access page would be a much better tool for this because it seems lighter and can be run like a userform.

    Can everything be achieved with a Data Access page.

    Thanks again.
    Danny2000

  4. #4
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Data Access Pages and Userforms?

    As per your requirements Data Access Page is better option for you.

  5. #5
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Re: Data Access Pages and Userforms?

    Thanks for replying.

    So when would a data access page not be a better option than a userform?

    Cheers
    Danny2000

  6. #6
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Data Access Pages and Userforms?

    Get related information from there.May this be helpful for you.

    http://office.microsoft.com/en-us/ac...621531033.aspx

  7. #7
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Wink Re: Data Access Pages and Userforms?

    Thanks so much.

    This is exactly what I am looking for.

    Danny2000

+ 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