Multiple change text

[Rob]

Just a small problem (i hope)

I'm trying to change multiple fields in a datebase. I made a query
containing a projectnumber and a filelocation (is text, no hyperlink).
In a form you can fill in the projectnumber and with an applyfilter it
gives the following result

010005 i:\document1.do c
010005 i:\document2.do c
010005 i:\document3.xl s

The problem: How do i change in these results the i:\ to u:\??

Thanx

[Mike Storr]

Re: Multiple change text

In an Update Query try using in the Update To area on the applicable
field...

"u" & Right(fldName, Len(fldName)-1)

Mike Storr

https://www.veraccess.com

"Rob" <helleman@naco. nl> wrote in message
news:11c1cdff.0 401300200.7a54a 403@posting.goo gle.com...[color=blue]
> Just a small problem (i hope)
>
> I'm trying to change multiple fields in a datebase. I made a query
> containing a projectnumber and a filelocation (is text, no hyperlink).
> In a form you can fill in the projectnumber and with an applyfilter it
> gives the following result
>
> 010005 i:\document1.do c
> 010005 i:\document2.do c
> 010005 i:\document3.xl s
>
> The problem: How do i change in these results the i:\ to u:\??
>
> Thanx[/color]

[Pieter Linden]

Re: Multiple change text

helleman@naco.n l (Rob) wrote in message news:<11c1cdff. 0401300200.7a54 a403@posting.go ogle.com>...[color=blue]
> Just a small problem (i hope)
>
> I'm trying to change multiple fields in a datebase. I made a query
> containing a projectnumber and a filelocation (is text, no hyperlink).
> In a form you can fill in the projectnumber and with an applyfilter it
> gives the following result
>
> 010005 i:\document1.do c
> 010005 i:\document2.do c
> 010005 i:\document3.xl s
>
> The problem: How do i change in these results the i:\ to u:\??
>
> Thanx[/color]

First off, using a relative path instead of a UNC path is a bad idea,
I think. What if someone has I mapped to a CD ROM or something like
that?

UPDATE MyTable
SET FileLocation = "U" & Right$(FileLoca tion,Len$(FileL ocation)-1)
WHERE ... (include your filter here...);

[Rob]

Re: Multiple change text

Thanx, it's working.

Rob


pietlinden@hotm ail.com (Pieter Linden) wrote in message news:<bf31e41b. 0401300754.27e3 0d@posting.goog le.com>...[color=blue]
> helleman@naco.n l (Rob) wrote in message news:<11c1cdff. 0401300200.7a54 a403@posting.go ogle.com>...[color=green]
> > Just a small problem (i hope)
> >
> > I'm trying to change multiple fields in a datebase. I made a query
> > containing a projectnumber and a filelocation (is text, no hyperlink).
> > In a form you can fill in the projectnumber and with an applyfilter it
> > gives the following result
> >
> > 010005 i:\document1.do c
> > 010005 i:\document2.do c
> > 010005 i:\document3.xl s
> >
> > The problem: How do i change in these results the i:\ to u:\??
> >
> > Thanx[/color]
>
> First off, using a relative path instead of a UNC path is a bad idea,
> I think. What if someone has I mapped to a CD ROM or something like
> that?
>
> UPDATE MyTable
> SET FileLocation = "U" & Right$(FileLoca tion,Len$(FileL ocation)-1)
> WHERE ... (include your filter here...);[/color]