RE: pdf file per record creation from form

Tech-Archive recommends: Fix windows errors by optimizing your registry



Are you trying to print a screen/form or a report?

Because if it's a report then you can automate the whole thing.
By printing it to the PDF Writer e.g. for adobe you can print automatically
by setting the filename of the file before printing in the registry.


--
- Raoul Jacobs

The nature of developping is sharing knowledge.


"gg" wrote:

> I am trying to save each record in a form, call it frmData, as a separate pdf
> file with a name corresponding to a field on the master form. The purpose is
> put pdf data on a web site with each pdf record accessible as a separate file.
>
> Without getting into detail, I do this:
>
> From the master form- I rename frmData to match field on master, say FieldName
> Open form FieldName
> SendKeys "%(f)pa~%(s)" to print to adobe
> Close form FieldName
> Rename FieldName back to frmData
> Goto next record on master from (source of next Fieldname)
> Loop until last record
>
> My problem is that it works fine on my computer (w2000 access 2000) but on
> one user's computer, (xp, w2003), it will print the first 10 or so records,
> then cycle all the way to the end withou printing any more files. Is there a
> better way to do this? If not, do I have to do something different for
> Access 2003?
>
>
.



Relevant Pages

  • RE: pdf file per record creation from form
    ... I am printing a record, ... >> I am trying to save each record in a form, call it frmData, as a separate pdf ... >> From the master form- I rename frmData to match field on master, say FieldName ...
    (microsoft.public.access.formscoding)
  • What Product Is Out There For Assemblying Different Document Types
    ... I am trying to assemble electronic documentation, meaning word, excel, visio, ... files and I want to together in a "master" file for printing and having ...
    (microsoft.public.office.misc)
  • Re: Setting no print/specifying non printing graphic
    ... Howwever the printing has me perpelexed. ... specified landscape in page setup. ... "Mary Sauer" wrote: ... it will not be printed if you go to View and check Ignore Master Page. ...
    (microsoft.public.publisher)
  • Re: Background in PPT 2003
    ... Thank you to both Echo S and Sonia. ... > Color printing doesn't allow you to suppress the background like B/W ... > You'll need to go to your slide master and delete the background and also ... > color master after you print. ...
    (microsoft.public.powerpoint)
  • Re: TADOQuery - using 2 detail parameters for same master field
    ... >Of course, you can name a parameter whatever you want, but for TADOQuery, it must be the master ... >table's fieldname. ... Borlands ADO components are not going to maintain master/Detail with your SQL. ...
    (borland.public.delphi.database.ado)