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 / February 2007

Tip: Looking for answers? Try searching our database.

View Record one at a time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick - 21 Feb 2007 20:40 GMT
I have an Access database.  I'm not sure a form was created for it.  But I
need to view and print each indivadual record.  

Can someone tell me how to so this?
BruceM - 21 Feb 2007 20:58 GMT
Use a report to print records.  You can use a wizard.  From the database
window (it shows up when you open Access; it has tabs for tables, forms,
etc.) click the Tables tab.  Click the table on which you wish to base the
report, and click Insert > Report.  Choose the report wizard.  Don't use a
grouping level for now (although that is one way to do it).  When the report
is complete, open it in design view.  Click the detail section.  Click View
> Properties.  On the Format tab, next to Force New Page, choose After
Section.  Maybe you will do this in the Page Footer rather than the Detail
section (assuming the wizard creates a Page Footer).  Experiment with it a
bit.
You can also group the report by a field in the report that is unique in
each record (or by any other field, for that matter, but without any
information about your database there is no way to offer details).  The
wizard will offer to do that.  In the Group Header (or footer) you can use
the same Force New Page property as already described.

>I have an Access database.  I'm not sure a form was created for it.  But I
> need to view and print each indivadual record.
>
> Can someone tell me how to so this?
 
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.