DouglasBell
Active member
- Joined
- Aug 16, 2011
- Messages
- 38
- Programming Experience
- Beginner
Hi
I have a Visual Studios 2005 Application programmed in VB. The program is a VB Front End to an SQL Backend. The program logs Jobs that have to be completed. If a job is not completed after so long an email gets sent to the user to get them them to complete the Job.
This was ok in the beginning but now there is thousands of Jobs and the user has to scroll through the jobs to find the correct one.
We use Lotus Notes as our email provider. Is there any way that I can send some sort of link to the user via the email that will open up the program and bring up the form with the correct record for them?
I know I can create a hyperlink in the body of the email that will open up the program but I cannot figure out how to load a form on a particular record. I was thinking along the lines of that if I could pass the ticket number to a label on the main form, then use the On Load command to open up the correct form and ticket, but cant figure out how to pass a parameter from a hyperlink.
Any help is appreciated.
Regards
Dougie
I have a Visual Studios 2005 Application programmed in VB. The program is a VB Front End to an SQL Backend. The program logs Jobs that have to be completed. If a job is not completed after so long an email gets sent to the user to get them them to complete the Job.
This was ok in the beginning but now there is thousands of Jobs and the user has to scroll through the jobs to find the correct one.
We use Lotus Notes as our email provider. Is there any way that I can send some sort of link to the user via the email that will open up the program and bring up the form with the correct record for them?
I know I can create a hyperlink in the body of the email that will open up the program but I cannot figure out how to load a form on a particular record. I was thinking along the lines of that if I could pass the ticket number to a label on the main form, then use the On Load command to open up the correct form and ticket, but cant figure out how to pass a parameter from a hyperlink.
Any help is appreciated.
Regards
Dougie
