Database Skills required

[minux]

Wondering if anyone here has any knowledge using MS Access, when i say knowledge, im talking mor ebeyond the point of simply building a database..if you do, i need help

[sixshooter]

Wondering if anyone here has any knowledge using MS Access, when i say knowledge, im talking mor ebeyond the point of simply building a database..if you do, i need help

Been couple of months since I was tested on it... what are you trying to do ?

[reecey]

yeh state the problem and let us help you

[minux]

Sorry, Just need some help in being explained how to print the report(rather than all 5000) from the form im working in in 2003. I also need to be able to email a single report from the same form(rather than 5000) and also applying a filter form to sort through records and only display certain data...Ive searched the net but it seems the questions that have been answered are for very advanced people. I am planning on doing a advance course in access, but agh for now this is driving me nuts

[sixshooter]

Make yourself a query to gather the info you require from your database.
Then generate a report using that query for it's input.

Not sure on the email stuff...

[minux]

Make yourself a query to gather the info you require from your database.
Then generate a report using that query for it's input.

Not sure on the email stuff...

Im aware of how to generate the report, i have all that, i just would liek to know how to generate the code behind a command button that will only print off the one report

[azkwazere]

Your query should only produce one report. The idea of a query is to pull out specific information into the one report. ie your need to refine your query so that it is only to the one page. its like a having a search with no peramiters. You could also just say "print pages 1 to 1" in the printer options..?

aZk.

[minux]

Your query should only produce one report. The idea of a query is to pull out specific information into the one report. ie your need to refine your query so that it is only to the one page. its like a having a search with no peramiters. You could also just say "print pages 1 to 1" in the printer options..?

aZk.

Yeah, i could do that, but its a pain in the ass when your talking hundreds of records, i want to be able to enter the data into a form and from there hit a command button that says print this forms report only

[minux]

Ok, problem is solved, i can now print a single record from a form!!!! Thanks for everyone who replied here