Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

Question about modifying modules.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff - 23 Mar 2007 16:18 GMT
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 - 23 Mar 2007 16:37 GMT
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.

Signature

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."

>I know it is a simpleton question, forgive my noobness.
> I (obviously) know nothing about creating modules. the "for dummies" books don't even
[quoted text clipped - 13 lines]
>
>   Jeff V.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.