Hyperlinks, VB, and Access
-
Hello all, I have an Access 2000 database. On a table called "Images" I have a field called "Link to Images." This field is hyperlink to some imgae files I have. The hyperlink name is generated based on an ID number given to them as they are entered to the database (the number increases sequentially). I made a program that will take the ID number of it and create the appropriate hyperlink name. The problem is though, it doesn't create an actual hyperlink. The field gets changed to what I want, but it is not an ACTUAL hyperlink to the file. Is there a way to write a program that will automatically create the hyperlink? I don't want to sit and manually type the name of 900+ images into my database. Nickone nickmthughes@hotmail.com (just in case you have a question)
-
Hello all, I have an Access 2000 database. On a table called "Images" I have a field called "Link to Images." This field is hyperlink to some imgae files I have. The hyperlink name is generated based on an ID number given to them as they are entered to the database (the number increases sequentially). I made a program that will take the ID number of it and create the appropriate hyperlink name. The problem is though, it doesn't create an actual hyperlink. The field gets changed to what I want, but it is not an ACTUAL hyperlink to the file. Is there a way to write a program that will automatically create the hyperlink? I don't want to sit and manually type the name of 900+ images into my database. Nickone nickmthughes@hotmail.com (just in case you have a question)
Anonymous wrote: The field gets changed to what I want, but it is not an ACTUAL hyperlink to the file. What do you mean by this? What makes it not be an actual hyperlink? The fact that it isn't clickable? If so, all you have to do is change the data type to hyperlink in the table's design view.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma Gandhi -
Anonymous wrote: The field gets changed to what I want, but it is not an ACTUAL hyperlink to the file. What do you mean by this? What makes it not be an actual hyperlink? The fact that it isn't clickable? If so, all you have to do is change the data type to hyperlink in the table's design view.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma GandhiSorry maybe I wasn't clear. I wrote a Standard EXE VB program that connects to my database. In the Database, I have a field that are hyperlinks. Thus if I open the table, and click on the hyperlink, it opens the image. So let's say I open my Table, and run the code, then I can see the hyperlink name change to what I want. My problem exists where when I go back and click on the link, nothing happens. So I right clicked on the hyperlink in the Table and looked at the Hyperlink properties. The "Text to Display" has been changed by my program, but the hyperlink itself is blank. Basically the hyperlink is there, but it no longer actually links to anything. If I go through and reenter the hyperlink manually this way, it defeats the purpose of my program. Any ideas? It'd be really great if I could get this to work. Thanks Nick nickmthughes@hotmail.com
-
Sorry maybe I wasn't clear. I wrote a Standard EXE VB program that connects to my database. In the Database, I have a field that are hyperlinks. Thus if I open the table, and click on the hyperlink, it opens the image. So let's say I open my Table, and run the code, then I can see the hyperlink name change to what I want. My problem exists where when I go back and click on the link, nothing happens. So I right clicked on the hyperlink in the Table and looked at the Hyperlink properties. The "Text to Display" has been changed by my program, but the hyperlink itself is blank. Basically the hyperlink is there, but it no longer actually links to anything. If I go through and reenter the hyperlink manually this way, it defeats the purpose of my program. Any ideas? It'd be really great if I could get this to work. Thanks Nick nickmthughes@hotmail.com