Converting a form to a report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a rather complicated form, based on one table, that is made up of a
number of tabcontrols which all contain forms based on various tables.
Basically I want to create a report of all the controls on my form, whether
or not they contain data. Is there a quick way to convert my form to a
report or will I have to create the report by creating one main report and a
number of subreports, that will take hours!!!
Thanks
Tony
 
I have a rather complicated form, based on one table, that is made up of a
number of tabcontrols which all contain forms based on various tables.
Basically I want to create a report of all the controls on my form, whether
or not they contain data. Is there a quick way to convert my form to a
report or will I have to create the report by creating one main report and a
number of subreports, that will take hours!!!
Thanks
Tony
Click to expand...

You won't like this answer, but I believe you are stuck with creating
your report the hard way.

-Kris
 
UGH! I thought that was the case. I thought I'd seen a mention of a utility
that did this but maybe I'm mistaken.
Thanks anyway
Tony
 
UGH! I thought that was the case. I thought I'd seen a mention of a utility
that did this but maybe I'm mistaken.
Thanks anyway
Click to expand...

Oh, it could be out there - I've just never heard of it.

-Kris
 
You can right-click on each form in the database window and SAVE it as a
report.
Then you can add each of the saved reports as sub-reports to a main report.

WARNING: THIS WILL GIVE YOU VERY UGLY REPORTS.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thanks John didn't know that. Have tried and with a little bit of
experimenting it will give me what I want.
Tony
 
Back
Top