pls help me guys! I need help regarding report generation with VBA coding

[kosala1981]

I need to create an access report uisng VBA code. i want to be able to create a report name and save it and also create labels and text boxes in the report using the vba code and those fields should come from the table in the database. and data of the table should be displayed in the report under each field in the report as well.

im new to access and vba. and i want to get this job done quickly.someone please please help me on this and it would be really greatfull. i hope there'll be someone to help me........

 

[ted.martin]

It is unlikely that you will get a complete answer from here. I suggest you learn a bit of VBA first. There are several good books around and self-taught does work.

 

[kosala1981]

customizable reports using cross tab query..

well my requirement is to generate customizable reports.i've already developed a form having four combo boxes. two of them filled with two tables data and other two filled with field names of tables. so when a user selects these items from the combo boxes then selected items go as parameters to a Cross tab query and created a recordset from that. i've created a temporary table and insert data into that table using that Recordset(Cross tab query). now i want to create a report from that table. i have a code taken from the Internet that would create a report using vba code. but i've tried it but it gives an error saying that "u must be in design view to create controls". so im stuck at this moment.

so is there some other ways to do this and if so please someone guides me to do this report......!