hyperlinks vs command buttons

hyperlinks vs command buttons

Post by LMB » Wed, 30 Aug 2006 20:57:08


I went to a class in access 2003 and they suggested using hyperliks to
navigate to reports, forms etc...it seems really simple and worked well.
What would be the drawback from doing this?

Thanks,
Linda
 
 
 

hyperlinks vs command buttons

Post by Brendan Re » Wed, 30 Aug 2006 21:14:31

It's less flexible. The OpenForm method has six optional arguments that you
can use to specify how the form or report should be displayed and what data
it should contain. Hyperlinks don't offer the same versatility.

--
Brendan Reynolds
Access MVP

 
 
 

hyperlinks vs command buttons

Post by LMB » Wed, 30 Aug 2006 21:30:57

Do you mean like opening the form maximized or to show certain records?

Linda
 
 
 

hyperlinks vs command buttons

Post by Brendan Re » Wed, 30 Aug 2006 21:36:27

Among other things, yes.

--
Brendan Reynolds
Access MVP
 
 
 

hyperlinks vs command buttons

Post by Rick Brand » Wed, 30 Aug 2006 21:43:45


One example is that you can use code to test something before you decide to
open the form/report or not. A Hyperlink has no way easy to be "cancelled".

I like the look of using hyperlinks and used them a lot in the past. The
limitations though now have caused me to abandon them entirely. What I do
now is use a label with a HyperlinkSubAdress of " " and then use code in the
Click event to do what I want. This still gives me the blue underlining and
pointing hand cursor of a hyperlink, but with none of the drawbacks.

There are some that would say "A solution that doesn't need code is better
than one that does." I would generally agree with that if the non-code
solution is not otherwise inferior. Hyperlinking around in Access apps
definitely is.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com