Call the standard Windows File Open/Save dialog box

Hi,

I've been looking at the above API, which does indeed bring up the
OpenFile dialogue and place it into an unbound text box, but i am
having so much trouble getting it to work for my purposes. My Db has
tables that link to external images/documents and so i want a user to
be able to add new items to those via a form.

I want the following to happen:-

1. user selects a file via the openFile dialoge [done]
2. the file selected is 'copied' and placed into a specific folder
3. The new file path is placed into the appropriate table, and saved

This is the only way i can think of to get around the problem of
external files where you need to have the paths stored in the database
and the actual files accessible. I do not want the user to be able to
link from anywhere/path they like, nor should they be able to get into
the folders which store these 'master' files.

This API seems like the ideal way to do this, but i've been
experimenting for a long time now and can't find a way to do items 2 &
3 above.

Any advance would be really appreciated.

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.google groups.com...
> Hi,
>
> I've been looking at the above API, which does indeed bring up the
> OpenFile dialogue and place it into an unbound text box, but i am
> having so much trouble getting it to work for my purposes. My Db has
> tables that link to external images/documents and so i want a user to
> be able to add new items to those via a form.
>
> I want the following to happen:-
>
> 1. user selects a file via the openFile dialoge [done]
> 2. the file selected is 'copied' and placed into a specific folder
> 3. The new file path is placed into the appropriate table, and saved
>
> This is the only way i can think of to get around the problem of
> external files where you need to have the paths stored in the database
> and the actual files accessible. I do not want the user to be able to
> link from anywhere/path they like, nor should they be able to get into
> the folders which store these 'master' files.
>
> This API seems like the ideal way to do this, but i've been
> experimenting for a long time now and can't find a way to do items 2 &
> 3 above.
>
> Any advance would be really appreciated.

2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"

3. INSERT INTO [appropriate table] (FieldName)
VALUES("c:\NewFolder\FileName.ext");

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.google groups.com...
> Hi,
>
> I've been looking at the above API, which does indeed bring up the
> OpenFile dialogue and place it into an unbound text box, but i am
> having so much trouble getting it to work for my purposes. My Db has
> tables that link to external images/documents and so i want a user to
> be able to add new items to those via a form.
>
> I want the following to happen:-
>
> 1. user selects a file via the openFile dialoge [done]
> 2. the file selected is 'copied' and placed into a specific folder
> 3. The new file path is placed into the appropriate table, and saved

AIUI, the sole purpose of the dialog box is to return the path to the
selected file. You can do what you want with that path, save it to a table
or whatever, thus satisfying 1 and 3 in your list. It won't magically copy
any file anywhere else unless you write code to do that.

>
> This is the only way i can think of to get around the problem of
> external files where you need to have the paths stored in the database
> and the actual files accessible. I do not want the user to be able to
> link from anywhere/path they like, nor should they be able to get into
> the folders which store these 'master' files.

I'm not sure why you think that users won't be albe to browse anywhere they
like using this, you're getting into file permissions territory there which
is nothing to do with Access.

Keith.
www.keithwilby.com

Re: Call the standard Windows File Open/Save dialog box

On 27 Nov, 12:46, "Keith Wilby" wrote:
> wrote in message
>
> news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.google groups.com...
>
> > Hi,
>
> > I've been looking at the above API, which does indeed bring up the
> > OpenFile dialogue and place it into an unbound text box, but i am
> > having so much trouble getting it to work for my purposes. My Db has
> > tables that link to external images/documents and so i want a user to
> > be able to add new items to those via a form.
>
> > I want the following to happen:-
>
> > 1. user selects a file via the openFile dialoge [done]
> > 2. the file selected is 'copied' and placed into a specific folder
> > 3. The new file path is placed into the appropriate table, and saved
>
> AIUI, the sole purpose of the dialog box is to return the path to the
> selected file. You can do what you want with that path, save it to a table
> or whatever, thus satisfying 1 and 3 in your list. It won't magically copy
> any file anywhere else unless you write code to do that.
>
>
>
> > This is the only way i can think of to get around the problem of
> > external files where you need to have the paths stored in the database
> > and the actual files accessible. I do not want the user to be able to
> > link from anywhere/path they like, nor should they be able to get into
> > the folders which store these 'master' files.
>
> I'm not sure why you think that users won't be albe to browse anywhere they
> like using this, you're getting into file permissions territory there which
> is nothing to do with Access.
>
> Keith.www.keithwilby.com

Thanks ken,

I'm not talking about permissions, i just don't want users to be aware
of where all external files are stored and i certainly don't want the
actual folders displayed. I just want them to be able to add files to
the underlying folders programatically, which has everything to do
with access.

Re: Call the standard Windows File Open/Save dialog box

On 27 Nov, 12:35, "Stuart McCall" wrote:
> wrote in message
>
> news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.google groups.com...
>
>
>
>
>
> > Hi,
>
> > I've been looking at the above API, which does indeed bring up the
> > OpenFile dialogue and place it into an unbound text box, but i am
> > having so much trouble getting it to work for my purposes. My Db has
> > tables that link to external images/documents and so i want a user to
> > be able to add new items to those via a form.
>
> > I want the following to happen:-
>
> > 1. user selects a file via the openFile dialoge [done]
> > 2. the file selected is 'copied' and placed into a specific folder
> > 3. The new file path is placed into the appropriate table, and saved
>
> > This is the only way i can think of to get around the problem of
> > external files where you need to have the paths stored in the database
> > and the actual files accessible. I do not want the user to be able to
> > link from anywhere/path they like, nor should they be able to get into
> > the folders which store these 'master' files.
>
> > This API seems like the ideal way to do this, but i've been
> > experimenting for a long time now and can't find a way to do items 2 &
> > 3 above.
>
> > Any advance would be really appreciated.
>
> 2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"
>
> 3. INSERT INTO [appropriate table] (FieldName)
> VALUES("c:\NewFolder\FileName.ext");- Hide quoted text -
>
> - Show quoted text -

Thanks for pointing me in the rigt direction. I'll give it a go

Re: Call the standard Windows File Open/Save dialog box

On 27 Nov, 12:57, redpears...@hotmail.com wrote:
> On 27 Nov, 12:35, "Stuart McCall" wrote:
>
>
>
>
>
> > wrote in message
>
> >news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.googl egroups.com...
>
> > > Hi,
>
> > > I've been looking at the above API, which does indeed bring up the
> > > OpenFile dialogue and place it into an unbound text box, but i am
> > > having so much trouble getting it to work for my purposes. My Db has
> > > tables that link to external images/documents and so i want a user to
> > > be able to add new items to those via a form.
>
> > > I want the following to happen:-
>
> > > 1. user selects a file via the openFile dialoge [done]
> > > 2. the file selected is 'copied' and placed into a specific folder
> > > 3. The new file path is placed into the appropriate table, and saved
>
> > > This is the only way i can think of to get around the problem of
> > > external files where you need to have the paths stored in the database
> > > and the actual files accessible. I do not want the user to be able to
> > > link from anywhere/path they like, nor should they be able to get into
> > > the folders which store these 'master' files.
>
> > > This API seems like the ideal way to do this, but i've been
> > > experimenting for a long time now and can't find a way to do items 2 &
> > > 3 above.
>
> > > Any advance would be really appreciated.
>
> > 2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"
>
> > 3. INSERT INTO [appropriate table] (FieldName)
> > VALUES("c:\NewFolder\FileName.ext");- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks for pointing me in the rigt direction. I'll give it a go- Hide quoted text -
>
> - Show quoted text -

Am I right in thinking, that I need to create an 'Add File' command
button to open the dialogue box, the user then selects the file.

Then i would need another command to 'copy and save' and in the 'on
click' event I would put the 'FileCopy' and 'Insert Into' as set out
above.

If so, i must be doing it wrong.

Thanks for the help guys

Re: Call the standard Windows File Open/Save dialog box

> Am I right in thinking, that I need to create an 'Add File' command
> button to open the dialogue box, the user then selects the file.
>
> Then i would need another command to 'copy and save' and in the 'on
> click' event I would put the 'FileCopy' and 'Insert Into' as set out
> above.
>
> If so, i must be doing it wrong.
>
> Thanks for the help guys

Personally I'd do the whole thing from the 'Add File' button's click event.
If you need further help, you'd better post your code..

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:8e409b60-c942-488a-b987-6750a833b4b1@r31g2000hsg.google groups.com...
> On 27 Nov, 12:46, "Keith Wilby" wrote:
>> wrote in message
>>
>>
>> I'm not sure why you think that users won't be albe to browse anywhere
>> they
>> like using this, you're getting into file permissions territory there
>> which
>> is nothing to do with Access.
>>
>> Keith.www.keithwilby.com
>
> Thanks ken,

Who?

>
> I'm not talking about permissions, i just don't want users to be aware
> of where all external files are stored and i certainly don't want the
> actual folders displayed. I just want them to be able to add files to
> the underlying folders programatically, which has everything to do
> with access.

What a superb way to ingratiate yourself with someone trying to help.

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:
> On 27 Nov, 12:57, redpears...@hotmail.com wrote:
>
>>On 27 Nov, 12:35, "Stuart McCall" wrote:
>>
>>
>>
>>
>>
>>
>>> wrote in message
>>
>>>news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.goo glegroups.com...
>>
>>>>Hi,
>>
>>>>I've been looking at the above API, which does indeed bring up the
>>>>OpenFile dialogue and place it into an unbound text box, but i am
>>>>having so much trouble getting it to work for my purposes. My Db has
>>>>tables that link to external images/documents and so i want a user to
>>>>be able to add new items to those via a form.
>>
>>>>I want the following to happen:-
>>
>>>>1. user selects a file via the openFile dialoge [done]
>>>>2. the file selected is 'copied' and placed into a specific folder
>>>>3. The new file path is placed into the appropriate table, and saved
>>
>>>>This is the only way i can think of to get around the problem of
>>>>external files where you need to have the paths stored in the database
>>>>and the actual files accessible. I do not want the user to be able to
>>>>link from anywhere/path they like, nor should they be able to get into
>>>>the folders which store these 'master' files.
>>
>>>>This API seems like the ideal way to do this, but i've been
>>>>experimenting for a long time now and can't find a way to do items 2 &
>>>>3 above.
>>
>>>>Any advance would be really appreciated.
>>
>>>2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"
>>
>>>3. INSERT INTO [appropriate table] (FieldName)
>>>VALUES("c:\NewFolder\FileName.ext");- Hide quoted text -
>>
>>>- Show quoted text -
>>
>>Thanks for pointing me in the rigt direction. I'll give it a go- Hide quoted text -
>>
>>- Show quoted text -
>
>
> Am I right in thinking, that I need to create an 'Add File' command
> button to open the dialogue box, the user then selects the file.
>
> Then i would need another command to 'copy and save' and in the 'on
> click' event I would put the 'FileCopy' and 'Insert Into' as set out
> above.
>
> If so, i must be doing it wrong.
>
> Thanks for the help guys

Code under a command button can execute multiple statements.

'create a filter if you want. (using code from mvps.org/access)
strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mdb)", "*.mdb")
'call the fileopen dialog
strFile = GetOpenFile(strFilter:=strFilter)

If strFile > "" Then
'if canceled, strFile would be "". If a file selected continue
strNewLocation = "C:\Test\Test.mdb"
FileCopy strFile, strNewLocation
Insert Into...
msgbox "Record copied and added"
Else
msgbox "Operation canceled."
Endif

Re: Call the standard Windows File Open/Save dialog box

On 27 Nov, 14:35, Salad wrote:
> redpears...@hotmail.com wrote:
> > On 27 Nov, 12:57, redpears...@hotmail.com wrote:
>
> >>On 27 Nov, 12:35, "Stuart McCall" wrote:
>
> >>> wrote in message
>
> >>>news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.goo glegroups.com...
>
> >>>>Hi,
>
> >>>>I've been looking at the above API, which does indeed bring up the
> >>>>OpenFile dialogue and place it into an unbound text box, but i am
> >>>>having so much trouble getting it to work for my purposes. My Db has
> >>>>tables that link to external images/documents and so i want a user to
> >>>>be able to add new items to those via a form.
>
> >>>>I want the following to happen:-
>
> >>>>1. user selects a file via the openFile dialoge [done]
> >>>>2. the file selected is 'copied' and placed into a specific folder
> >>>>3. The new file path is placed into the appropriate table, and saved
>
> >>>>This is the only way i can think of to get around the problem of
> >>>>external files where you need to have the paths stored in the database
> >>>>and the actual files accessible. I do not want the user to be able to
> >>>>link from anywhere/path they like, nor should they be able to get into
> >>>>the folders which store these 'master' files.
>
> >>>>This API seems like the ideal way to do this, but i've been
> >>>>experimenting for a long time now and can't find a way to do items 2 &
> >>>>3 above.
>
> >>>>Any advance would be really appreciated.
>
> >>>2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"
>
> >>>3. INSERT INTO [appropriate table] (FieldName)
> >>>VALUES("c:\NewFolder\FileName.ext");- Hide quoted text -
>
> >>>- Show quoted text -
>
> >>Thanks for pointing me in the rigt direction. I'll give it a go- Hide quoted text -
>
> >>- Show quoted text -
>
> > Am I right in thinking, that I need to create an 'Add File' command
> > button to open the dialogue box, the user then selects the file.
>
> > Then i would need another command to 'copy and save' and in the 'on
> > click' event I would put the 'FileCopy' and 'Insert Into' as set out
> > above.
>
> > If so, i must be doing it wrong.
>
> > Thanks for the help guys
>
> Code under a command button can execute multiple statements.
>
> 'create a filter if you want. (using code from mvps.org/access)
> strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mdb)", "*.mdb")
> 'call the fileopen dialog
> strFile = GetOpenFile(strFilter:=strFilter)
>
> If strFile > "" Then
> 'if canceled, strFile would be "". If a file selected continue
> strNewLocation = "C:\Test\Test.mdb"
> FileCopy strFile, strNewLocation
> Insert Into...
> msgbox "Record copied and added"
> Else
> msgbox "Operation canceled."
> Endif- Hide quoted text -
>
> - Show quoted text -


I'm now up and running. You've saved me hours of valuable time and i
can't thank you enough.

Though i would say to Ken two things, don't post responses off topic,
it is so disheartening to have someone respond with something that has
nothing to do with the question posed (even if the intention is good),
and certainly don't post a reply if you happen to get out of bed the
wrong side :)

Thanks again for your help guys.

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:

> On 27 Nov, 14:35, Salad wrote:
>
>>redpears...@hotmail.com wrote:
>>
>>>On 27 Nov, 12:57, redpears...@hotmail.com wrote:
>>
>>>>On 27 Nov, 12:35, "Stuart McCall" wrote:
>>
>>>>> wrote in message
>>
>>>>>news:4210080a-ccfd-4884-aa04-2bc92eb62e78@j20g2000hsi.g ooglegroups.com...
>>
>>>>>>Hi,
>>
>>>>>>I've been looking at the above API, which does indeed bring up the
>>>>>>OpenFile dialogue and place it into an unbound text box, but i am
>>>>>>having so much trouble getting it to work for my purposes. My Db has
>>>>>>tables that link to external images/documents and so i want a user to
>>>>>>be able to add new items to those via a form.
>>
>>>>>>I want the following to happen:-
>>
>>>>>>1. user selects a file via the openFile dialoge [done]
>>>>>>2. the file selected is 'copied' and placed into a specific folder
>>>>>>3. The new file path is placed into the appropriate table, and saved
>>
>>>>>>This is the only way i can think of to get around the problem of
>>>>>>external files where you need to have the paths stored in the database
>>>>>>and the actual files accessible. I do not want the user to be able to
>>>>>>link from anywhere/path they like, nor should they be able to get into
>>>>>>the folders which store these 'master' files.
>>
>>>>>>This API seems like the ideal way to do this, but i've been
>>>>>>experimenting for a long time now and can't find a way to do items 2 &
>>>>>>3 above.
>>
>>>>>>Any advance would be really appreciated.
>>
>>>>>2. FileCopy "c:\OldFolder\FileName.ext", "c:\NewFolder\FileName.ext"
>>
>>>>>3. INSERT INTO [appropriate table] (FieldName)
>>>>>VALUES("c:\NewFolder\FileName.ext");- Hide quoted text -
>>
>>>>>- Show quoted text -
>>
>>>>Thanks for pointing me in the rigt direction. I'll give it a go- Hide quoted text -
>>
>>>>- Show quoted text -
>>
>>>Am I right in thinking, that I need to create an 'Add File' command
>>>button to open the dialogue box, the user then selects the file.
>>
>>>Then i would need another command to 'copy and save' and in the 'on
>>>click' event I would put the 'FileCopy' and 'Insert Into' as set out
>>>above.
>>
>>>If so, i must be doing it wrong.
>>
>>>Thanks for the help guys
>>
>>Code under a command button can execute multiple statements.
>>
>>'create a filter if you want. (using code from mvps.org/access)
>>strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mdb)", "*.mdb")
>>'call the fileopen dialog
>>strFile = GetOpenFile(strFilter:=strFilter)
>>
>>If strFile > "" Then
>> 'if canceled, strFile would be "". If a file selected continue
>> strNewLocation = "C:\Test\Test.mdb"
>> FileCopy strFile, strNewLocation
>> Insert Into...
>> msgbox "Record copied and added"
>>Else
>> msgbox "Operation canceled."
>>Endif- Hide quoted text -
>>
>>- Show quoted text -
>
>
>
> I'm now up and running. You've saved me hours of valuable time and i
> can't thank you enough.
>
> Though i would say to Ken two things, don't post responses off topic,
> it is so disheartening to have someone respond with something that has
> nothing to do with the question posed (even if the intention is good),
> and certainly don't post a reply if you happen to get out of bed the
> wrong side :)
>
> Thanks again for your help guys.
>

If you get a bit down and out...it's all right.
http://www.youtube.com/watch?v=ewWyW6lT1HE

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:
>
> Though i would say to Ken two things, don't post responses off topic,
> it is so disheartening to have someone respond with something that has
> nothing to do with the question posed (even if the intention is good),
> and certainly don't post a reply if you happen to get out of bed the
> wrong side :)
>

You must either be incredibly stupid or pig ignorant because there is
nothing off-topic about the response posted by KEITH (NOT Ken). I also
notice that the same respondent has attempted to help you on previous
occasions, one response in particular contained some useful code, and
you haven't even bothered your arse to post a polite "thank you".
Physician, heal thyself.

Re: Call the standard Windows File Open/Save dialog box

On 27 Nov, 18:43, Gerry Hatrick wrote:
> redpears...@hotmail.com wrote:
>
> > Though i would say to Ken two things, don't post responses off topic,
> > it is so disheartening to have someone respond with something that has
> > nothing to do with the question posed (even if the intention is good),
> > and certainly don't post a reply if you happen to get out of bed the
> > wrong side :)
>
> You must either be incredibly stupid or pig ignorant because there is
> nothing off-topic about the response posted by KEITH (NOT Ken). I also
> notice that the same respondent has attempted to help you on previous
> occasions, one response in particular contained some useful code, and
> you haven't even bothered your arse to post a polite "thank you".
> Physician, heal thyself.


Gerry,

Keith (yes i know its not ken, very annoying when people post a reply
without taking into account what has actually been written, isn't it)

I am always grateful when people help me along, and I always say so.
If Keith hasn't had a thank you, its simply because he hasn't helped
me.

Please bear in mind that when people post a question they have
considered it very carefully, and when a response comes back that
'misses' the point, and is mildly bad mannered its very dissapointing,
and it just wastes everyones time.

I don't consider my initial response to be rude, in fact i think
Keith's was incredibly condescending. I asked three specific questions
that i needed help with and he replied with something that was
completely 'OFF THE TOPIC' of those specific questions, and told he me
it was 'nothing to do with access'. I thanked him for his reply and
simply said his reply was not what i was looking for and that the
questions i raised were to do with access.

So to close this thread, I would emplore to everyone out there when
considering responding to posts think very carefully about if you are
experienced enough to do so, if you have indeed understood and
answered the question given, and the old addage must be if you don't
have anything good or useful to say, don't say anything at all.

Thank you and goodnight.






if you've really got nothing better to do than get involved in others

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:644b85b9-47f8-493e-bf2a-555bb08367f3@g30g2000hsb.google groups.com...
>
> I asked three specific questions
> that i needed help with and he replied with something that was
> completely 'OFF THE TOPIC' of those specific questions, and told he me
> it was 'nothing to do with access'.

OK I wasn't going to bite but please do use your expertise to explain to me
what was "off topic" about my response. I have used the dialog box method
in many applications and am familiar with it, more so than you evidently.

I stated that you could already achieve items 1 and 3 from your list.
Accurate? Yes. Off topic? Nope.

I then addressed the following point:

"I do not want the user to be able to link from anywhere/path they like, nor
should they be able to get into the folders which store these 'master'
files."

by stating that there is nothing to stop users from browsing anywhere they
like (within the constraints of their folder permissions) using this method.
Still on topic I think.

I further stated that, to restrict where users can and cannot browse to,
you'd need to invoke file permissions, which I STATED was off topic (ie
nothing to do with Access). It was an accurate and useful response and if
you think that the dialog box method will restrict users' browsing then you
are mistaken.

>
> if you don't
> have anything good or useful to say, don't say anything at all.
>
As Gerry stated, "physician, heal thyself".

Re: Call the standard Windows File Open/Save dialog box

On 28 Nov, 11:58, "Keith Wilby" wrote:
> wrote in message
>
> news:644b85b9-47f8-493e-bf2a-555bb08367f3@g30g2000hsb.google groups.com...
>
>
>
> > I asked three specific questions
> > that i needed help with and he replied with something that was
> > completely 'OFF THE TOPIC' of those specific questions, and told he me
> > it was 'nothing to do with access'.
>
> OK I wasn't going to bite but please do use your expertise to explain to me
> what was "off topic" about my response. I have used the dialog box method
> in many applications and am familiar with it, more so than you evidently.
>
> I stated that you could already achieve items 1 and 3 from your list.
> Accurate? Yes. Off topic? Nope.
>
> I then addressed the following point:
>
> "I do not want the user to be able to link from anywhere/path they like, nor
> should they be able to get into the folders which store these 'master'
> files."
>
> by stating that there is nothing to stop users from browsing anywhere they
> like (within the constraints of their folder permissions) using this method.
> Still on topic I think.
>
> I further stated that, to restrict where users can and cannot browse to,
> you'd need to invoke file permissions, which I STATED was off topic (ie
> nothing to do with Access). It was an accurate and useful response and if
> you think that the dialog box method will restrict users' browsing then you
> are mistaken.
>
>
>
> > if you don't
> > have anything good or useful to say, don't say anything at all.
>
> As Gerry stated, "physician, heal thyself".

Keith, lets not fall out about this! :)

I made very clear the things i was requesting help on, how to call the
file/save dialogue box and how to save the file selection to a table
and folder.

At the stage i posted I was not concerned about restricting users
browsing. I'm still not. I only set up the scenario of the brief i
have, that is if adding images/documents to a database those files
need to be placed into an underlying folder (for storage retrieval in
the database) via a form. I'm aware that there is a point in time
where i will have to consider permissions for those folders, but thats
not where i am at, and as we all know when working on databases you
have to take things one step at a time.

the step i am at is calling the file/save dialogue box and how to save
the selection to a table and folder. Therefore, giving snide remarks
about other aspects of my application is off topic, its off the topic
i raised and its downright rude. i.e. to respond to me with 'why do
you think that users won't be albe to browse anywhere they like using
this....' is not helpful at all, and i really don't appreciate it.
How about simply stating in your response "that permissions may have
to be considered for those folders, but to answer your main
questions....." instead of giving a half arsed, arsy response.

It's really bad form to skip the actual question asked and this seems
to a major problem with many developers i work with that they ignore
or do not feel obliged to ask what the priority is from the clients
point of view, and then frustrate matters by answering a different
problem. No wonder some have a dodgy reputation.

and on the contrary i think what's being said here is useful, perhaps
its a lesson that some need to think before typing.

No further discussion will be entered into here. I don't have the time
to waste.

'l'll just simply say thanks to those who did really help me i really
do appreciate it.

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:e7ea5acf-1756-4ddf-9b7a-0b2eba1d4d53@n20g2000hsh.google groups.com...
> On 28 Nov, 11:58, "Keith Wilby" wrote:
>
> Therefore, giving snide remarks
> about other aspects of my application is off topic, its off the topic
> i raised and its downright rude. i.e. to respond to me with 'why do
> you think that users won't be albe to browse anywhere they like using
> this....' is not helpful at all, and i really don't appreciate it.
> How about simply stating in your response

How about quoting what I actually wrote which was "I'm not sure why you
think ..." instead of what you *think* I wrote. I was trying to invoke a
thought process, I wasn't trying to make you cry.

>
> It's really bad form to skip the actual question asked and this seems

It's even worse form to mis-quote someone and then attempt to berate them
for it. The more you write, the bigger the fool you appear to be, so it's
perhaps very wise of you not to indulge further.

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:
> On 28 Nov, 11:58, "Keith Wilby" wrote:
>

Let's review.

You, not once, but TWICE referred to Keith by the wrong name and you
implied that this was because you did not read his post correctly, hence
your mistake ("yes i know its not ken, very annoying when people post a
reply without taking into account what has actually been written").

You, not once, but TWICE claimed that Keith's response was "off-topic"
when it clearly was not. Can you see a trend here? YOU are the common
denominator because YOU didn't read and comprehend his response
correctly. You didn't see exactly what you wanted to see so you tried
to deflect your own inability to inwardly digest some good information
onto someone else.

You claimed that Keith's response was "incredibly condescending". I
thought it was factual and accurate, if a little brusque but, here's a
tip that I always stand by when using newsgroups:

*Always* have the courtesy of giving others the benefit of the doubt
when it comes to YOUR INTERPRETATION of what they have written. Just
consider the possibility that it might, just might be YOU who is
interpreting the posting wrongly. Only if subsequent postings becomes
plainly rude do you have cause for complaint.

If you think that Keith's response was rude then you'd better prepare
yourself for a bumpy ride in here, I have read *much* worse. Perhaps
also you should lead by example because you have been *extremely* rude
to Keith today. Could that be because you're plain WRONG?

At the end of the day, Keith was trying to help you. Like everyone else
on here, he offered his help free of charge and in good faith and you
slammed the door in his face just because you found his tone not to your
liking and you didn't really understand what he was saying. You've even
mis-quoted him in an attempt to bolster you quite pathetic argument.
Better put on the big boy pants if you want to play with the grown-ups
matey.

By the way, you carelessly left "if you've really got nothing better to
do than get involved in others" at the bottom of your post. That was a
bit of a giveaway wasn't it? Like Keith said, the more you write, the
bigger the fool you appear to be, and boy do you look a fool.

Re: Call the standard Windows File Open/Save dialog box

On 28 Nov, 17:42, Gerry Hatrick wrote:
> redpears...@hotmail.com wrote:
> > On 28 Nov, 11:58, "Keith Wilby" wrote:
>
> Let's review.
>
> You, not once, but TWICE referred to Keith by the wrong name and you
> implied that this was because you did not read his post correctly, hence
> your mistake ("yes i know its not ken, very annoying when people post a
> reply without taking into account what has actually been written").
>
> You, not once, but TWICE claimed that Keith's response was "off-topic"
> when it clearly was not. Can you see a trend here? YOU are the common
> denominator because YOU didn't read and comprehend his response
> correctly. You didn't see exactly what you wanted to see so you tried
> to deflect your own inability to inwardly digest some good information
> onto someone else.
>
> You claimed that Keith's response was "incredibly condescending". I
> thought it was factual and accurate, if a little brusque but, here's a
> tip that I always stand by when using newsgroups:
>
> *Always* have the courtesy of giving others the benefit of the doubt
> when it comes to YOUR INTERPRETATION of what they have written. Just
> consider the possibility that it might, just might be YOU who is
> interpreting the posting wrongly. Only if subsequent postings becomes
> plainly rude do you have cause for complaint.
>
> If you think that Keith's response was rude then you'd better prepare
> yourself for a bumpy ride in here, I have read *much* worse. Perhaps
> also you should lead by example because you have been *extremely* rude
> to Keith today. Could that be because you're plain WRONG?
>
> At the end of the day, Keith was trying to help you. Like everyone else
> on here, he offered his help free of charge and in good faith and you
> slammed the door in his face just because you found his tone not to your
> liking and you didn't really understand what he was saying. You've even
> mis-quoted him in an attempt to bolster you quite pathetic argument.
> Better put on the big boy pants if you want to play with the grown-ups
> matey.
>
> By the way, you carelessly left "if you've really got nothing better to
> do than get involved in others" at the bottom of your post. That was a
> bit of a giveaway wasn't it? Like Keith said, the more you write, the
> bigger the fool you appear to be, and boy do you look a fool.

How can you misquote when you do a copy and paste!
*****Sighhhhh*******

Ok Kids, time to go in for your nap, you're overtired and cranky and
you've obviously got nothing better to do with your lives

I wish you well.

Re: Call the standard Windows File Open/Save dialog box

schreef in bericht =
news:e53d2c14-d27a-4c3d-a32c-fedad220a9e6@n20g2000hsh.google groups.com...=

> On 28 Nov, 17:42, Gerry Hatrick wrote:
>> redpears...@hotmail.com wrote:
>> > On 28 Nov, 11:58, "Keith Wilby" wrote:
>>
>> Let's review.
>>
>> You, not once, but TWICE referred to Keith by the wrong name and you
>> implied that this was because you did not read his post correctly, =
hence
>> your mistake ("yes i know its not ken, very annoying when people post =
a
>> reply without taking into account what has actually been written").
>>
>> You, not once, but TWICE claimed that Keith's response was =
"off-topic"
>> when it clearly was not. Can you see a trend here? YOU are the =
common
>> denominator because YOU didn't read and comprehend his response
>> correctly. You didn't see exactly what you wanted to see so you =
tried
>> to deflect your own inability to inwardly digest some good =
information
>> onto someone else.
>>
>> You claimed that Keith's response was "incredibly condescending". I
>> thought it was factual and accurate, if a little brusque but, here's =
a
>> tip that I always stand by when using newsgroups:
>>
>> *Always* have the courtesy of giving others the benefit of the doubt
>> when it comes to YOUR INTERPRETATION of what they have written. Just
>> consider the possibility that it might, just might be YOU who is
>> interpreting the posting wrongly. Only if subsequent postings =
becomes
>> plainly rude do you have cause for complaint.
>>
>> If you think that Keith's response was rude then you'd better prepare
>> yourself for a bumpy ride in here, I have read *much* worse. =
Perhaps
>> also you should lead by example because you have been *extremely* =
rude
>> to Keith today. Could that be because you're plain WRONG?
>>
>> At the end of the day, Keith was trying to help you. Like everyone =
else
>> on here, he offered his help free of charge and in good faith and you
>> slammed the door in his face just because you found his tone not to =
your
>> liking and you didn't really understand what he was saying. You've =
even
>> mis-quoted him in an attempt to bolster you quite pathetic argument.
>> Better put on the big boy pants if you want to play with the =
grown-ups
>> matey.
>>
>> By the way, you carelessly left "if you've really got nothing better =
to
>> do than get involved in others" at the bottom of your post. That was =
a
>> bit of a giveaway wasn't it? Like Keith said, the more you write, =
the
>> bigger the fool you appear to be, and boy do you look a fool.
>=20
> How can you misquote when you do a copy and paste!
> *****Sighhhhh*******
>=20
> Ok Kids, time to go in for your nap, you're overtired and cranky and
> you've obviously got nothing better to do with your lives
>=20
> I wish you well.


IMO it is time to reconsider your use of Usenet ...
*****Sighhhhh******* =20


Arno R

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:

>
> Ok Kids, time to go in for your nap, you're overtired and cranky and
> you've obviously got nothing better to do with your lives
>
> I wish you well.

Usenet is not a place for someone as sensitive and thin skinned as
yourself. You need to put your little feelings in a box when you
go looking for help from total strangers.

Re: Call the standard Windows File Open/Save dialog box

redpears007@hotmail.com wrote:
>
>
> How can you misquote when you do a copy and paste!

You can't. You obviously haven't mastered the copy and paste technique yet.

Re: Call the standard Windows File Open/Save dialog box

Arno R wrote:
>
>
> IMO it is time to reconsider your use of Usenet ...
> *****Sighhhhh*******
>
>
> Arno R

You see what you did there redpears007@hotmail.com? You got yourself
into Arno's killfile. Arno is a respected resource on this forum. I
wonder how many others have silently KF'd you. Well done you.

Re: Call the standard Windows File Open/Save dialog box

On 28 Nov, 19:35, Gerry Hatrick wrote:
> Arno R wrote:
>
> > IMO it is time to reconsider your use of Usenet ...
> > *****Sighhhhh*******
> >
>
> > Arno R
>
> You see what you did there redpears...@hotmail.com? You got yourself
> into Arno's killfile. Arno is a respected resource on this forum. I
> wonder how many others have silently KF'd you. Well done you.

****Boooo Hooooo****** Gerry's gone and told me not to post anymore
cos no one will help me ****booo friggin hoooo*****

Like i care what Gerry, got no life so jumps into other's threads to
cause havok, Hatrick thinks. From the way you have conducted yourself
mate, your minute analysis of this thread, who said what & when, is
not only incredibly dull and childish, its seriously bordering on
Freakish, please get yourself a life before someone gets hurt!

From the amount of agro and non help given in this thread, theres no
way i'm ever using Usenet again.

Ta ta, ****wits

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:679ddf9e-c4c2-4d9e-b7fb-f7b4a1986e22@l1g2000hsa.googleg roups.com...
>
> Gerry's gone and told me not to post anymore

Yet another mis-quote. No, a downright lie.

>
> theres no
> way i'm ever using Usenet again.

We all sincerely thank you for that.

Re: Call the standard Windows File Open/Save dialog box

On 29 Nov, 09:06, "Keith Wilby" wrote:
> wrote in message
>
> news:679ddf9e-c4c2-4d9e-b7fb-f7b4a1986e22@l1g2000hsa.googleg roups.com...
>
>
>
> > Gerry's gone and told me not to post anymore
>
> Yet another mis-quote. No, a downright lie.
>
>
>
> > theres no
> > way i'm ever using Usenet again.
>
> We all sincerely thank you for that.

Hi Guys,

I've just dropped into this thread thinking it may be able to help me
as i am stuck on the same problem as Red and I am shocked at what has
been going on in this thread, and feel i must say something about it.

What was initally a polite exchange between Keith and Red has been
blown out of all proportion by the uncessary intervention of Gerry who
has turned the whole thread into what i can only describe as a 'cyber
bully' attack against Red.

As someone who often uses Usenet for solutions to Access problems, i
do somewhat share Reds frustration in that sometimes responses come
back that don't help us on any further, and Keiths first response did,
on first read, come across as very short and somewhat unhelpful (i.e
no pointers to actually resolve the issues 2 & 3). Red came back to
him and said that permissions were not what they were looking at, and
since then Gerry has proceeded to bully Red, although they have had a
good go at defending themselves, right out of Usenet.

Perhaps its a symptom of some letting their aggression out via the
veiled internet, but I am really disgusted at the battering being
given out here, and the perpertrator should be ashamed of themselves.
Is this not a help forum, where was the taking a step back and saying
'sorry how can i actually help'.

To that effect i have reported this thread to Usenet as an example of
Usenet Abuse. I have also suggested that Gerry's account here should
be reviewed.

Users should not be abused as a result of saying that they found a
response unhelpful, and others should not have to witness should
digusting behaviour from others when searching their own solutions.

I hope Usenet will take the necessary action against those involved

Re: Call the standard Windows File Open/Save dialog box

wrote in message
news:1a336881-a0e8-441f-a675-c5d849079eb6@g30g2000hsb.google groups.com...
>
> I've just dropped into this thread thinking it may be able to help me
> as i am stuck on the same problem as Red and I am shocked at what has
> been going on in this thread, and feel i must say something about it.

Is it significant that Red's last message and yours share the same IP
address?

> blown out of all proportion by the uncessary intervention of Gerry who
> has turned the whole thread into what i can only describe as a 'cyber
> bully' attack against Red.

Could you site a specific example of bullying by anyone in this thread? I
see none.

>
> As someone who often uses Usenet for solutions to Access problems,

Really? My search on "T.C.Smythe@jubii.co.uk" reveals no other postings.
Do you use another alias?

> i
> do somewhat share Reds frustration in that sometimes responses come
> back that don't help us on any further, and Keiths first response did,
> on first read, come across as very short and somewhat unhelpful (i.e
> no pointers to actually resolve the issues 2 & 3).

I've already stated that points 1 and 3 were already achievable but I really
can't be bothered with this anymore, especially since you and Red share an
IP address, you're hardly impartial are you?

>
> To that effect i have reported this thread to Usenet as an example of
> Usenet Abuse. I have also suggested that Gerry's account here should
> be reviewed.

You'd need a torrent of abuse claims from many sources before any such
action would be taken. Again, I see no examples of abuse or bullying
towards your colleague but feel free to prove me wrong.

Re: Call the standard Windows File Open/Save dialog box

schreef in bericht =
news:1a336881-a0e8-441f-a675-c5d849079eb6@g30g2000hsb.google groups.com...=

=20
> I've just dropped into this thread thinking it may be able to help me
> as i am stuck on the same problem as Red and I am shocked at what has
> been going on in this thread, and feel i must say something about it.

I bet you are just the same guy as 'Red'.
Same IP, same User Agent, same PC, same clothes ??
=20
> To that effect i have reported this thread to Usenet as an example of
> Usenet Abuse. I have also suggested that Gerry's account here should
> be reviewed.

Nonsense.

> I hope Usenet will take the necessary action against those involved

You surely don't know much about how Usenet works ...

Arno R

Re: Call the standard Windows File Open/Save dialog box

T.C.Smythe@jubii.co.uk wrote:
>
> I've just dropped into this thread thinking it may be able to help me
> as i am stuck on the same problem as Red

In my 15+ years of lurking here I have *never* encountered "Red's"
issue, so the chances of two people having it simultaneously must be
minute. But then, you've already been busted by Keith and Arno, right?
>
> To that effect i have reported this thread to Usenet as an example of
> Usenet Abuse. I have also suggested that Gerry's account here should
> be reviewed.

Fill yer boots if it gives you a sense of being a real man.

>
> Users should not be abused as a result of saying that they found a
> response unhelpful, and others should not have to witness should
> digusting behaviour from others when searching their own solutions.
>
> I hope Usenet will take the necessary action against those involved

Time to grow a pair Bub, and I don't mean a pair of identical IP addresses.

Re: Call the standard Windows File Open/Save dialog box

T.C.Smythe@jubii.co.uk wrote:

>To that effect i have reported this thread to Usenet as an example of
>Usenet Abuse. I have also suggested that Gerry's account here should
>be reviewed.

Umm Usenet newsgroups don't work that way. And clearly you don't understand how NNTP
newsgroups work.

You can complain to the posters ISP but that's about it.

There may very well be a company called Usenet but they do *not* control the Usenet
newsgroups.

As Keith points out, how is it that you and Red have the same IP address?

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Call the standard Windows File Open/Save dialog box

"Gerry Hatrick" wrote in message
news:64WdnWnYctt8i9LaRVnyvwA@bt.com...
>
> But then, you've already been busted by Keith and Arno, right?

Seems the embarrassment was just too much for "them". :-)