Report Generation Problem 1

[lushh]

hi guys. i am currently working on a human resources information system. i am currently using ms access 2003 and the report form looks like this:

http://i114.photobucket.com/albums/n258/lushh_16/reports.jpg

the function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed in ms excel. the problem is that i don't know the VBA code that will perform this function. i read books about access, but unfortunately i can't find the exact answer to my question. so, if anyone could give me some idea on where i can find sample codes for this function, i would very much appreciate it. thanks in advance.

 

[PHV]

Have a look at the DoCmd.OutputTo method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886