Novice
Windows XP 
Access 2007
Sorry I am a novice Access user.
I created a simple form layout. I want to generate a PDF for each row in the sheet and have them named by a certain field (let's call the field "Name"). I need to be able to find the form by name.
I have limited Access 2003 experience and no 2007 experience (besides creating this form). Can anyone help me (or at least point me to a tutorial on this)? Thanks!
Novice
Windows XP Access 2007
I guess it doesn't need to be PDF's. If I could just generate a report for each Row that would be key. I have over 500 and I don't want them all on one report.
Administrator
Windows 10 Access 2013 32bit
So you want to print a Report (PDF) for each record in your table? Does this link give you any ideas?
Novice
Windows XP Access 2007
I assume [RunId] is the field name I want to run it on?
Is there anything else I need to replace in that specific to my database?
Administrator
Windows 10 Access 2013 32bit
Your assumption is correct and that link shows how to print your report for just one record.
Novice
Windows XP Access 2007
I can't get it to work. If my field name is:
Well Name
What do I do? I replaced the RunID inside the brackets and it says field RunID not found for some reason.
Dim strDocName As String
Dim strWhere As String
strDocName = "rptSomeReport"
strWhere = "[RunID]=" & me!RunID
DoCmd.OpenReport strDocName, acPreview, , strWhere
Administrator
Windows 10 Access 2013 32bit
Name is a reserved word and should not be used. Just tell me what the real names of the fields and controls are and we'll put the code together.
Novice
Windows XP Access 2007
I changed it to "Well_Name" and it seems to stop flagging that.
The problem now is it is saying my report does not exist. I can create one and rename it within the code to match, but I want the output to match the form I created. The report creates more of a listing than an actual form. I need the output to display the table boxes I make in the form. I'm not sure I want anything to do with reports at all. Sorry for being a novice.
Administrator
Windows 10 Access 2013 32bit
Forms are for interaction with the user and Reports are for printing but I believe you can print a form. I'll have to do a little research and load my ac2007.
Administrator
Windows 10 Access 2013 32bit
Are you trying to make a users manual or something? Why are you trying to print the form?
Novice
Windows XP Access 2007
We have a large database with field notes for 500+ sites. The form displays these results in tables. We need to be able to export these forms to a PDF (obviously automated). They need to be individual, and in the layout the form is in. If that requires me setting up a report in that format, so be it. I wasn't sure it allowed that kind of manipulation though.
The output does not need any functionality at all (toggle boxes, text boxes for input, etc). It can be a completely static output as long as the look and feel of it matches those tables. I linked a sample output since it was too big to post (cropping off the company names on the top). All this data is in the database (BTW, the picture is not required in the output if that matters)...
http://i26.tinypic.com/sljl9c.jpg
Administrator
Windows 10 Access 2013 32bit
Have you played with the PrintForm method yet?
Novice
Windows XP Access 2007
nope. don't know anything about that.
Administrator
Windows 10 Access 2013 32bit
Help should give you some insite into the method.
Novice
Windows XP Access 2007
I tried that and nothing came up. I searched these forums and this was the only thread it came up under too.
Possible to have a form that will create multiple records in a table?
Posting Permissions
Reply With Quote