Link to home
Start Free TrialLog in
Avatar of MasterandCommander
MasterandCommanderFlag for Portugal

asked on

How to do Hyperlinks in MsAccess 2003 Form that show Data Results?

Hi experts,

See the attached .jpg file with a MsAccess Form I saw on some Webpage.  Question:

How can I "collect" lets say the sum of some values (from a query) and show THIS as a blue link on a Form?  Once I click on the link it takes me to the underlying table.

Is this with VBA Code?
FormDashboard.JPG
Avatar of mildurait
mildurait
Flag of Australia image

Yes, VBA would be required.
a) You would the dashboard form's on open event to populate a label's caption property with the value which could be obtained through the DLOOKUP method or with DAO calls.
b) You would use the click event on a caption to open up a form and apply a filter to the form, or run the docmd.openform method populating the whereclause parameter.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MasterandCommander

ASKER

Thanks mildurait!  I appreciate your participation on this.

I award the full points to boag2000 for the completeness of the answer.
Absolutely great!

You are a genius boag2000!  Fantastic.
MasterandCommander,

If you like, you can ask mildurait to explain his technique and you can try it as well.

If it works as well, I have no problem with a split of the points.
;-)

Jeff