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 / New Users / October 2005

Tip: Looking for answers? Try searching our database.

Help with print area maybe?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Christle - 10 Oct 2005 21:36 GMT
Hello,
I'm very new to access.  I have a company that has a data base for open
projects.  They print this out each week for a weekly meeting and it can be
about 50 or more pages.  In order to keep this down to a dull roar they
delete the records that contain closed projects.  I'm sure you can see the
problem in deleting these records when an issue arises and how helpful it
would be to refer back to the record with the project information.

I would think there should be some way to hide the closed records or set the
print area to print only the open projects.  Anyone know of a way to
accomplish this?

Thank you so much,
Christle
Rick B - 10 Oct 2005 22:02 GMT
Your report should be based on a query that pulls all the appropriate
records.  Just change that query to exclude any records with an entry in the
closed date field.

Signature

Rick B

> Hello,
> I'm very new to access.  I have a company that has a data base for open
[quoted text clipped - 12 lines]
> Thank you so much,
> Christle
Christle - 10 Oct 2005 22:56 GMT
Thank you so much Rick, I've given the information to the company and if I
hear back I'll let you know their success.  Thanks for pointing out the
obvious :))

Christle

> Your report should be based on a query that pulls all the appropriate
> records.  Just change that query to exclude any records with an entry in the
[quoted text clipped - 16 lines]
> > Thank you so much,
> > Christle
 
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.