Hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a label control defined as Hyperlink. It can link to another form. But I want to define the called form as acDailog so that user cannot escape from it. I know it is possible to do with codes. Appreciate in advance for help.
 
Thanks and I understand what you meant. I am using hyperlink because actually the form is a "menu" which contains a lot of options for users to choose. Hyperlink will cause the cursor changing to fingerpoint that is much impressive than a label or a textbox or a command button.
 
but you still can use hyperlink label and use it click event to open form

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Raymond said:
Thanks and I understand what you meant. I am using hyperlink because
Click to expand...
actually the form is a "menu" which contains a lot of options for users to
choose. Hyperlink will cause the cursor changing to fingerpoint that is
much impressive than a label or a textbox or a command button.
 
Yes, Alex. I cannot do it and it is working prefectly. One draw back is I cannot set the called form to WindowMode=acDailog (I can't remember the exact syntax). I want to set this because I don't want my users go to other forms etc. I want them to fully complete the task. So far the form flow is controlled by codes. I like hyperlink because it has the fingerpoint cursor. Do you think I can control the WindowMode of the hyperlink? Appreciate your advise again.
 
well, again, the idea is to use VBA CODE to open form. exact steps:

1. add a label, caption Click, hyperlink address #
2. add click event for this lable, write there:

DoCmd.OpenForm "form1", , , , , acDialog

3. you see that label have hyperlink, cursor is finger

4. click on label - form is opene in dialog

tried on Access 97 now

HTH

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


Raymond said:
Yes, Alex. I cannot do it and it is working prefectly. One draw back is
Click to expand...
I cannot set the called form to WindowMode=acDailog (I can't remember the
exact syntax). I want to set this because I don't want my users go to other
forms etc. I want them to fully complete the task. So far the form flow is
controlled by codes. I like hyperlink because it has the fingerpoint
cursor. Do you think I can control the WindowMode of the hyperlink?
Appreciate your advise again.
 
clear subaddress also, form is opened by CODE only
in hyperlink type # only
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Raymond said:
Alex, I am not sure if I really understand you. I use the hyperlink
Click to expand...
subaddress property to link to the form and write codes on On_Click to open
the form in acDailog mode. The result is when I click the label, the on
click event occurs, the form displays in acDailog mode. After I close the
form, the hyperlink subaddress property takes place. So the form displays
again. Please correct me if I misunderstand you.
 
Alex, thanks a lot. Your suggestion is working perfectly.
Actually last night came out a stupid but workable solution. Since in my code I close the menu before the form is open, therefore in the hyperlink subaddress I put back the link of the menu there. So when I click the hyperlink, the OnClick event will take place and display the form in acDailog mode. After finished with the form, the hyperlink will occur and the original menu displays again.
 
Back
Top