Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact
A1VBCode Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » Visual Basic (VB 4/5/6) » VBA(Excel, Word, etc...) » Folder Dialog Option for Access


Folder Dialog Option for AccessExpand / Collapse
Author
Message
Posted 7/22/2008 3:30:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/24/2008 11:07:17 AM
Posts: 2, Visits: 6
Hello everyone,

I am very good with Access and I know VB (I am not an expert but I understand the code). Here is what I am trying to do with less code as possible:

1. I want to create a button in Access that will allow me to navigate to a folder (the folder is located in a tree three or four folders down) using the folder dialog option. I do not want to use the commondialog button but would rather hard code if possible.

2. Once I locate the folder I want to click the folder and automatically import certain files that are in the folder into Access. The folder will contain files such as jpg, doc, txt, xls, xml, and gifs. I only want to import all xml files into Access.

Is there a simple and quick way to do this? I need to be able to use this in other projects as well.

Also, I want to call this procedure from a module.

Thanks to anyone who can help me with this issue.

Thanks,

bdthomas02
 


Thanks and have a great day,

bdthomas02
Post #25448
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Brian, Peter

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 10:08am