Recent content by sonjuraec

when i do that it keeps telling me expected end of line

I am now here Public Sub something5() Dim db As Database Dim rs As DAO.Recordset Dim mailto As String Dim ccto As String Dim bccto As String mailto = "xxx@xxx.edu" ccto = "" bccto = "" emailmsg = "Hello," & vbNewLine & "Please review the attached report and contact me directly with any...

Okay- so here is my code. What i would like to do is replace the DoCmd.OutputTo line with a DoCmd.SentTo line to email the reports to the appropriate faculty instead of just saving them in the folder. I used this line but it did not work: DoCmd.SendObject (acSendReport, , acFormatPDF...

I would be interested in this as well. I actually want to put a print, close, and email button in the upper righthand side of the report in print preview

we got it!!! it was creating the same report for everyone, just the first faculty's in rs because i wasn't closing the report in between!! I added the Docmd.Close and VOILA!! Thank you so much! You guys are fantastic, and I have already signed up for Visual Basic and Database courses for next...

Okay- it is now giving me the compile/expected end of statement error at the " ' " at the end. (I put those spaces in there just to post it)

I did this using the link you provided because it is text "rs!Faculty = ' "&Faculty&" ' " now it creates an error for each faculty member

With rs While Not rs.EOF DoCmd.OpenReport "Backgrounds", acViewPreview, , "faculty =" & rs!Faculty DoCmd.OutputTo acOutputReport, "Backgrounds", acFormatPDF, "C:\Users\Sonjurae\Desktop\" & rs!fn rs.MoveNext Wend End With I tried the if thing but that wasn't the problem because i forgot that my...

First THANK YOU for responding! I tried that and it now tells me that it is typed incorrectly... However, when I move my mouse over the rs!faculty, I see a value! this is where it fails DoCmd.OpenReport "Backgrounds", acViewPreview, , "faculty =" & rs!Faculty

Bear with me folks- I am just an English teacher so a lot of this is beyond me. My code is creating a pdf file that includes everybody's reports instead of just that faculty member's reports. Once I get it to generate the correct reports, I then have to figure out how to automatically email...

Same Problem here! Bear with me folks- I am just an English teacher so a lot of this is beyond me. My code is creating a pdf file that includes everybody's reports instead of just that faculty member's reports. Once I get it to generate the correct reports, I then have to figure out how to...

Hi all- My name is Mikkie and I am an instructor at a community college. I use access a lot to track my course data and am now working on getting into making it work with the other office programs. Nice to meet you all- :D