By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Multiple change text

P: n/a
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.doc
010005 i:\document2.doc
010005 i:\document3.xls

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

Thanx
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
In an Update Query try using in the Update To area on the applicable
field...

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

Mike Storr
www.veraccess.com
"Rob" <he******@naco.nl> wrote in message
news:11**************************@posting.google.c om...
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.doc
010005 i:\document2.doc
010005 i:\document3.xls

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

Thanx

Nov 12 '05 #2

P: n/a
he******@naco.nl (Rob) wrote in message news:<11**************************@posting.google. com>...
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.doc
010005 i:\document2.doc
010005 i:\document3.xls

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

Thanx


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$(FileLocation,Len$(FileLocation)-1)
WHERE ... (include your filter here...);
Nov 12 '05 #3

P: n/a
Rob
Thanx, it's working.

Rob
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf************************@posting.google.co m>...
he******@naco.nl (Rob) wrote in message news:<11**************************@posting.google. com>...
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.doc
010005 i:\document2.doc
010005 i:\document3.xls

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

Thanx


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$(FileLocation,Len$(FileLocation)-1)
WHERE ... (include your filter here...);

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.