Search results

  1. C

    Need to only print in Black & White

    It's a Ricoh MP C307 PCL 6 printer.
  2. 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...
  3. 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 =...
  4. C

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

    Gasman, I'll continue to work on this. Unfortunately, I need to leave for several hours. More tonight. Thank you.
  5. C

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

    I'm sorry to be a PIA but I'm still fighting this issue. The bottom line is that it never moves to the next record. The record source is a simple table with three records in it. You can see from the code that I have a lot of MsgBox's in it so I can see what's going on. The first MsgBox confirms...
  6. C

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

    Pat and Gasman. I apologize for my late reply. I was called away for several hours. I apologize. Gasman, you said "I just copied a block of code I used to use, so just look at the logic and where I created a new email each time." I don't believe you posted that code here. If you could, that...
  7. C

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

    Pat, I put it on the Subj line and set the breakpoint there. I hit F8 and I also clicked on Debug, Run to Cursor or Debug, Step Into. Nothing happens. I'm sure this is 100% pilot error but nothing happens. Gasman, by having Do While Not rs.EOF, olMail.To = rs.EmailX, olMail.Send and...
  8. C

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

    After toggling a breakpoint if I type the procedure name in the Immediate Window, SendEmailsX_Click, I get, "Compile error: Expected procedure, not variable". However when I compile the code I don't get any errors.
  9. C

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

    Hi Pat. Again, maybe I'm doing something wrong. In the VBA editor I clicked on the line olApp.Quit and went to Debug, Toggle Breakpoint. It highlighted that line and put a dot to the left of that line. I then use F8 or Debug, Step Into or Debug, Run to Cursor and nothing happens.
  10. C

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

    I'm sure I'm doing something wrong, but there isn't any highlighted line in the Debug mode.
  11. C

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

    This is a continuation of my original thread. I overcame the problem by having the Query do a Make Table and then using that as the "query". The issue I'm now having is that when I have Outlook .Send the emails, (my table only includes three records), it only sends an email to the first record...
  12. C

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

    Thanks Minty. The query does have criteria that is based on an open form. The form is open. If the form has data that is significant to the query, what is your suggestion to overcome this?
  13. C

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

    Hi, I have a relatively simple vba code but it generates the above code. I believe the problem is on the line that begins: Set rs = CurrendDb.OpenRecordset("Temp Daily Table Query for Form") What am I doing wrong? Chuck Private Sub SendEmailsX_Click() On Local Error GoTo SendEmailsX_Error...
  14. C

    Solved DLookup with criteria based on a text field on a form

    [SOLVED] Sometimes you can learn something every day. For readability I had in my DLookUp criteria, " space ' space ". When I removed the spaces, the criteria worked. Gasman pointed this out early on and I just didn't pay enough attention to it because I didn't think it mattered. It does...
  15. C

    Solved DLookup with criteria based on a text field on a form

    Josef P. I had the CriteriaString before I established EmailLU. After moving it I do get: [LotNbr] = 19. After that msgbox I still get Invalid Use of Null immediately before the msgbox that starts "22-....". Dim EmailLU As String Dim EmailLU2 As String Dim CriteriaString As String...
  16. C

    Solved DLookup with criteria based on a text field on a form

    Do you mean around the single and double quotes?
  17. C

    Solved DLookup with criteria based on a text field on a form

    Hi Josef P. It returns, [LotNbr] ' '. Null. What I don't understand is why all of the "test" msgbox's ahead of this result return 19 which is the number I've entered into [LotNbr].
  18. C

    Solved DLookup with criteria based on a text field on a form

    Thanks guys. I just have to believe the problem is that the criteria and the field in the query are text. It's hard to tell in a MsgBox when you see the value if it's right-aligned, (number), or left-aligned, (text). The data is in the query so there absolutely should be a match. Here are a...
  19. C

    Solved DLookup with criteria based on a text field on a form

    Hi, I've been going nuts trying to get this to work. In my form, in the After Update for a control, [LotNbrX], I want the value in that control to be used to establish the value of another control on the form called [EMailX]. Note: [LotNbrX] is a text field. If I use a MsgBox to test this...
  20. C

    Solved Hyperlink opens wrong file

    Thank you everyone for contributing. I finally got it working. First, I added a new field to the underlying table and called that field, RawFileName. Then, early in the code I declare "DateForQuote". As soon as I establish it, which is a combination of a job number, date and time, I set the...
Back
Top Bottom