Search results

Hi. Recently converted A97 db to A2003 in A2003 file format. In more than one instance I have set up and removed breakpoints, even tried using remove all breakpoints, recompiling db, and the code still halts at that point even though the breakpoint has been removed. Has anyone else...

Hi. I am looking to automate output from access reports (97 & 2003) to Microsoft Office Document Image files. Within the driver I see you can specify the default folder for files that are created. But if anybody can help regarding specifying actual document file name so that I can avoid the...

Can you not just strip those records out of your query using criteria?

Running Totals in a form One possible solution, use the iif function within your expression in your calculated control to only include data up until the date of the current record.

Page Header In the on format event of your page header include code based on the fields you want to change your header on. eg. Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page / 2 = Int(Me.Page / 2) Then Me!Label1.Caption = "Even" Else...

Subreport Hi Pat. Sorry not in this case, besides the report runs fine if I reduce the font size. Definitely not down to the data.

Hi. I have posted this problem before, with unfortunately no response. I wasn't suprised because of was very vague. When you see the problem attached you will understand, I hope. Having done some more investigation this is my problem so far. I have a fairly complex report with subreport in...

Repeat Headers Make sure your headers are in a sorting/group header section and that the section is set to repeat in the properties. This should give you what you are after...

Treeview Control It may not solve your reporting issues, but the Treeview control provided in Access, gives you the functionality of the Windows Explorer engine to display/edit your own data. I beleive you can even download from microsoft a wizard for populating the control.