Im trying to write a module in Access using Printer.? and the Printer.? isnt regognized.

Printer.Font size
Printer.Print some text

Any tips or suggestions?

quote:

---

BobBarker wrote:
Im trying to write a module in Access using Printer.? and the Printer.? isnt regognized.

Printer.Font size
Printer.Print some text

Any tips or suggestions?

---

quote:

---

BobBarker wrote:
Printer.Font size
Printer.Print some text

---

I have found that Printer.Print isnt supported in Excel or Access

quote:

---

BobBarker wrote:
I have found that Printer.Print isnt supported in Excel or Access

---

Hi
I'd recommend against writing your own printing module in Access - the reason being that it has on of the most powerful reporting engine I have ever seen built in.
But.. you can print onto the report canvas (me.print) in an event.
and you can print directly to the printer using GDI.
If you tell us more about what you want to achieve, we can probably come up with something more helpful

Regards
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Long Story Short:

I get 3 files from our customer. each file is about 3 megs. Within each file are specific topics.

I wrote a code back in the 90's that will bust these files up into the specific topis, with in specific folders, by months.

Then I have another code that a user uses to print a specific topic. To print a topic I have to put an escape code at the start of the print routine, so the text will fit on the page.

This code is
str$ - chr(27) + "&k2s"

This code was writen in QuickBasic (eeek)

Actualy the whole thing needs to be rewriten in VBA, but I dont have VBA or do I know much about it. Im using Access for the modules, with what VBA I do know.

ah..
suggest the following:

create a text file called "escape_prefix.txt" or something and put only the prefixed escape codes in it.
Then, the following commands :

copy escape_prefix.txt+myfile.txt mytgt.txt
print mytgt.txt

hoorah for DOS.



What version of Access are you running?


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Yes that would work for file 1. Put the plot thickens

File 2

Has files we will call Items, within the Item file there are Recipes.  My old code would print the Item file, as it read it, line by line, finding the Recipes and the print them. The Recipes can have Recipes as well

Thus the need to print the file as it reads it.

I use Access and Excel 2002

Hmmm
Import the files into access
create a report to print them in a pretty way

To Import a text (delimited) file into access.
open the database
right click no the tables
get external data
change the file type to your file type and select your file
follow the onscreen prompt(s)
repeat for all files as necessary

i'll attempt to knock you up a database tomorrow when i'm near my proper pc.
Can you post up a couple of lines from each file?


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

The files are not realy formated for importing, but if you want to mess with it, I can send you several files.

email me at robert.barker@lsgskychefs.com  (I might be easier) the files on all on the work laptop