Make a form to design a report (Access 2000)

[Geronimo]

Hi all



Is there any way that a form can design a report.



Let's say I have a table called "tblLetter". I want to be able to 'pick' the
fields for the letter in a form. All the fields are in a "tblField" table.
The tblFiels contains fieldID, letterID, fieldformat, fieldtext,
fieldsorting, fieldposition, fieldlength. This 'letter' is printed from a
form where I write the name, address, etc.

When I 'pick' the fields designing the report, I want to be able to design
the form which the report is based on. The position and format of the field,
if it's an input box or textbox, etc.



Here are some relations I haven't figured out yet, but is this possible, or
does anyone have some idea? Or is this just bad English??



I want a letter sized print/report/form



//MK

 

[Albert D. Kallal]

I don't think you want to try and making something that the user changes at
run time.

However, give my word merge example a try...it might be exactly what you are
looking for. It allows you to make the template, but all merging, crating,
and launching of word is managed by my software.

Check it out at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html