MasterandCommander
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks mildurait! I appreciate your participation on this.
I award the full points to boag2000 for the completeness of the answer.
I award the full points to boag2000 for the completeness of the answer.
ASKER
Absolutely great!
You are a genius boag2000! Fantastic.
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
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
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.