Emailing only the current form in PDF

[mara]

Hey,

I am new to access and at the moment I am creating a HR database with two main switchboards, one which will contain new forms and show no personal data, to sit on all employee machines. The other will be for management to have access to all the information which the employee has filled in.

At the moment on the incident report form I have created a 'send' macro which automatically sends a PDF of the form to alert the manager, who then needs to complete the rest of form. I want it to sill send a pdf, or something similar that way management can view the report and prioritise and also because I have used a perameter query for the management to enter the report number.

However this sends a pdf version of all incident reports which have been completed, which for privacy reasons, I cannot have this as then employee's would be able to view all previous data through their sent box.

Is there any other way to do this? I have numerous forms which will need to have the same management alert.

Thankyou
Mara

 

[PNGBill]

Do you know how to have a report for just one Employee produced ?

If so, this is most of what you need to do.

What version of access do you use ?

 

[mara]

I seem to have trouble when it comes to doing this as my employee names are a dropdown menu create when someone adds an employee into the employee detail area.

How would I go about this?
Or would it be simpler to create a report based on the Incident reports number? which is an automatically generated number and only displaying the newest form.

I am not too sure on how to link tables yet, as eventually I want to also be able to search an employee and be able to pull out all there information concerning which reports they have filed or been mentioned in.

I use Access 2007.

Thankyou

 

[PNGBill]

The data source for a report on all employees is the same as a report on one employee except it only returns the data on one employee.

Normaly for Employee issues the Unique Record is Employee Number.

The wizard should assist you to add a command Button to your form that will allow you to cal a report and link the fields it will use to filter the data.
Have you any experiance with this?

Areyour familar with Queries ?

 

[mara]

I am familiar with querys, and have even tried using a combo- box (both linked and not linked) where the person would select their name, as apart of the form, and the query would be sent it as a pdf of only their reports. Also I tried as the days date to minimise the amount sent and so on, but i still only seem to get error messages.

Is there any other way of doing this? Because as a last resort I may have to send an automatically generated email that only says an incident report has been completed, as to not compromise privacy.

 

[PNGBill]

Can you attach a database and someone should be able to sort out the issue for you.

Remove all sensitive data and tables, forms etc not required. Compact and repair and it should be less then 1mb by then.