Recent content by Carenne

Back with a final FYI update that after Robert looked at the sample database I sent, he confirmed that the routine I had set up was probably the best solution for the job at hand. I could not have accomplished that if I hadn't talked it out here first - I was "stuck in the mud" before...

Thanks so much for the code, Robert and allanon -- that was so helpful! I've had a bit of luck since getting the proper syntax to get it to work, but only numerous failed attempts to get it to work in a single step. When I tried to do it all in one query, it was tricky to figure out how to...

Hi Robert - I saw your latest post after I submitted my last question. I'll be happy to send you a sample. It will be forthcoming shortly. Thanks! -- Carenne

I'm back (so much for that other fire <g>). :) I just had to tinker for a few minutes to see if I could get anything going based on my last post. In doing so, I realized that, to test that theory, I don't actually need to deal with the ascii value of the first letter, but only whether it's...

Hi, Ken and Robert -- Good morning and thanks so much for your speedy responses! As BH and Ken suspect, it would be quite tedious to go through the whole list and manipulate each group of words, and as Ken said, trying to automate it could end up with lowercase &quot;america,&quot; etc...

Hi everyone -- I'm going to be importing a HUGE (single field/single words) list (20,000+) words into an Access table for manipulating and exporting into another application. Initially, the list will look something like this, with many repeats of each word: preliminary preliminary Preliminary...

Wow, sko - this is awesome! It works perfectly, and there's virtually no extra work involved. Thank you SOOO much for the prompt fix-it - you just made my night! -- Carenne :)

Hi everyone -- I'm having trouble producing some calculations in a report and hope you can help me. This is in Access 97, and the report is based on a query that contains two related tables - a customer name table and a service log table. The service log table has a column for dollar total per...

Bill and Smack -- Thanks for the info! I'll check out your recommendations as soon as I take my next &quot;surfing/coffee break.&quot; Best of luck in your class, Smack. I appreciate the feedback. -- Karen

Joe and Michael --Thanks for your replies. I already do the sub-grouped selections the way you described in your posts, but I was just wondering if there was a tool that would make the process go even faster, especially with regard to spacing between the controls and selecting certain groupings...

I'm wondering if anyone knows of any third-party utilities or plug-ins available that are designed to streamline the task of working with the cosmetics of a form? I'm thinking of all the little stuff that takes so much time. I'd like to be able to say &quot;Take these 6 objects I've selected and...

I took a beginner's level Access course years ago and have been getting by with that, supplemented by the online help, LOTS of reference books, and posting questions to forums like these. But I run into a lot of frustration (and subsequently waste a lot of time) when I run up against the...

Rick, You were exactly right in your guess that I was suffering from the universal misconception about the date properties. That also explains why I had such difficulty finding any solutions in my online or text reference guides. Everything I searched for led me to either a gazillion ways to...

Rick -- A THOUSAND thank-yous to you for taking time out of your Sunday to post those WONDERFULLY detailed responses to my questions in this and my other post! What a wealth of information! I have printed them out AND saved them in a safe place on my computer and I am going to pore over them in...

I have three fields in a form (not the same fields I described in a previous post) which will often be sequential (one-time) repeats of the same field in the previous record. I know I can use the Ctrl+' feature to repeat the data from the previous field, but I'd like to make it even easier and...