Browse for Folders Dialog

[DD]

I have been on VBnet and used the Browse for Folders Dialog code, i
have two problems

1.Access keeps telling me that the Unload Me is an unknown.
2. What i really want is to open the dialog go to a folder then open
the folder and pick a file that is then placed in a textbox.

Any help please
Thanks

[Larry Linson]

Re: Browse for Folders Dialog

VBNet is a great VB resource. "Unload Me" is great VB, but it isn't the way
we normally close forms in Access. Try the Browse for Folders code, that is
intended to work with Access, that you'll find at
http://www.mvps.org/access/api/api0002.htm. BTW, _The Access Web_,
http://www.mvps.org/access, is a great Access resource.

Larry Linson
Microsoft Access MVP



"DD" <david.deacon@b igpond.com.au> wrote in message
news:1412655e.0 401041900.16a56 39c@posting.goo gle.com...[color=blue]
> I have been on VBnet and used the Browse for Folders Dialog code, i
> have two problems
>
> 1.Access keeps telling me that the Unload Me is an unknown.
> 2. What i really want is to open the dialog go to a folder then open
> the folder and pick a file that is then placed in a textbox.
>
> Any help please
> Thanks[/color]

[JSand42737]

Re: Browse for Folders Dialog

In article <1412655e.04010 41900.16a5639c@ posting.google. com>,
david.deacon@bi gpond.com.au (DD) writes:
[color=blue]
>I have been on VBnet and used the Browse for Folders Dialog code, i
>have two problems
>
>1.Access keeps telling me that the Unload Me is an unknown.
>2. What i really want is to open the dialog go to a folder then open
>the folder and pick a file that is then placed in a textbox.
>
>Any help please
>Thanks
>[/color]

Rather than use the code from VBNet, which is designed specifically for VB
(most of the code will work under Access, but may need a bit of tweaking where
VB differs from VBA), use the code that is on the Access Web. There is code for
the BrowseFolder API at http://www.mvps.org/access/api/api0002.htm, but also
there is the code for Widows File Open/Save dialog box, which appears to be
what you want, at http://www.mvps.org/access/api/api0001.htm.


--

Jon

www.applecore99.com - Access Tips and Tricks

[Larry Linson]

Re: Browse for Folders Dialog

"Larry Linson" <bouncer@localh ost.not> wrote in message news:<DC4Kb.496 24$E17.22423@nw rddc02.gnilink. net>...[color=blue]
> VBNet is a great VB resource. "Unload Me" is great VB, but it isn't the way
> we normally close forms in Access. Try the Browse for Folders code, that is
> intended to work with Access, that you'll find at
> http://www.mvps.org/access/api/api0002.htm. BTW, _The Access Web_,
> http://www.mvps.org/access, is a great Access resource.
>
> Larry Linson
> Microsoft Access MVP
>
>
>
> "DD" <david.deacon@b igpond.com.au> wrote in message
> news:1412655e.0 401041900.16a56 39c@posting.goo gle.com...[color=green]
> > I have been on VBnet and used the Browse for Folders Dialog code, i
> > have two problems
> >
> > 1.Access keeps telling me that the Unload Me is an unknown.
> > 2. What i really want is to open the dialog go to a folder then open
> > the folder and pick a file that is then placed in a textbox.
> >
> > Any help please
> > Thanks[/color][/color]


To All CDMA Participants Old and New:

I've recently accepted Jesus Christ as my personal savior. I want to
become a "new" Larry Linson. Therefore I'm repudiating this post and
all of my posts to CDMA over these many years. Those posts were the
work of the "old" Larry Linson. He was a liar and a deceiver.

To all of you who've supported me I can only say I'm sorry for letting
you down. To all of you whose work I've stolen I say I will never do
it again. And to those of you I've slandered or hurt in some way I
hope you'll find it in your heart to forgive me.

Respectfully Yours,
(The New) Larry Linson

[Randy Harris]

Re: Browse for Folders Dialog

Gee Larry, it looks as though, in addition to a new outlook, you got a new
ISP and a new anonymous account to post to this newsgroup. Maybe you should
be careful about making so many changes at one time, people might think it
isn't really you posting these messages.

[Tony Toews]

Re: Browse for Folders Dialog

"Randy Harris" <randy@SpamFree .com> wrote:
[color=blue]
>Gee Larry, it looks as though, in addition to a new outlook, you got a new
>ISP and a new anonymous account to post to this newsgroup. Maybe you should
>be careful about making so many changes at one time, people might think it
>isn't really you posting these messages.[/color]

<chuckle>

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm