Command button for "Insert hyperlink"

[Patm]

On my form I have a text box which has the data type of hyperlink in the corresponding table.
I would like to create a command button to place next to the text box, so that when the command button is activated it brings up the "Insert Hyperlink" URL dialogue box. I have a number of users for this form and want them to have easy access to the "IH" box.
Also, when you do insert one hyperlink to a record, can you then continue adding multiple links in the same record?
Any help is appreciated.
Patm

 

[LQ]

Try this...
http://www.access-programmers.co.uk/ubb/Forum1/HTML/005508.html

Yes, you can insert more than one hyperlink per record, but you would need to make a separate hyperlink field for it. I don't know if putting multiple links in one field is possible, but I know it wouldn't be desirable from a design standpoint.

HTH

 

[Patm]

Thanks LQ.
My intent with the hyperlink was to create one for each picture that needs to be linked to a particular record.
This db is a phone log in regard to some technical questions involving our product. If our mfg facility wants to send us pix in regard to a certain question, I want to be able to link them to that record.
What would you recomend?

 

[LQ]

How many pics are they likely to send you per record? If there was a max of one or two, I would just make two separate hyperlink fields in your table. If there are unlimited numbers of images per record, then I guess I would make a separate table to hold them.

Database design is (one of) my weak points, so if anyone else has a better idea, feel free to chime in.

 

[Fornatian]

If using A97 I have used a simple text box to store the hyperlink rather than a hyperlink field.

I've then used a custom function to open the common dialog box(fileopen,saveas etc) to allow me to choose the file to link to.

Then I've saved the value returned by the dialogbox into a field.

To see a working example of getting a filename into a field try downloading this file:
http://www3.sympatico.ca/qaissuper/Zips/DatabaseCompactor.zip

This definitely works because I submitted it myself. One person has had trouble opening it when they've downloaded it before so if you have any trouble e-mail me and I'll send you a copy direct.

I agree with LQ with regard to the design issues, a 1-to-many relationship between your
'log' and 'hyperlinks' table.

To open the hyperlink you simply need to add:

Application.FollowHyperlink Me.TheFieldName

to a command button, or even on the double click of the phoney(excuse the pun) hyperlink field.

HTH

Ian

 

[dreamer]

Can't open db

Could someone tell me how to open the Compactor db? I get an error "The current user account doesn't have permission to enable or open the database" even though I do not have any security setup. I'm on A2K.

 

[Fornatian]

Send me an email at: formatian@aol.com and I'll send you a copy,

 

[red2002yzfr1]

I tried to open the compactor.mdb, got same error, the email address to email is no good and the link is forbidden (broken), any help would be nice.

 

[F5Tornado]

Re: Command button for "Insert hyperlink"

download the aforementioned file - extract - create a new access database - import all of the objects - this bypasses the need for the mdw that the database was created with. hope this helps - good luck!

 

[boblarson]

Re: Command button for "Insert hyperlink"

And you're posting to an 8 year old thread - WHY?

 

[red2002yzfr1]

Re: Command button for "Insert hyperlink"

Maybe because the thread was not finalized - it happens.

 

[F5Tornado]

Re: Command button for "Insert hyperlink"

>> On 01-18-2010 @ 11:25 AM, an i-think-i'm-smarter-than-all-of-you forum poster named "boblarson" arrogantly typed the following:
>> And you're posting to an 8 year old thread - WHY?

Let the following now be heralded and forever set in stone:

boblarson's arrogance and pompous attitude has overshadowed whatever intelligence - whether real or imagined - he possesses. furthermore, his callous remarks have dampened the can-do spirit of posters who endeavor to help their fellow programmers in their hour of need. moreover, his transferred intent has willfully harmed and contributed mightily to the demise of goodwill and harmony - which must exist and prevail for knowledge to be garnered and disseminated.

Therefore, I find you guilty of schmuck-ness. Your moniker and avatar will be catapulted up and over to the number one position for:

Schmuck-a-roo of the week.

May you find comfort and jubilation in this most prestigious of nominations.

p.s. - next time read the whole thread - thousands, if not millions of databases still exist where an mdw was used and must be circumvented - the advice given is still relevant. additionally, the code contained in the download file will save many beginner vb programmers a lot of time. oh, one more thing, just because i only have one or two posts in this forum does not give you the right to say whatever comes into that over-inflated brain of yours - in the end, you never know who's on the other end of your mis-directed insolence. now go back to your little bank and nickel-and-dime someone else.


F5Tornado - anti-cyclonic-ing MS Access since 1.1

 

[red2002yzfr1]

Re: Command button for "Insert hyperlink"

Although F5Tornado's point is well taken - it may have been a smidge over board.

I am not sure that there should ever be a response to a thread to point out how old a thread is and WHY someone is posting to it. If there is a time limit on threads and when posting it has expired, the thread should be blocked from posting to it. The downside to that is a person may create another thread of the same question or close thereof.

PS - This thread, although has information pertaining to the original question has become opinionated (including myself), therefore maybe need "copied" to another area for any further "opinionated" comments

 

[The_Doc_Man]

Re: Command button for "Insert hyperlink"

F5T, your response was overboard and inappropriate. I rather considered asking that question myself, as after a certain point you must assume that the original poster (OP) has abandoned the question. If the OP doesn't "bump" the question after a while, it is like talking to a dead phone.

Just one man's opinion.