Server Changes cause Hyperlinks to be lost 1

RobotMush · Oct 27, 2004

After getting all my hyperlinks set up the server that the hyperlink was changed out. Now I am having to redo all my hyperlnks to the new server. Is there any possible shortcut or program that will make this easier? I have 554 records at present I am needing to update, and the next time this is done (I'm told in about 3 years) I may have 20,000 + records to deal with.
Any help on this will be greatly appreciated

RobotMush (Technical User)

PHV · Oct 27, 2004

Take a look at the Application.HyperlinkPart method and at the Replace function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

RobotMush · Oct 28, 2004

Thank you PHV for your suggestion. However, I'm not sure where I would be able to look for the Application.HyperlinkPart Method. I tried the Help (F1) and entered Application.HyperlinkPart Method, Hyperlink, Application, Method. And found nothing that was of help. Am I looking in the right place?
Thank you for your help in this.

RobotMush (Technical User)

PHV · Oct 29, 2004

While in VBE (F11) open the Object Browser window (F2), search it for hyperlinkpart and the play with the F1 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

randy700 · Oct 29, 2004

Can't you just do a Find/Replace on the hyperlink field?

Randy

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Server Changes cause Hyperlinks to be lost 1

RobotMush

Technical User

PHV

MIS

RobotMush

Technical User

PHV

MIS

randy700

Programmer

Similar threads

Part and Inventory Search

Sponsor