davefwelch
David
- Local time
- Today, 01:47
- Joined
- Jan 4, 2005
- Messages
- 47
I am adding some queries and reports to an existing Access database. My goal is to create a 2-5 page-per-record report for over 300 records that are filtered from a 3,000 record table. Of course, I have a lot of work to do breaking down some decision-making that takes place regarding these 300 records and their related records in more than five other tables.
But to get to the point of this thread, I ultimately want to print this report to a PDF, and I would LOVE IT if Access could insert fillable PDF fields at certain points in the form, because the point here is to then make these PDF's available to our clients so they can then complete the fillable fields in Acrobat Reader and have their personalized report.
One solution that came to mind was to first create a fillable PDF form that contains all the fields I'd want populated from my database, but I don't think this will work. The Access Report will have 4 or 5 sections that will likely be subreports, likely containing multiple and varying rows of data themselves. I don't think this solution is viable.
Does anyone have any suggestions or know of any other resources I can research? I've done a web search, and get lots of hits, but all for the case where one wants to either get information FROM the fillable fields INTO Access or information TO fillable fields from Access.
But to get to the point of this thread, I ultimately want to print this report to a PDF, and I would LOVE IT if Access could insert fillable PDF fields at certain points in the form, because the point here is to then make these PDF's available to our clients so they can then complete the fillable fields in Acrobat Reader and have their personalized report.
One solution that came to mind was to first create a fillable PDF form that contains all the fields I'd want populated from my database, but I don't think this will work. The Access Report will have 4 or 5 sections that will likely be subreports, likely containing multiple and varying rows of data themselves. I don't think this solution is viable.
Does anyone have any suggestions or know of any other resources I can research? I've done a web search, and get lots of hits, but all for the case where one wants to either get information FROM the fillable fields INTO Access or information TO fillable fields from Access.
