Recent content by CreativeDavid

I was. But had the output too in the wrong location. It was creating mayhem till I moved to on activate. Thanks again

Not quite but close enough... I ended up opening the report in acViewPreview from the form. Then in the onactivate method of the report I run the output to and this achieves exactly what I am aiming for. So in brief for those interested in words... I set up an SP to perform the work I...

Appreciate the thought. Part of the approach I am taking is avoiding (Access) tables completely. I am unsure if this will be completely successful, but so far with a lot of thinking in between, I have been successful. I am persisting the recordset via a class. In testing to date this is...

Tried that...same issue. Loads of blank reports. Iterates through correctly. I get the distinct impression there isnt enough time for the code to run to populate the report. As I iterate over the controls and tell them to bind to the recordset. Before deciding to post I was going to add a...

I hadn't thought of using that. Its amazing the acViewNormal doesn't work. It prints out blank files. Perhaps this approach wont?

Been playing with this for four days. Its been a very large struggle for me to grasp how to work around the limits on the application of the SP recordset into the report as the simplistic approach doesnt work. The approach I finally settled on was driven largely by this forum. Every search of...

Long time reader of this forum, and had lots of help from people here so want to start out by thanking you all for your help. Believe it or not I have been able to get around near every single challenge with your help in past posts. I have been making a kind of hybrid access mix. It is driven...