One Click Save Single Record (1 Viewer)

[GraceUnderFire]

Hello!

I have a access database that consists of 2 forms and 2 tables. Staff members will be using the forms to record incidents. As this new database is replacing an older manual workflow, I'd like to make the process as simple as possible for the team and I need two things to do so:

1. When a staff member enters a new record into the form, is there a way to have a PDF version of the form that they just filled out automatically exported and/or saved to a shared drive or other specific folder?
2. For those that enter a new record into the form, what is the easiest/quickest way to sending that selected record through email?

#2 is easy to deal with once #1 is solved. #1 is giving me trouble.

Thank you

 

[theDBguy]

Hi. Welcome to AWF!


For #1, check out the OutputTo method.


For #2, check out the SendObject method.

 

[Micron]

#1 - forms usually don't reproduce well. Why a pdf and not an Access report? That would be the answer to both questions. For #2, you filter the report to the just created record. Regardless, once you have a report, you can always output it to pdf. At least you could in prior versions. I have not tried that since version 2007.

 

[mike60smart]

Hi

Why do you have to Send a Copy of the record to a Shared Drive?

Why not just share the database to users that need access to the Data?

 

[Micron]

Hi
Why do you have to Send a Copy of the record to a Shared Drive?
Why not just share the database to users that need access to the Data?

It's not uncommon to need to share data with people who neither have Access or a run time version and have no interest in either of those options. That's usually the approach that management takes.

 

[mike60smart]

Hi Micron

I realise this but I was just trying to get confirmation of the process.