borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2009 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Access Database)Next Topic (Search range) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Print report base on search on form
Poster Message
mayanair
Level: Guest


icon Print report base on search on form

how do i print a report based on a search that i made on a form...pls help asap...thanx

[Edited by mayanair on 11-07-2003 at 09:18 AM GMT]

11-07-2003 at 01:18 AM
| Quote Reply
joanneM
Level: Guest

icon Re: Print report base on search on form

Create a form or report from filtered records
With the filtered records displayed, click the arrow next to the New Object button on the toolbar.  

this is the button which has a table icon on it with either a lightning bolt or a star - it is a drop down button and from it if you select the book icon  you get to the autoreport wizard


To use the AutoForm or AutoReport Wizard, click AutoForm or AutoReport.


To specify the type of form or report you want to create, click Form or Report, and then make your selection.
The new object uses as its record source the table or query in which the filter was created, and it inherits the filter.

Complete the design or make any other changes you want to the form or report, and then save it.
Notes

If a sort order was specified in the underlying table or query, the new form or report will use it.


If you subsequently change the filter in a table or query, it has no effect on a form or report that was based on a filter you created previously in that table or query.


This was taken from  help


regards

jo

11-07-2003 at 06:43 AM
| Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Print report base on search on form
Previous Topic (Access Database)Next Topic (Search range) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2009 Andrea Tincaniborder