Form for Report Generation

[lushh]

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

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.

 

[Uncle Gizmo]

you would be far better off generating your reports in MS Access, MS Access has some brilliant report generating features, and there is also a report viewer that is free and anyone can view the report you generate With the free viewer.

 

[lushh]

you would be far better off generating your reports in MS Access, MS Access has some brilliant report generating features, and there is also a report viewer that is free and anyone can view the report you generate With the free viewer.

hi uncle gizmo. thanks for the reply, but my boss requires me to generate reports on excel format. i need any advice since i will be presenting a demo system on friday. i will definitely appreciate all the help anyone can give and i do apologize for the inconvenience.

 

[Uncle Gizmo]

Well, then I think you need to look at the transferspreadsheet option. I have done a quick search in google See link above.

 

[lushh]

Well, then I think you need to look at the transferspreadsheet option. I have done a quick search in google See link above.

thanks a lot uncle gizmo. i'll try to search for that.