From: Daedalus on
Hi

I can't find the proper way to use a common dialog box (file selection) on
one of my forms, though I'm sure it can not be too difficult. So I guess you
guys can help me out ?

Tanx in advance !

D


From: Keith Wilby on
"Daedalus" <fdprojects(a)hotmail.com> wrote in message
news:4b444ca1$0$398$5f6aeac3(a)news.scarlet.nl...
> Hi
>
> I can't find the proper way to use a common dialog box (file selection) on
> one of my forms, though I'm sure it can not be too difficult. So I guess
> you guys can help me out ?
>
> Tanx in advance !
>
> D
>

Search the help for "FileDialog".

Keith.
www.keithwilby.co.uk

From: Daedalus on

"Keith Wilby" <here(a)there.com> schreef in bericht
news:4b44a191_1(a)glkas0286.greenlnk.net...
> "Daedalus" <fdprojects(a)hotmail.com> wrote in message
> news:4b444ca1$0$398$5f6aeac3(a)news.scarlet.nl...
>> Hi
>>
>> I can't find the proper way to use a common dialog box (file selection)
>> on one of my forms, though I'm sure it can not be too difficult. So I
>> guess you guys can help me out ?
>>
>> Tanx in advance !
>>
>> D
>>
>
> Search the help for "FileDialog".
>
> Keith.
> www.keithwilby.co.uk

I can find that help-info, but as soon as I refer to 'FileDialog' I get an
error. I suppose I should include a certain type of control, but don't know
which :-( And 'Microsoft Common Dialog' is not in the list ::-(


From: Keith Wilby on
"Daedalus" <fdprojects(a)hotmail.com> wrote in message
news:4b44b1ac$0$402$5f6aeac3(a)news.scarlet.nl...
>
>
> I can find that help-info, but as soon as I refer to 'FileDialog' I get an
> error. I suppose I should include a certain type of control, but don't
> know which :-( And 'Microsoft Common Dialog' is not in the list ::-(
>

What version of Access are you using? The method I suggested is available
from 2k3 onwards IIRC.

From: Daedalus on

"Keith Wilby" <here(a)there.com> schreef in bericht
news:4b44b60c$1_1(a)glkas0286.greenlnk.net...
> "Daedalus" <fdprojects(a)hotmail.com> wrote in message
> news:4b44b1ac$0$402$5f6aeac3(a)news.scarlet.nl...
>>
>>
>> I can find that help-info, but as soon as I refer to 'FileDialog' I get
>> an error. I suppose I should include a certain type of control, but don't
>> know which :-( And 'Microsoft Common Dialog' is not in the list ::-(
>>
>
> What version of Access are you using? The method I suggested is available
> from 2k3 onwards IIRC.


I'm using Office (Access) 2003. I suppose I need to include a add-in or so ?
The error I get is on line
Dim dlgOpen As FileDialog
and it says (translated from Dutch)
Compilation error
A userdefined datatype is not defined