Hi,
I am wondering if anyone can help me here. I have an Access 2003 adp project. In it I have a search form/subform. The form provides controls for the user to select search criteria, the subform is a datasheet that displays the search results. I have designed this as an unbound subform, I set it's recordset property in VBA code.
However, I am finding that I cannot export this datasheet to excel, nor can I print it. These functions only seem to work for bound forms. My subform datasheet has the columns ordered in a certain way (across the top) and some columns are hidden so I would really like to be able to export it (DoCmd.OutputTo) rather than copy trhe underlying recordset to excel which outputs all fields in wronmg order etc.
So is there a way to export and print unbound forms / datasheets? I'm really stumped on this.