Access 2003 help!

aneater94

New Member

Join Date: Oct 2010

Posts: 1

30th Oct 2010

Hi, I've an Access 2003 table with a hyperlink field storing address to documents. I like to be able to find a specifed string value within the address path and replace it with a new value. For example for the address path c:123aba.doc. I want to find the text "3a" and change it to "9z" so that the new path is c:129zba. I've tried Access' builtin find and replace feature but this only changed the test display part of the hyperlink and not the address part. Please can anyone help me!

« WTF? Chaplin Film, circa 1928 with a Time Traveller Caught On Film | Nag, Nag, Nag... »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Executing Word 2003 Mailmerge from Access 2000 module running in Access 2003	ML	Microsoft Access VBA Modules	3	25th Oct 2006 11:25 PM
Access 2003 Won't Update Pivot Tables Created in Access 2003	=?Utf-8?B?TWljaGFuaWtlcg==?=	Microsoft Access	3	16th Oct 2006 08:25 AM
Access 2002 to Access 2003 Problem - Won't Create MDE in 2003	=?Utf-8?B?TGF0ZSBOaWdodCBDb2Rlcg==?=	Microsoft Access VBA Modules	2	29th Aug 2006 09:29 AM
Crash Access 2003 on 2nd Access 2003 Application open...	Edward	Microsoft Access	1	20th Jul 2005 12:25 PM
Migrating from Beta Edition Access 2003 to Access 2003	Joan	Microsoft Access Forms	0	28th Nov 2003 06:36 PM