Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA (MS ACCESS) file browser, copy and rename files from within Access

Status
Not open for further replies.

Majnun

Programmer
Dec 2, 2002
2
US
Brief:
1)How do i create a file browser like windows explorer that allows a user to select a record in Access which has a field corresponding to a file name and a field defining its directory path... user clicks a "copy to folder" button which opens a file browser to browse to a folder on computer to copy the file to and prefixes the characters "copy" to the filename when it copies it.

And similar:

2) How do i create a file browser like windows explorer that prompts a user to browse to a file and then takes a value from a field in the current record in MS Access and renames the file based on the value taken from the field?

Extra Credit:
3) Embed windows media file in a form which plays a file based on the current record, supplying the filename and location from fields in the current record.

Scenario:
I'm creating a music library database which stores records with information on each file. Files are mostly mp3s with a few wav files. Among the info in each record with be the file name and directory location of each mp3 in the library. After searching for various criteria and getting a form with the results, the user needs to be able to select a record and audtion it (#3). If they like it then the hit a "copy to folder" button which launches a file browser, the user browses to a folder, and hits ok and the file associated with the record is copied into that folder (#1). The client wanted to start data entry prior to the completion of the DB so i need also to be able to browse to a folder and rename it based on a field in the access database (the replication ID of the record) and appended the .mp3 extension to it. (#2).

I'm a self taught programmer, and i know this must be possible but i have no idea where to begin. Any help is greatly appreciated. Actual code which may meet these needs, or be demonstrative of concepts i can adapt from is greatly appreciated. And if that isn't possible than any general pointers of concepts and strategies will be most appreciated as well.

Thanks for any help you can offer!

--jon paul duvall
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top