SiblingRivalry
New member
- Local time
- Today, 10:18
- Joined
- Dec 4, 2006
- Messages
- 4
Hello.
I am VERY new to working with Access and am trying to complete a project that will document the locations of all of my poems and stories.
I currently have a textbox on the form that stores hyperlink data in a table. I have been typing in the relative file locations so that they can be opened regardless of what computer or drive I have the files on.
Example:
The database is in a folder D:\Writing\Contents.MDB
There are folders called D:\Writing\Stories, D:\Writing\Poems, etc..
I type in the hyperlink locations based on their relationship to the database
So Poem1.doc would be typed as Poems\Poem1.doc (opens doc)
If a story contains multiple docs then I would like to a subfolder
So a multi doc story would be typed as Stories\Multiple1\ (opens folder)
My goal is to create a command button that will browse for both files and folders and return their "relative locations" in relation to the database. I found a module and onclick() event procedure that would select a single file and return its "absolute location" to a text box but I can't figure out how to get it to select a folder and/or return the "relative location" of the file/folder selected.
Does anyone have any advice on if this is possible or how I should proceed? I apologize if any of my terminology is incorrect. I have very limited knowledge in this area.
Thanks!
I am VERY new to working with Access and am trying to complete a project that will document the locations of all of my poems and stories.
I currently have a textbox on the form that stores hyperlink data in a table. I have been typing in the relative file locations so that they can be opened regardless of what computer or drive I have the files on.
Example:
The database is in a folder D:\Writing\Contents.MDB
There are folders called D:\Writing\Stories, D:\Writing\Poems, etc..
I type in the hyperlink locations based on their relationship to the database
So Poem1.doc would be typed as Poems\Poem1.doc (opens doc)
If a story contains multiple docs then I would like to a subfolder
So a multi doc story would be typed as Stories\Multiple1\ (opens folder)
My goal is to create a command button that will browse for both files and folders and return their "relative locations" in relation to the database. I found a module and onclick() event procedure that would select a single file and return its "absolute location" to a text box but I can't figure out how to get it to select a folder and/or return the "relative location" of the file/folder selected.
Does anyone have any advice on if this is possible or how I should proceed? I apologize if any of my terminology is incorrect. I have very limited knowledge in this area.
Thanks!
