Thanks for all of your responses. I have tried to keep my coding simple. Your suggestions have been helpful.
The problem was Access was returning the DisplayText data as well as the URL data on occassions.
This was solved by modifying my code from:
If rsDatabase("Hyperlink") >= "" then...
I am using the variable to create link and this is causing oddball occurence. However, the results are not consistent. Sometimes it works fine. The wrong results are when the link created results in something like this:
1. http://myserver/ocs/picture.jpg#docs/picture.jpg
instead of
2...
Here it is:
Do While Not rsDatabase.EOF
If rsDatabase("Hyperlink") >= "" then
Dim hyperlink
hyperlink = rsDatabase("Hyperlink")
hyperlink = mid(hyperlink,2,len(hyperlink)-2)
End if
Response.Write "<tr><td WIDTH=150 valign=top><font size=3>" & rsDatabase("Person") & "</font></td>"...
I am now having a problem where the hyperlink data comes in doubles. For example, if the access database has a hyperlink to "docs/picture.jpg" then the results I am getting in return are "#docs/picture.jpg#docs/picture.jpg#". Why would this be, and how do I fix it?
Incidentally, I have a...
I have an asp page which takes data from an Access database. The trouble I am having is where one field in my Access database is a "Hyperlink" field. When I display the data in an ASP page it does not create a hyperlink but displays # signs on each side of the data.
I set the asp page to...
Thanks. Despeckle definitely does not do the trick. However, the gaussian blur worked quite well, with a bit of contract/level changing, I was able to get a much better images than I currently had. I also tried sharpening it up just a bit afterwards, which got rid of a bit of the unnecessary...
I am using Adobe Photoshop Elements 2.0. I have an old document from the 60's, which I scanned in but the text looks very pixel-ly and I need to increase the quality of the page.
I have tried darkening and lightning, etc., as well as changing contrast. But it is still too pixel-ly.
I found...
Hi, I am using Outlook (2000) on Windows 2K. When I press the Send/Receive button it gives me an error.
"Could not fetch new headers in the inbox for <my computer>. An unknown error has occurred. Please save any existing work and restart the program."
Any ideas what this means...
I am trying to get the Request.ServerVariables("AUTH_USER") to work on my Intranet, however it doesn't. I assume the "auth user" data isn't being sent to the server. Any ideas how to solve that?
Thanks. With Integrated Windows Authentication on and Anonymous Access off, I was able to access the site from the server. However, from a remote computer on the network (Intranet) I wasn't. From what I understand, IIS should be recognizing the user (IWA) and then determining whether the user...
When I uncheck the "Anonymous Access" button in security section of a folder on my website, it seems to close off any access to the site and says "The page cannot be found." I kept Integrated Windows Authentication on as I am trying to gather the user data.
Does anyone...
I am trying to install PHP and for some reason I can't get both Apache and PHP to speak with each other. I am using Windows 2000. I have Apache 2.0 running and it seems fine. It seems that I have done the right PHP install steps but the apache web server does not translate the PHP. It just...
After loading Internet Explorer 6.0, there have been several instances when programs I am running or browser-detection websites won't recognize IE 6 on my computer. It acts if I don't have Internet Explorer. This is mostly in testing out samples of my Microsoft Visual Studio 6.
Why won't it...
I need some direction. I have a DAO connection to an Access database where I get data. Each field in the Access database is displayed separately in a textbox in my program. I would like to sort the main field name (called "Name") in ascending order. Currently is doesn't do this...
For Command1.Click the following works in VB 6:
Private Sub Command1_Click()
Image1.Move Image1.Left + 100
Image2.Move Image2.Left - 100
End Sub
Why doesn't the same syntax work in VBA? What is the correct way?
Thanks.
Hello, I created a simple form in MSAccess and for some reason I am getting a "Type Mismatch" error. The highlighted error is the "+" below where it says "Wins = Wins + 1." This doesn't seem right. Can someone help me out here?
Here is my VBA code:
Private Sub...
H-E-L-L-O. I am creating a program which pulls data out of an Access database. I want to use automation to search the records using the search function in Access. I don't know the correct function to use and how to say it. But I know how to set the preferences, there are just too many...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.