Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gbscobel

    Emailing letters to individual email addresses

    Well, believe it or not, I believe that is working now. I just tested it with emailing and I got 3 separate emails each with individual letters. I will have to play with it a bit more to get it fully integrated with my system but I can't thank you enough for all your time and patience with...
  2. gbscobel

    Emailing letters to individual email addresses

    Ok, I figured out the problem, since I added another form field to the query, I had to establish another parameter. Here's what doesn't make sense now. I have the query, Detail Report which establishes my recordset but the query runs off a form field which draws data from a recordset which...
  3. gbscobel

    Emailing letters to individual email addresses

    ...Forms![Print Reports]![Client] = rstStandardHours!Client 'DoCmd.SendObject acReport, "Hours Status", "PDFFormat(*.pdf)", rstEmail!Email, "", "", "Hours Status letter", "Attached find your letter", False, "" DoCmd.OpenReport "Hours Status", acViewPreview, "", ""...
  4. gbscobel

    Emailing letters to individual email addresses

    Thanks again for all the effort. I think I'm about done here. I removed the record source of the report, changed every field to rstStandardHours!field name, and when I run the procedure, I still get the error that 'The action or method is invalid because the form or report isn't bound to a...
  5. gbscobel

    Emailing letters to individual email addresses

    Ok, I was finally able to figure out that part of it and the recordset is returning information so that's working. So, you're saying I need to remove the record source from the report, replace every single field with rstStandardHours!'field name' and then try it?
  6. gbscobel

    Emailing letters to individual email addresses

    I've saved the form, I've saved the project, I've saved everything there is to save and it still won't let me step through the code. The red dot is next to Private Sub Command215_Click() and everytime I hit F8 or go to Debug, Step Into, it just beeps at me. I just can't believe it's this hard...
  7. gbscobel

    Emailing letters to individual email addresses

    The OpenReport syntax I got by doing a macro to open the report and then converted it to visual basic and copy and pasted it and it works fine if I replace the rstStandardHours.Client with an actual Client name so the syntax is correct. I can't remove the record source from the report itself or...
  8. gbscobel

    Emailing letters to individual email addresses

    I guess I'm still not sure how exactly the report is getting set to anything. I did what I think you said to do and it doesn't work at all. Here is the code I did based on your suggestion. When I run this, it prompts me for rstStandardHours!Client so I'm obviously still missing something...
  9. gbscobel

    Emailing letters to individual email addresses

    Okay, the query in question is not a problem, it's just that what I've sent you only has a limited number of records for a test, I didn't send the entire data set that gets parsed based on the date. I'm just not understanding this bit about putting a field on the form for the client and then...
  10. gbscobel

    Emailing letters to individual email addresses

    Ok, the database is on the ftp site again, ftp.qualitech.net, subdirectory Access. I'm not sure where exactly to put notes on my database. I sent you a barebones structure with my Print Reports form with the Sample Code button that runs the procedure. The Hours Status report is there which is...
  11. gbscobel

    Emailing letters to individual email addresses

    Gshen, You've been very patient and I appreciate all the help. Let me try to clarify the situation. 1. I have a letter I generate for my clients which list any support we have done for them over the month and gives them a balance of their support hours. The query this letter is based on...
  12. gbscobel

    Emailing letters to individual email addresses

    Ok, I think I have that figured out, runs without errors now on the query. So now I'm down to the emailing. Here is the issue. The query can and often does return multiple records for each client which makes up the detail section of the report. When I run this through the procedure just as...
  13. gbscobel

    Emailing letters to individual email addresses

    I'm sorry, I didn't realize it mattered and I wasn't passing any parameters to the query overtly however, there is a reference in one field to a field on the form. I didn't realize that had to be accounted for since the form in question is the one the procedure is being run from. How do I...
  14. gbscobel

    Emailing letters to individual email addresses

    When I try that, it tells me there are "Too few parameters. Expected 1
  15. gbscobel

    Emailing letters to individual email addresses

    Each customer should get their own report, I'm going to try to apply the email syntax to this and see if it works for a smaller group of records. I think part of the problem is I just realized the report isn't based on the table called report, but a query called detail report. I tried to...
  16. gbscobel

    Emailing letters to individual email addresses

    Ok, that worked. So that's a good start. I further was able to add a selection criteria for a specific client code and that worked too. So now I'm down to how to run the report based on the recordset and also how to reference the email address when I email it. I feel like we're pretty close...
  17. gbscobel

    Emailing letters to individual email addresses

    I guess I don't really know how to attach files here. I have uploaded the file test.accdb to my company's ftp site. If you go to ftp.qualitech.net and navigate to the Access folder, the file is there. There is just a table, a report and a form with a Sample Code button that has the event...
  18. gbscobel

    Emailing letters to individual email addresses

    Unfortunately, no matter what I do I can't get this to work. I even created a brand new database, brought over just the table, the report and the form with the button on it and when I try to run it, even without any parameters, it still just immediately hangs up while trying to run the report...
  19. gbscobel

    Emailing letters to individual email addresses

    This is the first time I've ever done any of this. The openreport command I got by creating a macro for it and then converting it to vb code so I'm assuming it's correct. I have no idea on the top stuff, I got that from another website, when I try to dim the rstStandardHours as Recordset, it...
  20. gbscobel

    Emailing letters to individual email addresses

    I will play with it and see if I can figure this out. Not sure how to tell if I'm using DAO or ADO but DAO seems familiar. Your code looks very different from what I'm used to seeing so I suspect MDB and ADP must use different syntax. This is what I've been able to come up with so far, the...

Part and Inventory Search

Back
Top