Search results

For the life of me I couldn't get the syntax on the SQL to work, but I did try your idea of putting the counts and averages in the first query, to cut out the middle query. It worked and sped it up quite a bit, enough to make it quite usable again. Thanks a lot for the tip!

I'm running into a bear of a problem... My table contains lots of survey data, and looks simular to: Table: tblData Agent_ID Agent_Name Group_Name TimeStamp Avg_Score 12345 Kyle Team3 1/1/05 8AM 2 12345 Kyle Team3 1/1/05 9AM 3...

My database contains thousands of quality surveys, each with 5 Questions. I have a query which groups by agent name so i can find out the average for each rep, including the average for each question and the new field to average all 5 Questions. I'm now working on a report to show this data...

So, thanks to all the great insight on this board I have gone from a complete access newbie to having pieced together what could be a pretty great database to track our quality scores... While the macro I have put together works in pieces, when I try to run the full 18 loops that are needed it...

Honestly, I guess I don't know why. It seems like from what I've read on this forum that putting code into a form is a preferred method, I believe for error-catching.

I'm running some code to open up an excel book and clean it up before importing into access. This code works fine in a module, but is giving me some problems when I try to put it in the form and attach it to the button. I'm getting "The expression you entered contains invalid syntax" with...

Ok, thanks for talking this through with me. I'll just save it and do the import from the saved file and move on with life. If anyone happens to know how to grab the already open worksheet though, feel free to speak up.

Ok, so that would set the variable to the path and name of the book currently open, but that would only work if I actually saved the book with all the adjustments the macro just made. That is not out of the question but it seems like a waste to save and close the book on one line just to use...

I'm still a bit of a noob, and although i've been searching i can't seem to find the proper use of xlsApp.path. Would you mind spelling it out for me?

Thanks for the feedback Bob. I've actually found that 8 is sufficiant for that setting, I've used that in simular code to import a whole saved workbook and it worked. None the less I tried changing it to your suggestion to be sure and I get the same message. I'm positive my problem is with...

I am trying to write some code to import some excel books into a table. The book needs to be heavily edited before it can be imported, and I have accomplished all of that, but I'm having trouble with the line that actually imports the worksheet into my table. Here is what I have: Sub...

Ok, I feel pretty stupid asking a question that has been asked so many times, but I've been searching on and reading this board all afternoon and something just isn't clicking for me. I started with This Thread to learn how to do an awesome calendar and link it to my query to run a report...