Search results

Thank you. I’ll try your suggestion tomorrow morning.

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 property lots. Things have changed and I now need to include in the email information how much the payment was for each lot. For instance, owner ID number 21 owns...

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 to other tables. This is kind of an experiment where I had Access pick on a random basis 100 customer ID's where those clients/ID's don't have an email address...

Hi Pat, your feedback worked! Thank you, I always appreciate your clarity. As you indicated, the biggest issue I had was not placing the code in the On Open section of the Report. I looked at a lot of examples online and none of them suggested or addressed that. Thank you again for your clarity...

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 the right report and I think I'm setting the recordset to one of the queries after the preview, two commas and then the strRecordSource. The WHERE statement is...

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 looks at the value of a field using DLookUp on a form. Based on if that value if True I want to use the query "Startup Letter Query-2-Top100". If the value is...

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 that module I had two lines: EmailLU2 = DLookup("", "[Email for Receipt]", "[LotNbr]= '" & Nz(EmailLU) & "'") OwnerLU = DLookup("[Owner]", "[Email for...

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 of Null continues. Frustrating!

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 immediately.

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 Error GoTo..." line. A red dot was placed there. When I click on the "Print" button in the form I get Invalid Use of Null. I click on OK which brings the Editor to...

OK, I tried NauticalGent's suggestion and Pat Hartman's suggestion. Neither suggestion worked. Here's what's weird. When I put the MsgBox immediately below the DIM statements that says, "Hi Chuck", when I run the code by clicking on the button the first thing I get is "Invalid Use of Null" and...

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 break point there, I immediately get the Invalid Use of Null error. I'll now look at the other suggestions.

Hi, 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 entered along with two other items and the amount of the payment. If the customer has an email address, there is a button on the form that displays "Email" and...

I've rewritten my report to have the second sub report NOT nested in the first sub report. I think I can make this work, fingers crossed. Thank you all for your help.

I found this that might be the cause: Error 2191 - You can't set the recordsource property after printing has started | Access World Forums (access-programmers.co.uk) However, I'm not sure how to do this: "The solution was to create a global variable as a flag to indicate the main report was...

I do have the Master and Child Linked Fields filled out. When I run the code I see the MsgBox message twice and I then get an error: 2191, "You can't set the Record Source Property in the print preview or after printing has started". I don't know why it appears to cycle twice through the code...

Ok, I'm pretty sure the problem is because the report in question is a sub report to another sub report on the main report. If I comment out all code, (I actually put "Exit Sub" as the first line in the code), and I hard code the query and then open the report by itself, (without the main...

OK, I've made some progress. I eliminated the error messages by using DIM in the Me.RecordSource. I also added a MsgBox for each condition to make sure I understand if the Re-Invoice Form is open or not. That works. However, I still don't get any data in the sub report. Private Sub...

Nope, same message on the Open event.

Pat, yes your are correct. If I open the report from the Re-Invoice form I want to use the [Balance Due-Report-Paid-3-Reinvoice] query. If the Re-Invoice form isn't open and I want the report from a different form called Invoice Form, I want to use the [Balance Due-Report-Paid-3] query. I tried...