chuckcoleman's latest activity
-
Cchuckcoleman replied to the thread Inserting multiple rows into an email created by VBA.Thank you. I’ll try your suggestion tomorrow morning.
-
Cchuckcoleman posted the thread Inserting multiple rows into an email created by VBA in Modules & VBA.Hi, I have been using VBA to send an email for several years now. The email is generated from a form where payments are inserted for...
-
Cchuckcoleman replied to the thread Having trouble getting a report to use two different recordsets.Hi MajP. I couldn't use the same query because I created a new table that became the criteria for one of the two queries by joining it...
-
Cchuckcoleman replied to the thread Having trouble getting a report to use two different recordsets.Hi Pat, your feedback worked! Thank you, I always appreciate your clarity. As you indicated, the biggest issue I had was not placing the...
-
Cchuckcoleman replied to the thread Having trouble getting a report to use two different recordsets.Gasman, I don't understand your question. I set rs100 to one of the queries and rsAll to the other query. in the DoCmd.OpenReport I open...
-
Cchuckcoleman posted the thread Having trouble getting a report to use two different recordsets in Modules & VBA.Hi, I want to open a report and use one of two different queries based on the value of a field in a form. In the code below UseTop100...
-
Cchuckcoleman replied to the thread Invalid Use of Null.I eventually found the problem. In that form I had a Mouse Down event that I overlooked in a different module than my original post. In...
-
Cchuckcoleman replied to the thread Invalid Use of Null.I moved the break point to a MsgBox immediately after the DIM statements and no change in what I see in the Editor and the Invalid Use...
-
Cchuckcoleman replied to the thread Invalid Use of Null.When I set the break point on the "On Error GoTo line", which is even before the DIM statements, why do I get the Invalid Use of Null...
-
Cchuckcoleman replied to the thread Invalid Use of Null.Gasman, I could probably use some guidance here. In the Editor I clicked on the gray vertical bar immediately to the left of my "On...
-
Cchuckcoleman replied to the thread Invalid Use of Null.OK, I tried NauticalGent's suggestion and Pat Hartman's suggestion. Neither suggestion worked. Here's what's weird. When I put the...
-
Cchuckcoleman replied to the thread Invalid Use of Null.First reply before I examine the other suggestions to look at. When I put a MsgBox immediately after the DIM statements and then set a...
-
CHi, this has been driving me nuts for a day now. I have a form called Revenue Input Form. When a payment is received, the Lot Number is...