Re: [dba-users] base & using a text document as a starting point

[Rodney D. Myers]

On Mar 12, 2008, at 5:44 AM, Drew Jensen wrote:

Rodney D. Myers wrote:

I'm trying to setup a database for my brother, to track some of his clients.

Thanks

I have a form he wants, setup in writer. Getting the base portion is "simple" enough. Now, is there any way, to have the form link into base, and use each field as indicated in the database, so he can print each record separately?

Hi Rodney,

Well, yes.

You could go one of two ways I suppose.







Drew

1) you could use a macro to step through a record set and print the form for each record. There is a good example of that on one of the forums from a while back. The macro is quite simple. 2) You can do this using the Mail Merge feature - but you are not limited to mail merge fields if you created the form fields in advance. The way I have done it is by saving the form as a template and then starting mail merge for a new document, based on the template. Then just blow right by the part where you pick the mail merge fields. Hopefully that makes sense. The question I would ask you is: Does you brother want to generate printed documents for every record in the database, every time?

Thanks. I will try that, and see what I can figure out.

Yes. He takes each document when he is out and about.



--
Rodney D. Myers <[EMAIL PROTECTED]>
ICQ#:         AIM#:            YAHOO:
18002350      mailman452       mailman42_5

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759

I know, if he didn't, I could have this up and running for him quickly, but he wants each document in his folder.

PGP.sig
Description: This is a digitally signed message part