Search results

I have been struggling with this for to long.. That did work and thank you. But I guess my logic was not really thier. It's not returning what I wanted. Can anyone please give me some direction. I'm not sure what to do with this. Thier is an example of what I want it to look like in the zip I...

When I do this I get a message that says a program is trying to access an email address you have stored in outlook do you wish to allow this. And then I have to click yes for every single e-mail. I tried the allow acces for 10 minutes but it still makes me click yes. I am trying to send over...

I am also having this same problem.

That worked as far as sending the email but I am still having two problems with it. 1st I can not get it to include the person's name in the body which is another feild in the database. 2nd It will only let me send one line of text in the body of the letter. Is thier any way that I can extend...

Nice, Very Nice. Thank you very much.

Is thier any way to send out a mass email using email address's from the results of an access database query?

You can open the query in design view and right click and select properties. Then select unique values = yes

I could not get both attachments in one file. This is an example of the end product.

I am attaching a zip with everything you should need to look at the problem the way I see it. If you need anything else please feel free to ask or make suggestions. I know that the tables are not setup corrctly but to change them I would have to change thousands of lines of cold fusion code.

Help Can you give any suggestions as to how I can accomplish what I am needing to do or is access really as weak as everyone says it is? I have already figured out how to do it in SQL and Cold Fusion but unfortunatley I need access to do it. Every time I ask for help from someone they say...

I am trying to use nested iif statements so the second option would be the next iif. I am not sure if my () are in the correct place's. Maybe you could help me with that or tell me if I can even do what I am tring to do. Maybe it will help if I break it down a little more. SELECT DISTINCT...

I have two query's. One for fall semester and one for spring semester. I am trying to set up a transcript. I am getting an error on the lines with <> but I do not know of any other way to do this in an access database. I have asked several people for help and no one can figure this out. I...

How can I use iif not in an access query. IIf (fsubject not = to ssubject ,do this) Is equal is easy enough but I'm not sure what character I use for not.

Still need help These are good suggestion and I tried to make it work but I am still having a probelm. I have attached a zip file with a sample of what I am working with and a txt file with some directions to show you what I have been doing. I have talked with several sql programmers and no...

I need help printing two records on a single line ClassName Semester Grade Biology F A Biology S B What I want is to join the two records in a transcript report so that it shows up like this Biology F/S A/B I can't change the database tables because I...