Question about modifying modules.

[Jeff]

I know it is a simpleton question, forgive my noobness.
I (obviously) know nothing about creating modules. the "for dummies" books
don't even enter in to it, and the Access Bible just overwhelms me with
info.
But I have been able to modify some modules by cut and pasting info into
them from wizard created products.
A simple example is
I set one control button to print a report. and I set a second button to
print an envelope with its corresponding
address info.
I cut the command from button 2 and pasted it into button 1 so it prints
both with one comand button.
My question is, can a pause or continue command be inserted between the 2
commands, so I can place the envelope in the print tray?

Thanks again for any help regarding these odd requests.

Jeff V.

 

[Al Campagna]

Jeff,
In Report Design, select Page Setup, and set you printer for manual feed.
Unfortunately, that setting will apply to bothe the letter and the envelope. Hit the
Feed button on your printer = the letter prints, insert your envelope and hit Feed again =
the envelope prints.
I'd try them as separate reports, with the letter set to auto feed, and the envelope
set to manual feed.
I would think you could also...
DoCmd.OpenReport "Letter"
DoCmd.OpenReport "Envelope"
together. Letter comes out automatically, letter waits for you.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."