Email program in MS Access is not working

[Lou_Reed]

In one of the attached zip files there is database which when you open a certain form will allow you to send an email. The form is frmEmail and it allows one to view a certain person's activities and then to send them an email if there is something important that they should know such as an upcoming meeting, etc.



Now I have this part of the db working before, but as I said in a post yesterday, I have not used or tested the db for several months. When I use it now, I get a error : invalid use of null.

I am not sure what is causing that and hence the purpose of this post.

This button to send the person an email should open up and email with said person's email address and space for the body of the email. It should also allow the sender to even add an attachment if they wish.

It does do any of these at the moment all it does is give the error message that I listed above.

One should also know that this system only works on MS OutLook so it may be hard to replicate if one is not using MS OutLook for email.

I should also state that the coded to send the email compiles and does send an email, why it is not doing so now is a mystery.

I am using MS Access 2010.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, I think that I found a way to make the email from work, so I am changing the question. If I select an employee from the combo box it will open the from to send an email. If I just take whatever is there when I
open the frmEmail, it will generate a invalid use of null.


I can see why if would fail since the VBA code uses cboEmployee, but why do I have to select it. the combo box already has a name and I just chose to send it instead of selecting one and then choosing to send an email.

So that is my new question on this forum. Why must I select the Employee's name first?

Any help appreciated. Thanks in advance.

Respectfully,

Lou_Reed

[Lou_Reed]

I think that I have found a way to repair this wrinkle in the db program. It would not be fair to call it an error. This will make the form a little harder to use, but since when should forms be easy to use?

Again consider the form as shown in the attached jpeg file. it defaults to a name : Peter Cushing.

I am not sure why it chooses that name - it does.

Is there way to make the combo box show no name or a blank in the name slot so a use will be forced to choose a name? The would make everything alright.

Any help appreciated. Thanks in advance.

Respectfully,

Lou_Reed

[June7]

The Null is because no value in the employee combobox. The combobox AfterUpdate event is setting the combobox back to empty string. The email procedure references the combobox for the employee name. Change code to reference txtName textbox.

strBranchhead = Me.cboEmployeeName

should be

strBranchhead = Me.txtName

[Lou_Reed]

That loosk like it will work. Of course, Me.txtname must have a value for it to work.

Thanks very much, I will give it a shot.

Respectfully,

Lou Reed

[June7]

Well, if there is any chance any of the fields will be null and you want to prevent the email code from executing, use If Then Else conditional structure.

[Lou_Reed]

Thanks, I think that I will.

Respectfully,

Lou Reed