John



Yes, I did find an article. It gave me lots of info. I'm still trying to find
out how to do more than what is contained in it. I have enough to do just the
rudimentary act of snagging the path, but I wanted to do more about controlling
the folder view.



Regards,

Bill



From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, January 12, 2009 4:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Working with SharePoint folders



Bill-

Didn't you post earlier that you had found an MSDN article? Sorry, don't
have any more ideas.

John Viescas, author
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)


-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Monday, January 12, 2009 9:58 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Working with SharePoint folders

John

Thanks. I'm using 2003. The Custom property in the properties box
just gives me an error.

To give you a better idea of what I'm trying to do...

This is an Acc 2003 project management database. One of the project
table fields is the path to the documentation folder (each project
has its own folder in SharePoint). All I really need to do is have a
way for the user to get the general directory where each of the
project folders lives and then navigate to the specific folder thus
capturing the path for future exploration.

It would be like using the common dialog box to browse for a folder,
but being SharePoint, the "path" is really a URL so the common dialog
fails.

Funny thing, though, is if I use the common dialog box and pass the
sharepoint directory, the dialob box opens to the correct path but
shows the actual web "folders" instead of folders as would be seen in
Explorer. But if I select a folder and click OK I get an error
saying "You cannot use an Internet address here. Enter a path that
points to a location on your computer of on the network." I even
tried typing in the path that works in the Win Explorer. Same error!

Bill

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas"
<JohnV@...> wrote:
>
> Bill-
>
> You can often right-click the ActiveX control on your form, then
choose X
> Object / Properties (where X is the name of the control type) and
get a
> dialog box that gives some info. If there's a Help button on that,
it
> should take you to the help file that describes the embedded
properties /
> methods.
>
> You're using 2007, right? I guess linking to SharePoint doesn't
cut it -
> you want to browse stuff.
>
> John Viescas, author
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
Mosca
> Sent: Monday, January 12, 2009 6:06 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Working with SharePoint folders
>
> Hi All
>
> It's been quite a while since I posted a question, but I'm delving
> into unfamiliar waters.
>
> We have all our documentation for our projects in SharePoint
folders
> so the usual common dialog box for browsing to a folder won't work.
> I've come up with a work-around by using a web browser control for
> finding a project's folder. Yes, it is an activeX control, but I
have
> no other way to do this. If someone else has a better way, I'm all
> for it so please post.
>
> I need a resource for all the properties/methods for a web browser
> control so I can better control it. Right now, it opens showing the
> folders, but also a task pane for creating new folders, deleting
> existing ones, etc. Refreshing it makes the pane disappear.
>
> In some cases, all I want is a view of the folders, but in others,
I
> would need the task pane to show.
>
> Regards,
> Bill Mosca,
> http://www.thatlldoit.com
> Founder - MS_Access_Professionals
> http://tech.groups.yahoo.com/group/MS_Access_Professionals/
> Microsoft Office Access MVP
> http://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links





[Non-text portions of this message have been removed]