Re: [MSAccessProfessionals] Getting Access data into a PDF Template

Why not just email an Excel-template around? If needs to be pdf you need a pdf-form creator from Aabyy, Foxit, Adobe PDF creator.

 

On or site, you see some very simple code to have people submit their hours to SQL-Server of Azure-SQL. We have Flow threads that you can use if you want.

 

https://youtu.be/uLCcdZ3d_pw

rob

 

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Jim Wagner
Verzonden: maandag 30 maart 2020 18:58
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

Our department does not have access to sharepoint. getting people just to use slack and zoom is like very difficult. one person said that she did not want to have to go and use something else and would only use email. I am living in a tech dinosaur land of people

 

Jim

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 9:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

You can have it as all pdf documents. But its more work. You need a C# project. Easiest is to create Word docx and have a OnCreate Trigger in SharePoint that automatically converts it into a PDF.

Rob

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: maandag 30 maart 2020 18:37
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

so because it is a university and we are under ferpa and other adherents and some people's lack of trust and understanding of these new technologies, I am limited. this may seem crazy but it is what it is. 

I have played with powerapp but putting something like this in production would be more of trying to pass a bill through legislation right now. it would be like trying to get the earth to stop turning. 

 

I once asked if i could get SQL server installed on my machine. considering we had bought SQL as a department. But they told me "SQL is a security risk" I said what??? 

 

Jim. 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 3:44 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

We built a PowerApp that integrates with Access through SQL-Server with an option to sign report. Perhaps I’m not understanding correctly but why would use PDF for that?

Kind regards.

Rob

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Stuart Schulman via Groups.Io
Verzonden: maandag 30 maart 2020 03:13
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

I’ve done that using Access many times in different client sites.

 

Stuart

 

Sent from Mail for Windows 10

 

From: anzus101
Sent: Saturday, March 28, 2020 10:25 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

Check PHP Rad and Postgres.I am starting to move away from access and these technologies are my best picks.

On Friday, March 27, 2020, <josephwagner2@outlook.com> wrote:

Hello All,

We are trying to send out timesheets now that we are stuck at home. But the VP wants them to be fillable forms so that they can fill out hours and then sign and return. We have looked everywhere and are unable to get data into the template. Is there a way to do that? I did find a site that stated that it cannot be done, but where there is a cannot be done, there is a can be done. 

Any help would be greatly appreciated.

Thank You
Jim Wagner