Multiple Hyperlinks in a Combo box ??

[djvirus]

Hey All,

Im not really sure how to go by this, i have searched the forums for the answer but i do not really know how to go by this. << im a complete noob .

I have a list of people in a combo box (not people but people's name's). each having its own code
ex : 45 Rick, 31 Jamie.
Each of the person has a assigned email template to them, What i am trying for is, when a user select's a a person (45 Rick), i want the combo box to display a hyperlink to that person's email.
If it is not possible, can i assign a command button where when the particular person is select it displays a hyperlink to that person's email.

Here's a link that was done something similar in excel to what im trying to explain. http://www.access-programmers.co.uk/forums/showthread.php?t=166702 (select the adjuster and it will display email in the email section)

if it can be done within the combo box, it would be great. Also another thing is that i do not know jack about vb coding, so i would really appreicate if you can give me a step by step procedure.

Thanks in advance

 

[rainman89]

I believe this can be done either way you want it to... In your table you can create a column called empID (assuming you dont already have this) and format it to a hyper link

Then in the combo box you can have the employee name and when an employee is selected you can use

=yourcomboboxname.column(2)

as the source and they can click on that

I can come up with a sample if needed

 

[rainman89]

Here's some more

You can put this in a button and have it send an email

DoCmd.SendObject acSendNoObject, , , Me.yourcomboboxname.column(2)

The combobox name is the name of the combo that you have both the users name and email in and the column# is the column that the email is in

 

[djvirus]

thanks for the quick reply cyber ninja . you had mentioned that "The combobox name is the name of the combo that you have both the users name and email in and the column# is the column that the email is in".
The thing is i dont have a column/field where the email is in. each of the employee has a unique email where i have created a template for each employee. all i need is a hyperlink to that selected employee for that selected email.
and sorry to ask you this ... i have to put that code in build event >code builder?

 

[rainman89]

The thing is i dont have a column/field where the email is in. each of the employee has a unique email where i have created a template for each employee. all i need is a hyperlink to that selected employee for that selected email.

So how are you linking the employee to the email template?

and sorry to ask you this ... i have to put that code in build event >code builder?

Correct

 

[djvirus]

So how are you linking the employee to the email template?

Well thats my main question, im trying to link each employee with their unique email in another words a hyperlink to the unique emplyee when chosen in a combobox list.

 

[rainman89]

What does your table structure look like?

I guess I don't understand how you can link them unless you have the employee ID in with the employee email...... And if that's the case, you should just have them all in the same table

 

[djvirus]

Okay. i have attached the sample db that i am working now. Currently i have made another form "emails" these contain only the hyperlinks to the unique person. In Forms i have Docs log and Calls Log. you can take either one of them.
Example in Calls log. The examiner has a drop down list of examiners (combo box). What i actually wanted is when we select 45 Rick, it should display a hyperlink to Rick's email and 44 to 44's email and so on in the examiner combo box
OR
If we can create a command button beside it, where when the selection is made, it can display the hyperlink to the email. This is just to elminate the extra email form and the user can be accurate in selecting the right email.

i hope this can make you understand it. Thanks in advance.

 

[rainman89]

Sorry I havent gotten back to you sooner. I got busy yesterday.

Ok first things first. Are these the only tables that you have in your database?

call log
docs log?

If that is so we are going to need to do some normalization first.

The 2nd part that you want to do is simple compared to that!

 

[djvirus]

Sorry I havent gotten back to you sooner. I got busy yesterday.

Ok first things first. Are these the only tables that you have in your database?

call log
docs log?

If that is so we are going to need to do some normalization first.

The 2nd part that you want to do is simple compared to that!

yup.. just those two logs...
normalization??
2 part???

Take all the time you require, i appreicate the assistance.

 

[rainman89]

yup.. just those two logs...
normalization??
2 part???

Take all the time you require, i appreciate the assistance.

Yea you should read up on normalization!!

You should have a few different tables

Employee
Customer
Call
Doc
Source
Unit
Examiner...

those are just a few and without knowing the exact structure or what you are trying to do Its hard to give an exact idea

 

[djvirus]

well ray,

heres the deal. i have 5 agents whose use this. this a tracker used on a daily basis for the production. my excel sheet was made the same way in the access form. Hence i have to use the same fields as it required for us to track our daily work.

The feature that i am trying is to input into the form is the hyperlinking email part. i have finzalized on the table structure and i require all those fields which are mentioned on it.

Coming to the Form that i have designed. The feature i require is when i select a examiner name i want the combo box to display a hyperlink to that extact email of the examiner. if you have noticed in my first post,i have linked a topic on excel, In Excel, the forum (kiwiman) helped me find out a vlookup forumula where if rick was selected the next column would display the link to his email. if ann was selected the next column would display the link to her email. That particular column was dedicated only to the hyperlink (link to emails).
I am actually looking up for that same feature in access which i know it is possible with some vb coding. a text box or a button which can display a link to that examiner's email when select from the combo box list.

Kinda like when i select rick the next text box or button should be linked to his picture. Or if i select ann the next text box or button should be linked to her picture. so it all depends on selecting the examiner and displaying a link to their picture.

P.S : 3nf.. yeah i remember that now.

 

[rainman89]

I understand that but nowhere in your database do you have 45 tied to rick until the adjuster field and that is purely text... That's why I am saying that you are better off, and you will thank me in the long run because you will run into problems doing it this way, redesigning and making an employee table... This will make it VERY simple to do the email link that you are looking to do

I'm only trying to help you by telling you this. I can see this getting very messy if it is not addressed soon!