Search results

Ok, don't know why that's there, but thanks for catching that!! So basically, if I put the requery back in, and remove that row source, I should be set?

It shouldnt be getting its data from the temp table. Check the after update on the combo box above List72. It should update List72 with the corresponding records to the selected report from the report selected. If it were getting its records from the temp table, there would never be anything...

List72 is being populated by the above combo box and it's records are coming from tbl_ReportList. The query addList is what you are talking about, correct? It's appending the information to tbl_Reports. The temp table is to collect the data the user selects and then get the corresponding info...

Yeah, what that is is on the "add recipient" button, there's a line "frm_EditRpt.Requery". Just remove that and the error should fade away. I shouldv'e remembered to remove that for you, sorry! :D

Oh I know how that goes! If I don't feel like building out my problems, I usually grab the whiteboard and get to drawing it out lol. Thanks again!

It's not much more than the above code, but here goes.

It just doesn't do it. I tried putting the requery just about everywhere :/

Nah, List72.Requery works fine everywhere else. Plus, I already tried putting Me in front lol. Thanks for the quick response though!! :D:D

Hey guys, I'm trying to requery a list box after a command button click. I tried "List72.requery" (list 72 is the name obviously), Me!List72.requery, etc etc...Here is the code I'm working with, since I am updating a record source. Private Sub Command71_Click() Dim strSQL As String...

Thanks a lot!!!!!:D

Hey guys, quick question: How would I requery a list box on Form B when Form A closes? I know the code would go on the On Close event, but how would I specify the form in the requery code ("listbox1.Requery")? Thanks!

Amazing, that works perfect! Thank you so much!!

OK guys, here is what I am aiming for: I have an append query that when run, will display a selection of e-mail addresses and the corresponding report they receive. I have the query to run via command button, and i'm trying to get the e-mail addresses to display in a list box. Now, the way I...

There is my dilemma, chergh. As far as the code I posted, did you read my comment right above the coding? If I could have made it any clearer, I would have. Brianwarnock - Thanks for your advice as far as the direction I should be looking into. That's all I was looking for. Thanks for...

98 views, 1 response.....

Well what I am trying to do is have the user click a button before submitting the sheet to check for errors. Basically, for each task there is usually 3 sections that need to be completed on the form. So, if the user fills out sections 1 and 2 but leaves 3 blank, i need that button to...

Hey guys, Quick question: I need to have excel check this workbook for user errors. We have employees populate the spreadsheets in the workbook to keep track of their daily tasks. The only problem is, say Joe Shmo puts down the time he works on a task, but forgets to put the volume. Since we...

I put the following code on a button click and it runs a mail merge (usually of about 5000 records) just fine. Basically, click the button and the merge will fire no problem. Upon completion, both the mail merge, the template, AND the database will close! Ofcourse, you could make the...

Fixed it. Thanks a ton for being so helpful and patient!!

Hmm...not me, and we're using the same code......I've tried on 3 different machines all with the same result.