PDA

View Full Version : report from a form



Slowhand
11-26-2004, 02:19 PM
How do I set a command button on a form to send an email report based on a unique field on the form - any help much appreciated

GP George
11-27-2004, 12:04 PM
That's sort of a vague description of what you need to do. Can you explain a bit more: What is the unique field (a primary key, an email address, or something else)? Is the report supposed to be the body of the email, or does it need to be an attachement? Do you use MS Outlook as your email client, or something else?

HTH

George

Slowhand
11-27-2004, 02:16 PM
Many thanks for your time to look at this

I have Outlook as my mailer - the unique field is Primary Key - the report needs to be as an attachment - the report is based on a query using the primary field

What I have is a dbase used in a problem management situation. the unique field is the reference used to name the problem (numeric). when the dbase is open it is used in a 'form' view for updating each problem when and as required. I have several 'expert domains' that are required at some point to look into the problem, so what have to do is go from the form into the report then mail a copy to each domain. when I click on 'send' the report then attaches itself to an email where i then have to fill in the subject line with "CHKD P######" (###### = Problem number)

If possible what I would like is the have a button on the form that when selected automatically sets the report, attaches it to an email with the subject line completed

GP George
11-27-2004, 02:45 PM
I forgot to ask which version of Access you are using.

George

Slowhand
11-27-2004, 02:59 PM
2003

GP George
11-27-2004, 03:05 PM
I'll post a demo in few minutes

GP George
11-28-2004, 01:39 PM
Did I say a few minutes? I meant a few hours, Sorry.

Slowhand
11-28-2004, 02:33 PM
You Sir are a gentleman :ole:

bkudulis
06-02-2005, 04:06 PM
I posted this question in a different thread before I seen this. I am trying to send an attachment (rtf) but when it gets sent the lines and checkboxes are gone. How can I retian the formatting that is in Access?

GaryB
06-02-2005, 04:32 PM
George,
Could I impose on you to post a sample in Access 2000 also?
It would be geatly appreciated.

Thanks
Gary

xCav8r
06-02-2005, 06:58 PM
I've not looked at his db in any detail, so I have no idea if it needs anything in 2002-2003 format. I converted it anyway. Hope it helps.