Search results

ok that's BEAUTIFUL. Now I can use my loop query to add all the fields into an HTML Email Table! The only error I'm getting is this: I have a Date Column that's throwing out an INSERT INTO error Private Sub EmailResults_Click() DoCmd.SetWarnings False DoCmd.OpenQuery ("ClearDroppedRackTable")...

Got the multiselect from ArnelGP working! now the next step is to figure out how to email the data i've got highlighted. I'll see what I can dig up. I'm going to try making a second query to only show records filtered on that form by the txtSelected box and see what works. Thanks all!

I'll give it a shot! Forgot entirely about that feature

Spit-balling here: I've got a query that shows all records of a specific incident. I'm wondering if with the query living on a form, I can select multiple specific items out of that query, and then append those results to a different table for emailing. I've already developed a method to email...

Thanks guys! Glad to be here! I'll definitely put these in the back of my mind!

HOLY.... **sigh** I'm both annoyed that it was so simple, and EXTREMELY grateful it worked. Thanks pbaldy!!

Same Error. Query works fine by itself Put the Code in criteria:

This would be on the SQL view and not in the design view, correct?

Hello All, Getting stumped by some vba and query work that I've nearly finished. I've got a form that shows records from a table. This form behaves like a checklist and only shows "open orders." When those orders are complete the worker chooses a yes or a no option from a combo box, and that...