Search results

Yes I have outlook?

Dear AccesMSSQL, I decided to go back a bit and learn to send my 1st email. I read the section access on SendOpject for some enlightenment, and I tried the following code but got this error message; Microsoft Office Access can't sent this emal message. Private Sub Command0_Click()...

Thanks AccessMSSQL, Firstly, I am comfortable with VBA. Secondly, I have never used the emailing feature before. So to simplify my 1st experience, please guide me as if each customer is getting their report irrespective of whether it is open, thus avoiding the filtering at this stage. I...

Thanks. I will get to work and hopefully by tomorrow I will be done.

I have a table of 'customers' with fields: Name, Address and email Address. I also generates a report of all the customer open invoices, and I want to send them individually to their respective customer email addreses.

The Table consists of 2 fields: Name and Scores. In the report there needs to be a field with a comment for each score, so that a person who scores 90 is given the comment 'Excellent', the score of 80 is given 'Good', the score with 50 is 'Poor' and the person with 'A' is given 'Absent' etc...

Thanks Bryan. Actually the Scores field contains numeric values but also string, namely "A" for absent if a student was absent for the exercise. What is needed is a comment next to each score stating that a student 'Pass' or 'fail' or was 'Absent' or got a grade 'A' or 'B' or 'c' etc.

There is a Student's test score field called Scores. Next to each score there needs to be a comment based on each score. That is there is another field called Comments where the comments would vary for each score that is different. Is this possible?

Thanks, but I don't need an event triggered. I just need the value out putted like any other field quiery.

How can individual invoices be sent to their repective email addresses without sending the entire list of invoices to each email address?

How can a field be coded in VB to return a valued based on the values in another field. I need it to occur when the form is loaded and not by trigering an event like DBlclick etc. This is the code that I used but with no success: Private Sub Text19_Enter() If Hours.Value = "" Then...