Search results for query: *

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

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

I did all that but now when I run the code, I get the error Too few parameters. Expected 2. It won't go into debug mode to show me what exactly is wrong though so I can't figure out where it's failing. Both the report and query run fun independantly of the code, I don't know what's going on...

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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