Automate setting hyperlink location

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi Groupies:

I have created a hyperlink field in my table and on my form. When a record
is created, default text shows up so that the field is never empty. However,
I don't want the end user to have to right click on the hyperlink and choose
edit hyperlink to set the address.

I would prefer that if there is no address in place, the system opens the
Edit Hyperlink dialogue so that the location can be set. If there is an
address, then you would just go to that location.

I have no idea how to do this.

Any ideas?
 
CJ said:
Hi Groupies:

I have created a hyperlink field in my table and on my form. When a record
is created, default text shows up so that the field is never empty.
However, I don't want the end user to have to right click on the hyperlink
and choose edit hyperlink to set the address.

I would prefer that if there is no address in place, the system opens the
Edit Hyperlink dialogue so that the location can be set. If there is an
address, then you would just go to that location.

I have no idea how to do this.

Any ideas?
Click to expand...

I've never tried this, but it looks like it ought to open the Edit Hyperlink
dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink
 
Stuart McCall said:
I've never tried this, but it looks like it ought to open the Edit
Hyperlink dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink
Click to expand...

Hi Stuart

Thanks for the suggestion.
That command works if there is no hyperlink address. If the hyperlink has
already been established, it tries to change it.

I might just have to go with a little instruction to the users as I'm not
sure how to program around it.
 
Stuart McCall said:
I've never tried this, but it looks like it ought to open the Edit
Hyperlink dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink
Click to expand...

Hi Stuart

Thanks for the suggestion.
That command works if there is no hyperlink address. If the hyperlink has
already been established, it tries to change it.

I might just have to go with a little instruction to the users as I'm not
sure how to program around it.
 
Back
Top