Search results for query: *

Great! Leaving for the holiday weekend & will try all next week. THIS IS A SUPER GROUP & I hope you all have a good weekend! Thanks again for all the help!

Andy, Once I've placed my button and put the event code in it, it doesn't seem to want to accept a label (label has no associated control to it). Is there another way to approach this? My thanks for your response, your label caption would really be nice to have.

Wow! This is simply amazing....I did find out that I was applying everything to the form (not the button), made an adjustment & just ran it with only one query (commented out the others). It ran wonderfully. YOU TOTALLY ROCK!!!!! If its not too much of a bother, would you be willing to...

Ok, I've called myself cutting & pasting it between 'Private Sub Form_Click()' and End Sub Nothing seemed to happen..went & tried pasting between End Sub in the last line above, but I have a feeling I've messed up something: it appears to be placing itself in a module my boss already created...

Thank you for your prompt response!! I plan on running the code directly from my database. The reason is based on the results there are a few manual steps (queries to run), then the final output is sent to the user as an excel file. Could I also ask how to use the code & what it is (ie: is it...

I’m a newbie and needed assistance with creating a function (or module) to run Access queries in a specified order. The queries are built to automatically create their own tables, so there is no need to specify output location or work with the queries in any other way. I’d like to be able to...

Great! It worked (BTW: didn't need to hit tab). Am enjoying your various posts. MY THANKS!

Skip, I've copied the code from a book and was generalizing the formula (really new user). Would this be what you are suggesting: SUMIF((A72:A166="QUALIFIES",B72:B166>0)) I get an error for parenthesis placement. Tried this (which Excel repaired) and now I'm getting a 0 value...

New Tech User needs help to sum amts whenever a value is found (currently using Excel 2007). Here is the data: A B C A Qualifies 1000 A3 City Dallas A4 State TX A5 Zip 76076 A6 Qualifies 1000 A7 City Cincinatti A8 State OH A9 Zip 49665 A10 Qualifies 450 A11 City Los Angeles A12 State CA...