access 2003. printing a table

[smiler44]

I want to print a table after it has been filtered/quried.

I can print the whole table by highlighting it's icon and pressing the print icon but this prints all the table.

How do I print only the records that match the search criteria? I would like to print them so they look like the table.

thanks
ian

 

[Alansidman]

Why not create a query. Filter the table in the criteria section of your query. Once you have your results, save the query. Export your query to Word or Excel and print it. It will be in datasheet format. Or once you have your query open in datasheet view, select print.

Alan

 

[smiler44]

Hi Alan,
Thank you for the reply
Exporting to word or excel seems long winded. Does datasheet veiw display like an excel spreadsheet, rows and coloumns? I think this is a table in access.
Would it be possible to have a form with text boxes and labels on, query/sort the data via the form which will only display one record but have VB code associated with a command button that will print the table with only the required records?
I'm new to access so this may seem a silly question

Ian

 

[Alansidman]

Datasheet view displays in a manner similar to an excel spreadsheet. create a search form and use it to base your query.

Here is a tutorial on how to do that.

http://www.datapigtechnologies.com/flashfiles/searchform.html

You can add a command button using the wizard to generate the query and have it print.

Alan

 

[smiler44]

Alan,
thank you for the reply. I have book marked the tutorial. I have created a command button and with the help of the wizard can now print my table after it has been queried. A step in the right direction.

I have modified this reply. The very first thing I looked at at the web site you gave me answered a question I was asking. How to see the VB code behined a Macro. Fantastic, I hope I can now use the code in a VB project

thank you very much for pointing me to the web site
smiler44

 

[Alansidman]

My pleasure. Glad that its working for you.

Alan