I would like to be able to drive the Data Report Designer programmatically.
I can do simple tasks:
If you setup TextBoxes on the DataReport1 and set their DataField property to the name of the field in the rs recordset and then:
Dim MyReport as New DataReport1
Set MyReport.DataSource = rs
works and shows the report as expected.
However I cannot get it to work with report sections. I guess this is beacuse the DataMember is not being setup.
However I do not want to setup loads of Commands in a Data Environment Designer.
Has anyone got any examples of code which DIRECTLY (not DataEnvironmentDesigner driven) uses DataReporter using code.
The reason I need this is I build recordsets on the fly using dynamic SQL and although I could create and drop commands I actually have the disconnected recordsets available. All I want to do is use these already available recordsets as a feed to DataReport. I do not want to do work already done twice and the recordsets are already available.
While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC. I didn't post completely correct code o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…