Recent content by BHRIR

Re: Dsum using Multiple Criterea I apologize if our post seemed like a demand rather than a cry for help. I think some are better at trying to find solutions than others; based on your reply, I will plead guilty as others. This post came after reviewing many threads and our lack of experience...

This is being used in an update query I am getting the sum if OLID = OLID we recentltly added the the AND criterea and it is not working Still getting the sum if OLID = OLID This is the old Update to Statement that worked fine: IIf(IsNull(DSum("[WorkLabor]","OrderLaborLine"," [OLID] =" &...

Yes, I send it to a file Called BHRIR-AccessEmailEstimateAttachments. I consider this a temp file to store each file by its unique Title. I.e. "WalkowiczEstimate25229-082012BHRCopy.pdf" [LastName]&"Estimate"&[EID]&"-"[EstimateDate]&"BHRCopy" The PDF being added by the Output Method.

Thank You so much. Isn't it funny that there really wasn’t a problem at all with the Access software? I do think Microsoft could have made this information available when they created the "indispensable" email options. It’s such an easy thing to underline or put in bold; they had to know. I was...

I went to our main computor and created the same "DummyDataBase" there. Whata difference. However, it went to windows live for email and not msn. I did open my msn and I was able to viewthe email there as well; sent it to myself. Email Attachment: "Estimate.pdf", Awesome. However, what is...

The Report has the button called "Email". Open report in report view.

Hopefully I did it right!

I have created a small data base that allows the report to function called "Dummy Data Base". This is going to sound dumb, no pun intended, but how do I get it to you. I don't see an option to attach it here in this forum. I am a newbie

I am getting a creepy feeling it is an msn setting or Access output setting I can't find. Perhaps if you could use my data base in your environment we could narrow it down to these issues.

Can you define stripped down version? Do you mean the data base "dummy copy"? lol

I completed the activation of Outlook today. However, I did not make it my default program. It was too scary for me to make this jump because microsoft uses a different email address than the one I use daily and I can't switch it without error. Something I will address at a later date, maybe...

Windows 7 Ultimate is the version I am using - 64 bit

I don't use outlook to send the email. Access sends the attachment directly to my email account at msn. I don't believe I have Access set up to use outlook for email. Are you indicating that oulook is required/set up/running in order for Access to function properly in the DoCmd.SendObject method?

In response to an issue I have been reviewing regarding an email Attachment file Name and affiliation, I wrote I did as you suggested and still I received the message "No Current Record" What I discovered, I believe, is the Docmd.SendObject will only send the current record of the Form...

I did as you suggested and still I received the message "No Current Record" What I discovered, I believe, is the Docmd.SendObject will only send the current record of the Form, Module, Report, Table, Query or NoObject based on your acSend "Selection" and the ObjectName must be specified as one...