Sending .pdf in Outlook

[pbaldy]

Happy to help!

[Stephanie53]

Oh Noooooo....

I came in this moring...and this is the error I get when I went to show this to the upper management that finally got it working...



HELPPP :-)

TIA

Stephanie

[pbaldy]

What changed? I can't imagine why it would have worked Friday and failed today if nothing changed.

[Stephanie53]

the only thing I can think of is the issue I have on another post:

https://www.accessforums.net/forms/n...ate-34520.html

Can you assist me there and see if we can get both to work?

[Stephanie53]

I think that this might be the conflict..would you say so?

[Stephanie53]

I just tried to remove that since we put the code in another place and when I do another SQL error comes up. So I put it back. I am not sure what happened :-(

[June7]

Show the SQL of the report RecordSource.

You put the code in what other place and what error came up?

Why is the code in a function? Are you opening report from more than one location?

[pbaldy]

I don't see how the other thread could relate to this problem. The code in the image is just opening the report filtered. Does the report open correctly if you open it from the navigation pane?

[Stephanie53]

no..here is the errors i am getting!



and here is the other when trying to open Invoice Report

[Stephanie53]

do you want me to rezip the DB and send it to you so you can make a comparison?

[Stephanie53]

Database5b.zip

It seems to stem from the CustomerOrders Module

[Stephanie53]

June I didnt see your post...

In the form there is a place at the top that says Create Quote/Invoice - it opened the Invoice Report from there before

And when double click in where the email address is it not only shows the Invoice Report it also attaches to email - that was working on thursday last week too - now its not

I didnt go into any of these and add/change codes for this function so I am not sure if anyone else has access to my DB to go into this to make changes

But now neither one works today...ughhhh can I toss this away and go on vacation? lol

Thanks again for your patience!!

Stephanie

[Stephanie53]

Could this be it??

[June7]

The code in DblClick should work if it is on a form, NOT THE REPORT. If the function is not being called from anywhere then delete it. Simplify the issue. Let's just deal with one procedure.

This issue is not with the code syntax. It has to be in the report design. I will look at your project later if Paul doesn't get back with solution first.

[Stephanie53]

Ok I will wait and see...and thank you for this help again :-)