Mike Wolfe - No Longer Set (Page 56)

Reports

PreviewReport Function

This custom function is the simplest and safest way to preview reports in any Microsoft Access application.

Reports

Future Compatibility

Use this trick to support future functionality while still getting your code to compile in older versions of Access.

Reports

Avoid the Cascading Maximize

Prevent a full screen report from forcing the calling form to be maximized with this clever workaround.

Reports

The 'OpenReport' Action Was Canceled

Does it annoy you that using the Report NoData event as Codd intended results in a runtime error? Because it annoys me.

Reports

OpenReport Shows Wrong Data

Calling DoCmd.OpenReport on a report that's already open will not update the filtering on the report. You have to close it first.

Reports

Previewing Reports

That sound of your printer warming up means you forgot the acViewPreview flag again. You're better off avoiding DoCmd.OpenReport entirely.

Reports

Report Annoyances

Five things I hate about the default behavior of DoCmd.OpenReport.

Version Control

Peace of Mind from Version Control

"Do you want to save your changes?" No, not if I just added temporary debugging code. But, Yes, if I also added production code. What to do?

Watches

Break When Value Changes

When debugging VBA, you can watch an expression and halt code execution whenever its value changes. Let's explore exactly how that works.

Watches

Break When Value Is True

When debugging VBA, you can watch an expression and halt code execution as soon as it evaluates to True. Let's explore exactly how that works.

Watches

Watch Expression

A deeper than necessary dive into the exact expression evaluation behavior of the basic "Watch Expression" in VBA.

Basic

Watching and Waiting

Careful what you watch for! Monitoring changes to a slow expression can grind your debug session to a halt.

Code Library

How to Set a Breakpoint Inside of an Access Query

Did you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.

Commentary

Reducing Lost Code Recovery Time

How do you reduce your recovery time when you've lost a bunch of code you just wrote? To misquote Bart Simpson, "Version control, my man."

The Extra Resume: Revisited

Pre-staging the extra Resume means, "there's no code to change when debugging." But is that really a good thing?

SQL Server

Brent Ozar: Date Table Fan

Brent Ozar, legendary SQL Server guru, makes his case for using a "Date Table." The video is all done in T-SQL, but the concepts apply equally to ACE backends.

Commentary

Recovering From Code Loss

Access just crashed while you were writing code. When you last saved will determine how long it takes to recover, but it's not a linear relationship.

Basic

The Extra Resume

Want an easy way to jump to the line that raised the error AND avoid the infinite loop time bomb? Add an extra Resume.

Basic

The Danger of Do Loops

If you're going to write a Do Loop, don't forget to update whatever it is you're using to break out of said loop. And, oh yeah, save before testing!

Code Library

Looping by Month: Loop Until with DateAdd

Reader Francesco Foti writes in with his own solution to the Looping by Month challenge.

Code Library

Looping by Month: Lookup Table

Have I ever used this method? No. Can I imagine a situation where it could be useful? Maybe. Should I write an article about it? Sure, why not.

Code Library

Creating a Monthly Lookup Table

Having a table where each record represents a single month can come in quite handy. Let's create such a table.

Code Library

Looping by Month: Custom Functions

By using a couple of custom functions, we can write very readable loops that iterate one month at a time.

Code Library

Looping by Month: DateSerial

The first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().

Code Library

Sticky Wicket: Looping by Month

Some programming problems are difficult to solve. Others are difficult to solve clearly.