Letters

[lead 27]

Hi

I am just wondering if there is any way that you can use access to input information into a letter

i.e. you could just click a command button and it would print a standard leter with the details from an address on access e.g. name etc

Thanks

 

[rainman89]

Hi

I am just wondering if there is any way that you can use access to input information into a letter

i.e. you could just click a command button and it would print a standard leter with the details from an address on access e.g. name etc

Thanks

Sure... This is done with the reports section of the access program. You would place the relevant fields into the appropriate places on the report and enter the other standard information around that

 

[GaryPanic]

2 points here
to answer your question (1)Yes its do-able

(2)however if these are standard letters let the report functions/ability in access do this for you

also if you look at letter writers in the samples this will point you int he right direction

 

[GaryPanic]

oops - sorry Ray you beat me to it ...

g

 

[lead 27]

Thanks I will have a look. Thought that you could do it but wasnt sure where to start

Thanks for your quick replys

 

[GaryPanic]

Tip

use qry as your report -source
and the wizard will take you through this quite well
g

 

[rainman89]

oops - sorry Ray you beat me to it ...

g

No worries my friend

 

[lead 27]

OK I've managed to set it up however When I select to view the report the report is made up of all the fields but (so there wil be lots of letters) however I just want the one that I am viewing at the time

Any sugesstions?

 

[GaryPanic]

ok -
don't worry about how many reports you have just get the layout right
the ability to filter this is easy

you will need a simple line of text(code in your qry source ) and it will be
based on your unique number in your form

in your qry you will need
"=forms![formname]![formfield]


formname = the name of your form
formfield = the name of the unique identifier on your form (Usually an autoid number)
this basically runs the qry but limits to a critia -
which basically say's where do i look
oh its in a form , which form , ooh that form and then where about on the form, oohh that field

I made this simple - so if it looks as if I am dumbing this down too much - aplogises

g

 

[lead 27]

Thanks for replying. Hopefully shouldnt be to difficult (which normally means it will be LOL). I will have a look when I get home tonight.

Thanks

 

[GaryPanic]

if you get stuck - ping me and I whizz up an example (access 2000)