auto report

[Joanna_gr]

Is it possible to create a form and let a user to select from fields of a query and then by pressing a button automatically create a report in the design i have defined? Something like autoreport but with a more complicated design.

 

[Norie]

It is possible. But it could be quite complicated.

What exactly do you want the user to be able to do?

 

[Joanna_gr]

i noticed that there is an auto report option but the format is not what I want and a simple uses will not be able to handle this. So this is what I have in my mind.
New form with all fields from a query. Each field has a check box beside and I ask the user to select what fields he wants to add to his report. Then press a command button and a report opens with the selected fields but in the format I have previous defined. That's it.

 

[Tanis]

Have a look at Helen Fedema's site. Look for Code26.zip. This may help and point you on the right direction.

http://www.helenfeddema.com/CodeSamples.htm

 

[Joanna_gr]

thanks for this. Looks like what I want though it seems a bit complicated and it'll take some time to make it work with my project. But Thanks. Very interesting site

 

[Joanna_gr]

hi again. i hope that someone may help me more on this. I tested the proposed code but it's not quite what I need. I was wondering if there is a way to make a form where to choose a report "template" have a listbox to let a user choose all the fields he needs to show on his report and maybe a filter to a field. I want this cause I found it a bit complicated to build a report from the beginning as each time I have to change all the fields according to the fields I want. Can you help me on this? Or maybe a macro or something?

 

[Tanis]

Have a look at this site, it may be more like what you are wanting to do.

http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

 

[Joanna_gr]

Thanks Tanis. On a first look looks like what I want to do. I only wish I can make it work with my object. Thanks again!

 

[Joanna_gr]

Simply the best site i've ever introduced to A million thanks

 

[Tanis]

My pleasure.