how do I print only the current record in access

[lazyj]

in office 2007, Access, how do I print only the record I am viewing or have
just completed. I also need to e-mail the same record. I find it hard to
believe that the only option is to print all records every time, there could
quite litterally be thousands of records in one database.

 

[Albert D. Kallal]

in office 2007, Access, how do I print only the record I am viewing or
have
just completed. I also need to e-mail the same record. I find it hard to
believe that the only option is to print all records every time, there
could
quite litterally be thousands of records in one database.

Are you talking about data entry in a form? The best way to accomplish this
goal is to build a report that lays out the fields and information exaclty
the way you want.

You then simply place a button on the form and behind that button place the
following code:

me.refresh
docmd.OpenReport "name of reprot",,,"id = " & me!id

So as a general rule you'll use a report to print out information, and
therefore you should design and layout report to accomplish your goal.

If your entering data directly into a table, then what you must do is select
the row you want to print, and then office-buttion print. You notice
carefully
in the print dialog box there is an option to print the current selection
(which could be many records, or hopefully in your case the currently
selected
row).

 

[lazyj]

Thank you for your response, unfortunately it serves to remind me of just how
ignorant I am. I fail to understand what this "button", is and where do I
get it and what is meant by"placing your code behind the button". I have
compiled a report from a form, but please, can you take me step by step
through what I need to do to print it as I have several forms and reports I
need to be able to print and e-mail. Thanks in advance and i hope I have
stated my problem clearly.

 

[Tom Wickerath]

How to print only one page of a multipage report
http://www.access.qbuilt.com/html/reports.html#PrintOnePgOfRpt


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Richard]

how do I print only the record I am viewing

http://allenbrowne.com/casu-15.html

Richard