ACCESS FEED: Re: [MS_AccessPros] Link

Kamis, 12 Juni 2014

Re: [MS_AccessPros] Link

not sure what you want to do once there, but these may help

http://support.microsoft.com/kb/824272

http://access.mvps.org/access/api/api0001.htm

if looking to pick a file or files

On Wed, Jun 11, 2014 at 6:02 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Here is the code that I use to open a network folder.

Private Sub cmdOpenExportFolder_Click()
Dim ProjPath
ProjPath = "Put Path here Database\Exports\" '& Me.PolicyNo.Value

Shell "C:\WINDOWS\explorer.exe """ & ProjPath & "", vbNormalFocus
End Sub

Could you explain what you mean by going to the files? If you are saying open the file like an attachment or something else. Just add the name of the file to the path after my word Exports\

Jim Wagner

On Wednesday, June 11, 2014 2:49 PM, "'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

I am wondering if it is possible to make a button on one of my forms browse to a certain location on my network or on my computer. I keep going back and forth and it would sure be nice to have quicker access.

The next question is… is it possible for that button to go to different files on the network based on the Access record that I am on?

Thanks for your help.

Bill

MN