|
|
 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
|
 |
|
|
 |
January 4th, 2007, 08:22 AM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
opening a folder location
hi,
would like a button that opens he folder created earlier by a procedure.
My question is what is the VBA to open a folder, im sure its a easy question for you guys!
Cheers
|
January 4th, 2007, 08:26 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
What do you mean "open a folder?"
mmcdonal
|
January 4th, 2007, 09:36 AM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Assuming you mean to open an Explorer window at the given folder location... try something like:
Call Shell("explorer.exe X:\Location\etc", vbNormalFocus)
|
January 4th, 2007, 01:48 PM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
cheers how can i call the folder from a string?
|
January 4th, 2007, 05:42 PM
|
|
Registered User
|
|
Join Date: Oct 2006
Location: Leigh, Lancashire, United Kingdom.
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Do you mean to put a file in the folder or to physically open the folder to display it?
|
January 5th, 2007, 06:54 AM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Jonni,
What do you mean by: "... call the folder from a string"?
|
January 5th, 2007, 09:01 AM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
sorry i was not sure how to formulate my question (obviously)
its working now,
Dim strShortcut As String
strShortcut = Me.txtShortcut
Call Shell("explorer.exe " & strShortcut, vbNormalFocus)
i had problems where i did not leave a space between .exe and the " but its working now, cheers for taking time to ponder my query
Jonni
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
