I have an application that has a custom query builder with a nice user interface. The resultset is returned in a grid view in the detail section and usually has a horizontal scroll bar depeding on how many fields they include.
I am trying to find a way to print the resultset without actually formatting a report object and calling that. Is there anyway to do this? It currently calls the docmd.runcommand accmdprintpreview, but this cuts off some of the columns in the resultset. Any input would be helpful...
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…