Building a text file in Access

[mtp]

I want to build a text file in Access. This text file which I will use to print out a check for broker. And I don't know how to start it, does any one know how? Please help!!!Thank you.

 

[mtp]

Pat, can you explain more for me please? I totally don't know how to do it. My program has to do these things: first print out a statement of list who need to pay, then after the statement will print out the check of that list. The format for the text file I want to do for the check print out has to look like below (it looks like just the way a regular check though, please note the address is change depend on who to write the check to):


* * SEE ATTACHED STATEMENT * *

$ 1,083.96

$ 1,083.96

SEA-MOUNTAIN INSURANCE BROKERS
131-2ND AVENUE SOUTH
EDMONDS, WA 98020



The old program was written in DBase (they used Check Register software to print out the check)and now I'm rewrote in our language here which calls Omnis and the last part of this program is to print the check and I'm thinking of using Access to build a text file in Window to print out. Is that make sense? Please help if you have any ideas. Thank you!

 

[mtp]

Pat, I have all the tables and queries to know what fields I need for. I tried what you said before and didn't get what I want. How do you build a text file then import into Access with a list of what you want to print out? Should I build a text file in Word? Note Pad? but then I couldn't get a list of what I want though. This is what I'm having troulble with. Or VB is a good start for building this file???

 

[Surjer]

What do you want you're "Text File" To look like?

 

[mtp]

The text file looks like the format above that I gave. And here's it again:

* * SEE ATTACHED STATEMENT * *

$ 1,083.96

$ 1,083.96

SEA-MOUNTAIN INSURANCE BROKERS
131-2ND AVENUE SOUTH
EDMONDS, WA 98020

All information should pull out from fields in tables and should print in a list of checks. Thanks for all your help, guys!

 

[Surjer]

1.Query the information you need
2.Build a report based on that query that has the Feilds all in the right places.
3.Output the Report To a text file using the Export Function...
In a Form It would look Likerivate Sub Command4_Click()
On Error GoTo Err_Command4_Click

Dim stDocName As String

stDocName = "Generic Report"
DoCmd.OutputTo acReport, stDocName

Exit_Command4_Click:
Exit Sub

Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click

End Sub