Search results

  1. C

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

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

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

    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 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...
  5. C

    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 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...
  6. C

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

    Invalid Use of Null

    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...
  8. C

    Changing the RecordSource for a Report

    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.
  9. C

    Changing the RecordSource for a Report

    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...
  10. C

    Changing the RecordSource for a Report

    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...
  11. C

    Changing the RecordSource for a Report

    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...
  12. C

    Changing the RecordSource for a Report

    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...
  13. C

    Changing the RecordSource for a Report

    Nope, same message on the Open event.
  14. C

    Changing the RecordSource for a Report

    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...
  15. C

    Changing the RecordSource for a Report

    Pat, I don't think loading in the order is the problem. If I just open the last sub report by itself, it should produce records. It doens't produce any records. As far as rtp to Nothing I thought that just cleaned up/discarded the report after it's created.
  16. C

    Changing the RecordSource for a Report

    Hi, I have a report that has a sub report and that sub report has another sub report. I have in the last sub report in the On Load property the following code. Also, in the Record Source property in the Data tab of the last sub report I have that as blank, nothing is there. When I test the code...
  17. C

    Need to only print in Black & White

    I ran a test on my own setup with a HP printer. Even though I change a printer setting in Windows to only print in B&W, Access prints in color. I can change the printing preferences for a report in Access and it will print in B&W, but the next time that report prints it reverts back to color...
  18. C

    Need to only print in Black & White

    It's a Ricoh MP C307 PCL 6 printer.
  19. C

    Need to only print in Black & White

    Hi. I have a customer that has a printer that prints in both color and B&W. Because of they way her supplier charges she only wants reports printed in B&W. I've changed the default printer in Windows, (which is the one reports use), to make if only print in B&W. However, it appears that Access...
  20. C

    Getting "The error 3061, Too few paramaters. Expected 6"

    Gasman, first, thank you for your continued help! It was very helpful. I finally solved the issue as to why I was only getting one email sent when there were multiple emails that could have been sent. The issue was pilot error on my part, what else, and I just needed to move, "Set olMail =...
Top Bottom