Two reports as attachment (1 Viewer)

Ravi Kumar

Registered User.
Local time
Today, 21:47
Joined
Aug 22, 2019
Messages
162
Hello all,
How can I send two reports as attachment at a time with the help of the button?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 09:17
Joined
Oct 29, 2018
Messages
21,358
Hi. What is your email client?
 

Ravi Kumar

Registered User.
Local time
Today, 21:47
Joined
Aug 22, 2019
Messages
162

hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??
 

Attachments

  • Database2.accdb
    1.6 MB · Views: 115

theDBguy

I’m here to help
Staff member
Local time
Today, 09:17
Joined
Oct 29, 2018
Messages
21,358
hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??

Hi. I am currently on travel and won’t be able to download your file for a while. I will let you know as soon as I get a chance to look at it.
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:17
Joined
Sep 21, 2011
Messages
14,044
Ravi,

You really need to start with the basics and some basic debugging.
Getting everyone to write/amend your code for you is not going to help you much.

I have just downloaded your db and it is not evident where you are emailing?

You have to tell people how to replicate your problem. :(
I cannot even find the word attach in any of the code. :banghead:


hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??
 

Ravi Kumar

Registered User.
Local time
Today, 21:47
Joined
Aug 22, 2019
Messages
162
Ravi,

You really need to start with the basics and some basic debugging.
Getting everyone to write/amend your code for you is not going to help you much.

I have just downloaded your db and it is not evident where you are emailing?

You have to tell people how to replicate your problem. :(
I cannot even find the word attach in any of the code. :banghead:

ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:17
Joined
Sep 21, 2011
Messages
14,044
ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .

Well I tend to start with Google. What we did before that came along I cannot remember.;) I do have an Access 2007 for Dummies book, but rarely look at it after reading it like a novel.

Normally Google will give me something to start with.
Another user has just posted for something similar and I mentioned the Similar Threads links at the bottom of this page.

Where in the DB is the code you amended from the link DB posted?, as I mentioned I could not even find the word attach which I would have thought would be used in the code?
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:17
Joined
Sep 21, 2011
Messages
14,044
Ravi,
I'm willing to try and help you with this query, but you need to give me something to work with.?

ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:17
Joined
Sep 21, 2011
Messages
14,044
Ravi,
You are not accepting PMs, so I have to post here.

Please do not take my post in your thread of attachments as a personal insult.
It is just that you really will not help yourself if everyone is prepared to write the code for you.

I am not that experienced, so cannot knock up code off the top of my head. I google for what I am looking for and then amend, and that way I have learnt more and more of Access.

Now when I want to do something, like email data, I look to see where I have done this previously, Copy the code and amend it. The beauty of this however, is that I *understand* the code, as I amended it in the first place.

HTH
 

Ravi Kumar

Registered User.
Local time
Today, 21:47
Joined
Aug 22, 2019
Messages
162
Ravi,
You are not accepting PMs, so I have to post here.

Please do not take my post in your thread of attachments as a personal insult.
It is just that you really will not help yourself if everyone is prepared to write the code for you.

I am not that experienced, so cannot knock up code off the top of my head. I google for what I am looking for and then amend, and that way I have learnt more and more of Access.

Now when I want to do something, like email data, I look to see where I have done this previously, Copy the code and amend it. The beauty of this however, is that I *understand* the code, as I amended it in the first place.

HTH
dear sir ,
I am very sorry I was not able see your messages as I was busy in office work, really I didn't took it as insult .
I also know that always sending databases to write the code is not usable in long time.
hence I have also started reading access vba book to increase my knowledge about the same.
I really appreciate your concern.
Thank you so much for everything again.
 

Users who are viewing this thread

Top Bottom