Database Skills required

minux · #1 27-01-2006, 02:21 PM

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 · #2 27-01-2006, 04:49 PM

Quote:

Originally Posted by 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

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

reecey · #3 27-01-2006, 05:10 PM

yeh state the problem and let us help you

minux · #4 28-01-2006, 10:19 AM

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 · #5 28-01-2006, 03:30 PM

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 · #6 28-01-2006, 09:13 PM

Quote:

Originally Posted by 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...

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 · #7 28-01-2006, 09:46 PM

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 · #8 28-01-2006, 10:20 PM

Quote:

Originally Posted by 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.

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 · #9 28-01-2006, 10:36 PM

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