preview/printing checks with dot matrix

[wshs1]

im trying to create a report to print checks.

i am having hard time because information on the report must come from different table.

here is a layout i would want.

account #: 6/26/06 (date) $100.00 (amount)

===========One Hundred Dollars & No cents===

address here


account # and date has to come from table tbl_htran, address needs to come form tbl_payee, and currency with words needs to generate (i have a script..).
is this even possible? can someone please let me know if it is and if it is then how i may approach this?

 

[dhookom]

You should have fields in your tables that can be joined in a query for your check report's record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[wshs1]

i can use a query. i see.
how about the layout if you don't mind me asking..

 

[dhookom]

Can't you simply place the text boxes in the detail section where you need them? How is your report different from any other report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[wshs1]

well it's more like report/CHECK

like actualy check..

it has to fit accurately..

 

[dhookom]

You can move and size your text boxes almost anywhere you want on the report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[wshs1]

sorry to bother you and slow but..

is there a demo program that involves printing checks that i might can use as a reference?

 

[wshs1]

also.. since i can't use "event" in report, how would i imply "convertCurrencyToEnglish" function?

 

[dhookom]

You need to tell us what is different between printing a check and printing any other report. Also, what do you mean by i can't use "event"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gearhead03]

I'll let dhook handle the currency to english part. However the lining up perfect part can be easily handled by trial and error. Setup the report/check, print one. Wherever it's off move it around, print another. etc, etc till you get it right. might have to use 5-6 checks but it's simple and effective!!!!

Mark A. Kale

 

[wshs1]

i got the currency to english part working thx to u guys.
trial and error.. guess that always works lol