Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts

    Browse to file - VBA

    I need to allow my users to navigate to a file, so I can then retrieve the path to the file and do with the file what I will. I've found a buch of examples but none seem to work. I just need the same functionality as <input type="file" /> in HTML. I'm using Access 2000. I guess I could write a script to do it myself, but it seems as though there should just be a way to open the built in dialogue.

    Thanks,
    Basscyst
    Last edited by Basscyst; 01-20-2005 at 08:53 PM.
    Helping to build a bigger box. - Adam Matthews

  • #2
    Regular Coder
    Join Date
    Aug 2004
    Location
    codegoboom@yahoo.com
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If the Access OM doesn't have a method, this may do it: Using the Common Dialog Control
    *this message will self destruct in n-seconds*

  • #3
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    If you can't use the common dialog control, there are some API calls you can make to do it. I'm sure you can find them if you were to search around.
    OracleGuy

  • #4
    Regular Coder
    Join Date
    Aug 2004
    Location
    codegoboom@yahoo.com
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts
    And if you can't find those,

    Windows Program Compatibility Wizard registers a CompatUI.SelectFile class, which mimics the html form control...
    Last edited by codegoboom; 01-21-2005 at 03:37 PM. Reason: sure
    *this message will self destruct in n-seconds*

  • #5
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts
    Thanks guys, I have to redesign something I made using an hta front end, access backend, to an access front end, sql back. I think I have it all mapped out once I get this file browsing figured out.

    Basscyst
    Helping to build a bigger box. - Adam Matthews


  •  

    Posting Permissions

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