Lesson 6 Dcount Error on CheckRegBatchPrintF - How To Build a Complete Check Register With Multiple Accounts, Printing, Reports, and Charts in Microsoft Access


	Back to Check Register Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Lesson 6 Dcount Error on CheckRegBatchPrintF

Tannim Hallman

12 months ago

In the batch print form, the select all and unselect all buttons seem to work but the print selected button throws a compile error. I've triple-checked to make sure my code matches Rick's but maybe I'm missing something or have a typo I'm overlooking.

	Tannim Hallman OP @Reply 12 months ago

	Kevin Robertson @Reply 12 months ago
The error message tells you the problem. Access is expecting a max of 3 arguments. You have 4. `X = DCount("*", "CheckRegT", "ToBePrinted=TRUE And AccountID=" & AccountCmb)` Note: DCount should never return a null so there is no need for NZ. If there are no records the function will return a 0.

	Tannim Hallman OP @Reply 12 months ago
Thanks, Kevin. He actually hits that snag and fixes it later in the same video. I must learn to watch the whole lesson before I panic.

	Jeffrey Kraft @Reply 12 months ago
Remember he leaves those "mistakes" in the video because if he makes them so will you!!!

	Richard Rost @Reply 12 months ago
Sometimes intentionally. Sometimes... not so much. LOL.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Check Register Seminar Lessons.

Next Unseen

New Feature: Comment Live View