Hi all. Just when I thought I was finished I realized that my table, in the hyperlink field, doesn't have the base address in each link. E.g.
I have:
040F-CY181824-MS.JPG
where it should be
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
Since I have over 2000 records I tried to use the below update query but it only updates the "text to display" field and not the acutall "Address". It's supposed to do both.
Can some1 tell me what I'm missing?
Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo] & "#" & Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo]
56 is the number of characters of the base address. If I leave 1 it only puts the " T " into the address.
Thanks!
8 1917 MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi all. Just when I thought I was finished I realized that my table, in the hyperlink field, doesn't have the base address in each link. E.g.
I have:
040F-CY181824-MS.JPG
where it should be
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
Since I have over 2000 records I tried to use the below update query but it only updates the "text to display" field and not the acutall "Address". It's supposed to do both.
Can some1 tell me what I'm missing?
Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo] & "#" & Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo]
56 is the number of characters of the base address. If I leave 1 it only puts the " T " into the address.
Thanks!
What is the full hyperlink value in the [HyperLinkField] can you give an example.
What is the full hyperlink value in the [HyperLinkField] can you give an example.
Yeah, I put it in the original post. One of the record is supposed to have:
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
But now I only have:
040F-CY181824-MS.JPG
Thanks!
MMcCarthy 14,534
Recognized Expert Moderator MVP
Yeah, I put it in the original post. One of the record is supposed to have:
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
But now I only have:
040F-CY181824-MS.JPG
Thanks!
Where does the "#" come in?
Where does the "#" come in?
From what I learned the Hyperlink is made of at least 3 fields separated by # .
The first is the "text to display" the second the acutal address.
MMcCarthy 14,534
Recognized Expert Moderator MVP
From what I learned the Hyperlink is made of at least 3 fields separated by # .
The first is the "text to display" the second the acutal address.
The problem is that the update cannot see that it can only see the displayed text.
MMcCarthy 14,534
Recognized Expert Moderator MVP
The problem is that the update cannot see that it can only see the displayed text.
If "T:\SHARED FILES\Administr ation\Masters and Molds Photos\" is the location of all of these files then - SET [Photo]="T:\SHARED FILES\Administration\Masters and Molds Photos\" & [Photo]
Should do what you want.
If "T:\SHARED FILES\Administr ation\Masters and Molds Photos\" is the location of all of these files then - SET [Photo]="T:\SHARED FILES\Administration\Masters and Molds Photos\" & [Photo]
Should do what you want.
I don't know how but it put just a ' 0 ' in the text to display and deleted the original link in the "address" field.
MMcCarthy 14,534
Recognized Expert Moderator MVP
I don't know how but it put just a ' 0 ' in the text to display and deleted the original link in the "address" field.
I don't know how either.
Did you back up the table/database?
If so try this ...
Create a new field called Photo2
Set [Photo2] = "As before"
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: just1coder |
last post by:
Is there a way to programmatically change the base href tag in a
website with JavaScript?
|
by: deko |
last post by:
I have a subform in my Access 2002 mdb that holds Hyperlinks to documents
(.pdfs) that are associated with each record in the database. The datasheet
subform is simply a list of Hyperlinks to previous invoices for each client.
The problem is that other workstations on the LAN cannot open the documents
(they can connect to the database okay).
The workstation on which the database resides (MainPC) opens the documents
without a problem,...
|
by: hermawih |
last post by:
Please help .
I want to load the contents of another rtf document by double-clicking
the words .
Chapter1.rtf
Chapter2.rtf
Chapter3.rtf
....
|
by: Steve Guidos |
last post by:
We are writing a set of Windows Services using C#.NET that will run on the
same server. One of the developers here said that we should assign each
service its own Base Address using the Properties page, so that the services
won't conflict with each other. I cannot seem to find any information about
when to set the Base Address or what its practical effect would be. My
impression is that the BaseAddress is just a "suggested" base address,...
|
by: glebur |
last post by:
Hi,
I'm trying to create a web service client in C# but I get stuck at one of
the first steps.
When adding a Web reference to the Visual Studio project; I get this error
(this is a translation, the English terms might not be exact) :
"Error in the custom tool : Impossible to import WebService/Schema.
Impossible to import binding 'cmsserverbinding' (it's the name of the binding
in my WSDL file) from namesapce 'urn:cms. Impossible to...
| |
by: Shadow Lynx |
last post by:
When using ASP.NET 2.0's built-in TreeView on a page with
<BASE target = "AnythingBut_Self"></BASE>
in the HEAD, the expand/collapse buttons fail to function. The reason
for this is that the hyperlinks generated for the expand/collapse
buttons includes javascript code that will execute in the frame
specified in the Base Target rather than the current document. To
remedy this, TreeView should render a target="_self" attribute for each...
|
by: Newish |
last post by:
Hi
Regarding DLL base address:
1) What does it mean?
2) Should it ever be changed?
3) What are the rules to change it?
|
by: =?Utf-8?B?QnJhc3NpY2FOaWdyYQ==?= |
last post by:
Greetings,
Recently I upgraded to Windows Vista Ultimate and VS2008 with SQLExpress
2008. For the last several years I have been using Windows XP SP2 and VS2005
with SQLExpress 2005. All of the applications that I have been working on
for my clients have come over beautifully with one exception.
Most of my applications make use of references that are either part of the
CLR or are COMs. One of the COM applications installs fine, I...
|
by: =?Utf-8?B?Zmplcm9uaW1v?= |
last post by:
Hi all,
As I mentioned in a previous thread (see 'Dbghelp, symbols and templates' in
microsoft.public.windbg), we created a powerful symbol engine using dbghelp
to dump the contents of the stack symbols when an exception occurs.
The engine is able to dereference and process UDT symbols up to their
highest base class. It also supports multiple inheritance. However, we are
having trouble with virtual inheritance. Documentation is very...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |