"Thank You"s

"If I have seen further than others, it is by standing upon the shoulders of giants."
— Sir Isaac Newton

Hi Crystal

Thank you so much for your site and documentation on databasing. You have a fabulously intuitive way of unlocking concepts and releasing knowledge. I am deeply indebted.

I've just moved to Madagascar for work and find the local library rather shy on books covering databasing. (The library only has around 200 books, and they're all in French anyway.) I did an undergrad course on databasing over 10 years ago but have hardly used the knowledge since. Trawling for something to re-kindle the flame on the web has been tedious. As a linux user, i initially didn't even approach the proprietary side of the fence. Although i will implement the db in Open Office Base, much of what i learned is based on your willingness to share your insights and experience so freely. Sincere thanks!

Have an awesome 2010!

Thank you very, very much for your free book on Access! I just copied it to augment an older MS book I have on Access (as I didn't want to pay to have another Access book that I might not use enough to warrant the expense). I stumbled on your book while looking for help on how to adapt MS Access templates available from Microsoft's Office site.

Though your book (I just took a quick glance) doesn't directly answer my orginal question of how to use or modify Access templates, it definitely will help me improve my creation and organization of the databases I have made from scratch.

I thought I'd send you a reformat of your intro page to serve as a cover sheet (since I didn't find one), for those of us who are fanatic about having a cover page for a book. I know your book dates from a couple of years ago, but here it is anyway just in case you can use it.

A small thanks on my part for your effort and I'll definitely keep your work in mind as I look for Access resources in the future.

Sincerely,

Thank you very much, Jane! I printed and bound a copy of my book the other day to give away and saw what you meant about it needing a cover. I used the cover you made for me. My next version will have one (smile) – Crystal

Hello And Thank You. I stumbled upon your site and was so blown away I had to tell you how good you are. I've tried 'em all! Idiots, Dummies, SAMS, Que, Missing Links, Bibles and more ... Even John Smiley couldn't help me! I am a more than competent computer user, I just don't have the "head" for this sort of stuff.

Well you (and Allen Browne) have certainly filled the gap. The proverbial penny has finally dropped!

Thank you for your philanthropy, along with your brevity and human approach to what is a daunting subject for most of us. Yours in peace,

Thank you so much for an easy to read Access Basics!

I was directed to your site version of Access Basics and I wanted to let you know that I really appreciate you taking the time to provide that level of information on the web. I'm new to access and I've read alot of books, but this really helps me because I can refer back to trouble areas regardless of where I happen to be in the world. It's good to know that folks like you exist... you simply enjoy sharing your knowledge with others. I promise I will use what you have provided to the best of my ability. Thanks

Thank you very much and your Tutorial is great. Gets me thinking back on the right track again.

I am studying (just reading anything just does not do it for me) your tutorial. What a great contribution you have made. I am sure that when I get done I will understand Access much better.

Your are always helpful, Crystal. Stay well.

It’s refreshing when one finds something for free and there are no strings attached. I am newly born into the world of Access. Your book of 100 pages will be read and used by me. Books that are up to 1500 pages will choke a newbie to death. Your book will nurture. Many thanks for your freely giving spirit. I may not be able to do anything for you but I will certainly pass on what I can in the same spirit.

I have been reading Access books about 14 years. Yours is quite simply, the most informative thing that I have ever read on Access. Thank you so much for creating it and making it available.

If I could offer any notes that might be of interest......

First, what your guide really is, rather than a complete start to finish tutorial, is expert teaching on the 100 - 200 things that people learning Access & Access programming have a hard time learning, understanding, or developing a perspective on.

Second, your guide is so good, that, I think that with another 10 pages on programming it would become the book that doesn't exist anywhere else....a good introductory Access VBA/programming book.

As often happens the most valuable things are the ones that are given away expecting nothing in return . it is a difficult practice ... I am not a geek and my knowledge of computers is born out of necessity . I am running a business project for the youth in Cambodia .

As our project grows I am faced with my inability to find schools and teachers where to learn new skills so I often use internet to cover those gaps.

I found your exquisitely well informed, presented and documented papers. I hope, with time and attention, I will be able to use some for the benefit of more than a hundred young men and women with whom I work along . My most sincere gratitude for your kind effort

I just downloaded your tutorial ... started reading the introduction letter and the "Types of Applications". For the first time in my life I undestand the difference between the applications, your descriptions are great!

I recently read your tutorial on Access.Very easy to follow and informative. Thank you!

Great tutorial, now a permanent link in my favourites! Thanks!

I stumbled across your documentation when searching for Access basics and I had to write to you. I LOVE LOVE LOVE your work. It’s so easy to follow. I’m not new to Access but I agree with your quote that you had added “The more I learn, the more I realize I don’t know.”

I’m not even done reading the whole document yet, I just started it and right off the bat I learned something that I have been struggling with for awhile. How to create a full name without spaces even when all the fields are not filled in.

Wow, you spelled it out for me just the way I could understand. Again, Thank You so very much for your generosity. Many Blessings,

Crystal , I wanted to thank you for your excellent document on Allen Browne’s website. It has been a big help for me. I’m somewhat of a newbie when it comes to diving into the nuts and bolts of Access. Thank you for all of your help!

Just wanted to give you a quick thank you for the work you put into the Access how-to Basics guide you posted to UtterAccess. I recently took a position where I needed to brush up on my fundamentals and reading it really helped bring me back up to speed. Thanks for your contribution, much appreciated!

I found your pdf files for Access Basics on Utter’s website. I am a trucker first and a computer programmer second. I am trying to create a database for my trucks that will track information and give me accurate reports so that I may make informed decisions in my business. I have taken 2 Access night school courses (after hours running freight all day) and still have problems trying to put this all together.

I have printed off your files and am looking forward to reading up on them very soon. It appears that your knowledge may shed some light as I read on. I would like to thank you for your time helping us Access challenged individuals.

Nice tutorial Crystal!

As usual, a stellar performance. I printed out your manual and gave it a quick perusal and found more helpful tips. Imagine what I will gain when I read the whole thing. Many, many thanks.

thank you for the Access Basics...it's better than the book I bought for $40! Have a great day

I've just printed off the Access Basics and just reading what I could while printing - this looks super great - this is what I needed 10 years ago but I guess it's never to late. This is going to give me a helping hand understanding some VBA stuff.

I wanted to compliment you on your Access Basics "book" and thank you for posting it. Also got helped by you a few times in MS's Access forum. (also my hobby is helping others there on structural/organizational issues as a hobby).

Going beyond your note that 100 pages may be more useful than 1500 because someone is more likely to read it, 100 pages can actually contain more useful information (for a purpose) than 1500.

In your case you distill/ explain / summarize /get-to-the-point/teach so extremely, well that such is the case, at least for me. I've been a heavy DB user for 18 years and a heavy Access user for about 14 years. (including implementing it in business and volunteer organizations) I've probably read 3000 pages of Access books.

(I'm a newbie to VBA/programming, probably because I've gotten away with less friendly and "managing" user interfaces because in my business uses all of my users work for me, and also due to a lack of good books on the topic.)

While printing your book (to read cover to cover later), I spent about 2 minutes glancing at pages in it and in those two minutes learned about 5 new things! I can't wait to read the whole thing.

I wanted to say thanks a lot for your links. I have been following and bookmarking a lot thanks to you. And I bet you don't hear a good "Thank You! Thank You Thank You!" frequently enough, so let me say it. I've read a lot of your replies on the forums here and I want you to know how much good you do for those of us with stupid (and not so stupid) questions. A lot of us would be stuck without the help you and others give on these forums.

Your access basics for programming has inspired me into cleaning up the database I've created over the past 10 or more years ... I wish I'd had it then - with all that I know about Access - I was not aware of the capabilities of the + concatenation (boy have I been busy) you know the old story - build it now and fix it later.

It also gave the courage to run the debug compiler which gave me a few problems until I declared a few things This gave me the courage to continue on and try making the MDE (which I could never do before) but it worked this time after the clean up. (thanks to you).

Now all my forms and reports are protected plus the database is split so the tables are also protected (somewhat). Many many thanks for the book and all !!!!!!

I love what you have written Thank you for your wonderful work,

Just want to say thanks. Your website has been of great help, in many ways. I'm sure more people out there are grateful for the knowledge you share with everyone who seeks help about the application.

I hope you've not yet tired of receiving comments on your Access Basics "document". I happened upon your tutorial on the UtterAccess board, opened each chapter and then saved the pdf files on my computer.

While I am only about half way through the chapters, I simply could not wait any longer to let you know how informative I have found it and how much I am enjoying going through each chapter. Your Access Basics has been just perfect for me!

I learned what I know about Access in version 2.0 and that has served me well for a long long time, but it's time for a good refresher. I distribute a runtime application created with 2.0 and, with some adjustments along the way, has served my clients well on all platforms from Windows 3.11 to XP. Now, with the release of Vista, I really need to update my application.

Thank you again for the excellent primer on creating DBs in Access 2007 and for sharing it with others!

I would just like to thank you for your wonderful site. I am learning so much from your articles and chapters. Thank you :-)

This information has proved extremely useful. I ... have developed an ACCESS database to manage the information. Like you say, its real power is not just in storing the information, but also manipulating it and enabling others to get the most out of it.

I have bought a number of books on ACCESS, but I can honestly say your short publication has explained some of the concepts I have been struggling with better than most. Keep up the good work!

Thank you so much for your on-line Access manual. I have recently started a new job and need to use Access but don’t have a clue! It is very generous of you to provide this information for free and has helped me a lot. I send you my sincerest best wishes

Have found the Access Basics a incredible source of information, you should be crowned

Thank you Ms. Crystal for your guide lines. Now I have made it a point to thoroughly readout and understand your basics guide and then only post something new and move forward. Your guide is really helping me access the ACCESS.

I had actually been reading your guide before you replied. I think it's an excellent resource and I'm wondering if you've thought about doing something similar for VBA ... (your guide in Chapter 3 answered more questions for me in 10 minutes than several books I've read at B&N or Borders over the years) and some commonly used functions.

WOW! Thanks so much. I just took a quick look at a few sections and I'm blown away! I can't wait to start using the new things that I will learn. You are a genius. It's written in such an easy to understand format. My colleagues and son will love this as well.

Thank Crystal for taking the time to let me know that you saw problems with my table, I did check out the links you offered as assistance and I am now hard at work to repair it before I continue on. Your literature is exceptional!! Thanks again...................you are saving me future headaches!

Hi Crystal, Thank you for your great help, it works well! I appreciate your information; you have a very good Access tutorial website.

I came across your "Access Basics for Programming" document two years ago, and I have been using it as a quick reference guide ever since. I just recommended it as a must-read to my coworker who is also interested in database design using Access.

I really thought you did a great job of explaining the basics of Access. Thank you for posting your excellent book, I will read it again and again.

Can I take a moment to say a warm thanks for sharing your obviously deep understanding of MS Access with people such as myself as a free resource?

I've been using 2003 and more recently 2007, for about 5 years now just as a bit of a hobby. I've been working mostly on one single database which now holds records of around 25000 ...

However, I became increasingly aware that it had turned into somewhat of a sprawling mess and even for me as developer to use it, the experience was far from pleasant or expedient. I shudder to think of the reaction of someone else attempted to navigate its foibles.

I was looking up yet another problem I had with a bit of unruly VBA and I found a link to your site on a forum. It occurred to me that there were huge areas of functionality in Access that I would consciously avoid because I didn't fully understand the syntax or context.

I decided to take a step back and start from the ground up by reading your pdfs and see what tricks I had passed by and have consciously been avoiding ever since because at the time I couldn't quite get them to work for me.

Your wisdom has cleared up a lot of puzzles for me and I feel like I've taken a huge leap forward.

Your Access Basics for Programming has been a valuable resource for me. Also, when I have done web searches for solutions to problems, you have often come to my rescue.

You are a smart lady and have a special gift for teaching. I appreciate you being there with the right answers. Keep up the good work.

I love your reference material on Microsoft Access. I am a long-time user of this program for various tasks and continually find myself looking for answers and approaches to questions I keep coming up with in my use of the program. I am a new member to UtterAccess (just signed up today 4/14/09) and I really appreciate your work...keep it up.

Just like to personally thank you for your time in producing all of the great (free) learning material you have out there. It is indeed helping me understand the complexities and power of Access. I am not in the IT industry but love creating tools that help me in my job that cannot be bought or customized to suite my particular needs. Once again thank you Crystal and I wish there were more people willing to give rather than take like yourself.

I recently found your Access Basics doc on Allen Browne's wbsite. It's a great eBook, and you've answered a lot of questions I've had. Thanks again for making this type of shared knowledge available.

Thanks for creating the resource. I have only recently stumbled upon access. Prior to that I relied on work arounds to store and retrieve data. I am excited ……….gotta stay patient and put in the learning time. Your information is a great place to start.

I really appreciate the effort you put into your Access Basics. Good start for a novice in a hurry

I came across your information today while researching a problem. The information is what I have been looking for. I have gone to the "advanced" traveling classes but find that I am past the basics that they teach. I look forward to putting your information to work. Thank you for your enthusiasm for programming and willingness to share your enthusiasm and expertise.

Good work and well done. Admiring and respecting your passion to help. I have downloaded your book and ready to read it. In fact, I am in search of how to make a login screen to control different user accounts to access different modules of my access database and I found your website. Thanks a lot.

I passed your Access Basics book onto a coworker. He asked me to thank you. He’s an older (mid to late 60’s) gentleman who thinks he may need to learn Access to stay employable. He looked over the .pdf files and said he could see that your book is going to be a tremendous help for him.

Your tutorial was BRILLIANT and gave me all the answers.

I love that you made a smaller, easier to digest book about Access that’s free to the public. The 1500+ page-books that are out there are daunting and discouraging, in my opinion. Thanks

I like your book. It was very clear and understandable. I really like what you were doing with the type tables. I have a database that I am creating that uses various types so I set up 10 different type tables. They way you set yours up is exactly what I think I should do. Also the address table idea was great.

First I would like to thank you for allowing free downloads of your Access E-book. Being a self-taught MS Access user I am always looking for material to help me become better at it.

Your E-book really has very valuable information and tips on programming, plus it goes into a lot more detail than most other books a person has to pay a high price for.

Your reference to other MS Access sites is a fantastic, as for myself I am always spending time searching around from them.

I feel about Access programming now, just like that quote you have on page five of your E-book “The more I learn, the more I realize I don’t know”—Albert Einstein.

Again, thank you very much for allowing the downloading of your very valuable E-book.

I have been reading your Access Basics and think they are really great. Finally somewhere to get some straight answers.

Thank you, your book is very helpful. I wish I would have read it long ago or at least before I did this project…. I have already begun fixing the tables once I read your book….

I didn’t realize what a mess it was till after reading all the great info. You’ve been great resource of help! Kindest regards and thank you again for your book,

Just wanted to let you know your training and presentation on Access is most brilliantly and fantastically presented than any of the others I have seen thus far! You really set high standards and you make neophytes like me really want to dive in and learn. Thank you :-)

With great respect to all the other excellent video tutorials on Utube your outstanding lessons Crystal are just that bit more refined and presented in a way that a cave man like myself can grasp and understand far more easily. Please Crystal, keep them coming, you're doing a fantastic job. Sincerely Grateful,

Wow, it's "StriveForPeace" Crystal! She's a legend in the Access community and now on YouTube! Her solutions are always elegant, simple and she makes it seem so natural and easy, and, dare I say, FUN!

Thanks for all the work you're putting into this, Crystal. You're making my conversion from Excel far less painful.

Nice site and great quality (as usual).

Thanks Crystal! that worked great! BTW Thanks for those awesome videos too! on Access!

Thanks for all your hard work Crystal and for giving out these tutorials I've seen you a lot on the internet and thought I'd type an email showing that your work is not unrecognised.

I've taken an interest in Access from about 6 months ago and I'm really loving it. I'm trying to design an accounting database and going ok so far. All my friends think it looks good.

There are times where I want to throw my laptop because it gets frustrating, but when you pull something off, its a great feeling. Access is really challenging and you guys are amazing in what you do.

I've learnt a lot from people on the net and there is a lot of help out there. I've downloaded some of your databases and been to your sites and YouTube and have been meaning to say hello for quite a while

Can't thank you enough for your contributions in the Access community.

I LOVE your videos. It really made me think about how I wanted my database design to flow and forced me to completely redo the design. Your videos have been the best source of help I've found. Thank you for your work.

Congratulations on your mention of honor in the Access Blog! Watching all your videos and reading your fabulous Tutorial really makes it clear how you have steered so many people in the right direction with programming and database building problems. No superfluous words - just the facts - with such substantive value!

This line looks especially handy in the error handling: "I like to make the error handler go to the line that caused the problem so I can see where it is." Too often we’re in a quandary when we encounter errors.

I can’t believe you shared your Analyzer, but if you couldn’t get it into the exact market niche, I guess giving it away would be the most beneficial option for all. Money isn’t everything, but it makes some things easier. Maybe you’re achieving the best mix!

Thanks

WOWZER!!! I just stumbled upon what appears to be your "new" site. VERY NICE!!! I can't wait to tear through it!

Thank you very much ... been busy adding more tutorials and downloads, glad you noticed (smile) – Crystal

Thank you! I'm proficient in VBA for Excel, but this will push me into getting into Access VBA. You have a great website, btw, I'm learning a lot!

I just wanted to say that your website has been unbelievably helpful. I have been through classes for Access and your info has compimented that training nicely. I had many questions after I left the classes and so far you have answered all of them... Thank you, and Great job

I was in need of someone who could do some specialized programming a few years ago and was fortunate to find Crystal on the Microsoft Forum for Access. She was able to do some extraordinary work that I was not able to figure out. Since then, I have worked with Crystal on some very customized databases for MSAccess.

I am just amazed at the programming she can do. The database application's that have been created while working with her are so much more than I expected. They're just beautiful in design and accomplish what was needed and more. Excellent person to work with. Thank you Crystal for all your help and support.

Outstanding! Very, very nice! I appreciate all your help! Thanks again!

I just wanted to tell you how pleased I am with your assistance! This was such a critical piece, and I spent hours trying to figure out a work-around (don’t know why Access 2003 and Excel 2003 work so perfectly in this regard, but 2007 is totally different!). Anyway, I can definitely see why you have earned your MVP title!

God really blessed me to find you.

Now that advice was easily worth that money order I sent and then some!!! Thank you for such a thoughtful and caring answer...I knew you were special !!! Funny you should mention it, but I am relaxing here listening to some music...thinking about how to approach this situation...think I have it worked out...we shall see!

Crystal, thank you so much for your support, I can sleep now with a light heart and mind! Now, If I could only send you a car and a phone and oh, say, a million dollars.... Good night...and thank you.

have I told you just how much I appreciate you? While I doubt I'll ever become an MVP, I do want to get into Access programming and want to help others. You'll likely see me on the list a little more often now that I can ask an occasional question without feeling [quite] so inept. Thanks and have a great weekend!

I have gone through and done pretty much everything I think that you asked. I have to say I dont know how to thank you, you have opened my eyes up to so much and you have no idea how much I appreciate it. Thank you thank you thank you.

That’s great that you are there. Thank you ever so much for making the time for me again. Am soooo glad for your tip about showing the relationship diagram… it worked a treat! My mind is boggling and reminds me of your wise words that there is nothing so complicated as managing Contacts data!!!:-) It’s been so good to take this detailed, logical look at the back end of things and I can hand it over knowing that I’ve done my best to get it right as I know how to!!

I have finally come to the point of saying it’s done! SO, THANK YOU THANK YOU THANK YOU AGAIN….I simply would never have felt this way, nor got to this point without all your support and teaching. That code you recommended worked like a total dream!!!! I was so chuffed that I was able to read it as well as make a minor edit. I knew exactly where to put it on the Report. It took me less than 10 mins from start to finish. A few weeks ago that would have taken me literally HOURS!!!!

I had feedback from a couple of people directly, “very impressive and just fantastic!” and “brilliant and amazing…. It’s got everything!” Towards the end of the session they were asking about adding a new project that would require different data and they could easily understand that there were two options for how we could deal with it in the Db and they said, yes, we can see that option 2 would be easier for you to develop!!! Just brilliant to have been able to get that concept across to them in such a short space of time!

I could write an essay here on the whole experience. Oh and we had bugs occur… and I handled it!:-)… I think that when I just went straight into code and fixed one bug in front of their eyes, that added a bit of kudos! I even got to say “I am really glad that happened while I was here!”…. which made me smile! y’see how much you taught me? …I wouldn’t’ have known to say that before we knew each other!! I am just buzzing Crystal, and I have to say again…. A massive THANK YOU !

It is great to know that you are there if I get into serious trouble. Thanks for all your supportive words. You are right in all that you said, I just have to take it methodically and I will get it done!:-) It’s a comfort to know you are routing for me!!:-) Thanks again for everything…. You made a massive difference to this project for me.

I am so tired and my house, son and boyfriend have been neglected this week! But it was all so worth it. Thanks ever so much, so much I’ve learnt! I’d better stop now but hope you get the idea…. I’m very happy!!!:-)

Thanks for being the good friend that you have become, you will always be in our hearts and minds forever. Sending you a big hug of support and friendship across the miles. All the best,

Still working on this 'problem'...but I think I can see a light at the end of the tunnel. Many, Many thanks for your time and patience Crystal...

Your instructions worked perfectly. I can now generate a multipage two-column report at the click of a mouse. Thanks again! You are truly awesome

I REALLY appreciate the information you sent regarding the use of the UtterAccess Forum. I have entered all of my preferences this morning and feel I am up and running. I am going to review your other emails and respond to them individually – more to come! Thanks again! You have been an invaluable resource for someone like me that is just starting out.

Crystal (aka secret weapon),

I chose not to add the table of contents, but I added some stuff and cleaned it up a bit. I think it's pretty good, given the time frame and my lack of sleep. You've done a great job teaching me! I'm feeling pretty self sufficient already, but I have no doubt that I still will need more of your valuable time.

Thanks for everything!!! I feel so fortunate that you where able to give me so much of your time on the weekend! I wish I had found you 3 weeks ago and had a week between each session to practice, but it's going well! You are a great teacher! and this method of learning on a project works better for me than taking a formal class.

I can't thank you enough for the graphic, that was such a nice surprise! Also I appreciate you pushing me to create the document. I would not have done it if you didn't beat me up over it.

I'll let you know how it goes, but with the amount of preparation done it should be the equivalent to the US Military invading Jamaica. I also have long and excellent relationships with the executives involved.

[NOTE: Steve is a former client who uses public forums for technical help]

Wow, so amazing to see you on the board answering my question, because I was just thinking about you recently. What do you think of '07 ? I love,love, love it !!!

...they made me permanent ...2 years ago - I know compared to you, I'm a neophyte, but here, in my world, I'm a guru. People are so worried about just getting their tasks done for the moment, they never want to learn anything new. I have a new boss, who's REALLY tech-savvy, and he appreciates me — he's an MS Access power-user and our skill sets are very different, and we compliment each other VERY well - it's great

Hope all is well with you - so, so grateful for your help - my quality of life is at a point it would never (IMHO) be without you, and I do not take that for granted.

OMG, Crystal, I'm waiting any moment for the whitecoats to get here, because I've been I've just been yelling and clapping and blowing kisses at my monitor so much that you'd think my team won the Super Bowl LOL, and my neighbors know I live alone, so they surely must be convinced by now that I'm not quite right in the head. All that to say ...........

IT WORKS IT WORKS IT WORKS IT WORKS!!!!!!!!!!!!!!!!!

It is WAY COOL ... I LOVE IT LOVE IT LOVE IT!

I'm a very happy camper tonight. Thank you EVER SO MUCH, Crystal, for this awesome code - it is so helpful to have the fields bolded. The user is going to love it!

Wow, Thanks Works like a charm! Never would have come up with that on my own, very clean

Well!! I'll be! That certainly did the trick. What an amazing set of tools [re: V-Tools DeepSearch] Thanks a million Crystal!

Wow is the only word that comes to mind. I have gone through this extensive reply carefully a couple of times and I have also carefully followed your instructions and suggestions ...

Crystal, You have gone above and beyond the call of duty in this regard! It was amazing. Thank you for putting so much time and effort into helping a guy out!! ...Thank you, Thank you, Thank you!!! (Just incase I forgot to say it)

Thanks Crystal. I mean this when I say it. Your a good person and I appreciate you. I know you're busy and its really nice that you can point me out in the right direction. Seriously. It means a lot. I am actually a computer tech that volunteered to help this non-profit. Thought I could learn access quick enough but databases and programming are not my strong suit. heh. I also quickly realized how complex Access is. Thanks a trillion million.

Thank you...Thank you... Thank you!! You are amazing.

Crystal--you are amazing! I already have 15 pages of your "how to" on this db! Will study all! so much for taking the time--you are one amazing lady!

I just want to thank you personally for the help you have provided me. Even though you have never helped me directly, with the help and links you have provided to everyone else, indirectly you have helped me. Unfortunately in this type of environment there is never enough praise and thanks given. Keep up the fantastic work

Crystal Thanks again for yet another clever piece of Access programming

Thanks again for your help and the links you provided. It's obvious that you truly care about helping fellow access users!

Works a treat !!! Thanks for your help, you inspired me to keep trying.

Crystal, Very amazing! Thank you.

Just wanted to say thanks, as your tip dug me out of a bit of a hole. I just hadn't realised that setting the 'dirty' property to 'False' would actually save the record. This is not made at all clear in the Access documentation!

Thanks! I was able to get it to work, I just have a hard time understanding the code structure at times. It works great! Thank you, you're a lifesaver! And so Brilliant - it's amazing!!

Thank you and the many others who have assisted you in reaching out to those that need Access assistance. You are awesome and I wish you the very best that life has to offer.

I know you're primo at powerful code, that's why I decided to ask you; you've helped me enormously in past efforts

You know, I could swear I tried that Crystal! Anyway, it's working now. Thanks so much!

Crystal.. I have the up most confidence in all of your work and efforts to help me and others, I couldn't think or want anybody else as my mentor than yourself.

Hi Crystal - you are so helpful....the world needs more people like you!!!

I just wanted to say Thank You for some help I used from one of your posts on UtterAccess! I googled a Dlookup issue and found your post and it saved me from a lot of frustration. Thanks again,

Thanks so much for your valuable insight on UtterAccess – After struggling with forms and subforms – this did it for me –

Thanks for all the work and for sharing. Your calendar download at UtterAccess is a work of art.

Crystal, you're an absolute star - thank you so much!!

Hi Crystal! Thanks for the tip! I was thinking last night as I fell asleep that hmmmmm....maybe a subform? I"ll wait and see what the experts say in the morning. y'all rock!

Thank you Crystal for the quick response, I will continue with this approach. Also, if it is OK to say, thank you for all the help I have received from reading your answers to other postings. You have very clear answers that I am able to follow. I have learned so much from UtterAccess just by searching on my issues and trying new things.

your help and advice has ALWAYS been spot on. Thank you!

Awesome info, Crystal! Thank you very much!

Thank you so much for your input on my design and set up. I really appreciate the constructive criticism. I have taken all of your advice and made the appropriate changes. Thanks!

The command button works beautifully. Exactly what I was looking for. You seriously rock and I really do appreciate your help... Have a great one...

Hope your day is good! Mine's better today... thank to your great help!

Hi Crystal! Thanks for jumping. You always have great advice.

I appreciate your help and response. You are always very helpful and insightful.

You rock! I appreciate your patience as well as your expertise. Many thanks for all that you do here...it's great encouragement for beginners like myself. I look forward to completing the reading material that you pointed me to...it really sheds some light. Thanks again. I hope YOU have an awesome day!

WOOOHOOOO ! OK...Good answer. I think I might of actually known that at one point and forgot. Your patience in solving this riddle is appreciated. !

What are you !!? You're a star ! I've just finished implementing the changes and it all works great. That's the first time I've changed an underlying forms' recordsource whilst being 'above it' (so to speak) ie. while unloading another form. It works great. The actual error only manifested itself occasionally, but it irrated me. I have a warm feeling now watching it work properly. Tommorow I'm gonna sit down and read through your tutorial. Many thanks,

Ah, Crystal. That looks like just what I was after. I'll do a little testing and let you know. Thanks.

Thanks Crystal. I had two combo boxes. One unbound to find clients and once found I had a bound combo box. I changed the bound combo box to a textbox after reading your post and realizing I only needed the unbound combo. Thanks for sticking with me.

I started reviewing your site after the last post you did. Very interesting reading. I will continue to read it. As I said before, I am pretty new at this stuff so there is a learning curve. I have learned a lot so far and this site is amazing. And I plan to continue reading.

Great!! Many thanks Crystal. This was the steer I was looking for. I've got no problem with subforms, but thank you for the link. I find it incredibly useful and comforting whenever I come across posts that you and others make that are as detailed as this. Because, it reassures me that I am doing things the right way if I am doing them and understanding them in the way that MVP's do! I know I have a very long way to go to be as good as you guys, but I just love learning and developing my skills! And your posts are ALWAYS highly valued and much appreciated. Many thanks again.

Fantastic, I get it now! That's worked wonderfully Crystal. You are a star! ... Thank you very much again, Crystal

That worked PERFECTLY!!! Thanks so much, I really appreciate it!

Omigosh, so you can! After all these years, still something new to learn! Thanks Crystal, you've made my day!

Your solution worked wonderfully! Thank you so much! This forum is fantastic!

Crystal - I found the system object setting (Tools, Options). This is so cool! I was going through all kinds of hoops to try to keep my user groups from moifying key queries, tables, reorts, etc. I want them to have the flexibilty of adding and creating their own queries and reports, but not edit the basic ones we create from the mother ship :-)... Thank you very much for all of your help!

The OutputTo calls have been working beautifully for about 24 hours now - recreating 70-100 static pages every 15 minutes. Many happy folks on this end. Thanks so much.

Excellent and it works... I'm pretty happy about this point. This has been pretty frustrating but you certainly made my day. Thank you so much

You made more than my day!

I would just like to thank you sincerely for taking the time to help....I have learned so much reading through these forums, and I find your resonses extremely illuminating! So please except my sincerest thanks for taking the time to help all of us newbies out--YOU ARE AWESOME!!!

Thanks Dr Crystal, Your diagnosis was correct. The explanation is appreciated.

Thank you so much for sharing your knowledge!

Can I just say thank you very much for uploading your analyzer, it is something I have been looking for a long time. Absolutely BRILLIANT Something that makes sense and does all the hard work for me, I particularly like the relationship report though all of it is just what I need. I am in the process of modifying a lot of my databases and this will certainly help enormously. Can I just say the help and support I have had from the group is second to none, and you are all very generous with your time and expertise.

What a great query - thanks so much for the help!

Wow, awesome! It works as expected on the first try, many thanks mate! I still have a lot to learn...

YOU ROCK!!! It worked like a charm!!! Many Thanks!!!

Thanks again. I always find your posts well thought out and educational!

Works perfectly!!! Thank you!!! I thought I tried this before but evidently I did something wrong because your code works great.

Crystal, it took me a couple of tries to get this right... I kept trying to add the new DB. could not get it to work. I put it aside for a couple days, then came back and simply followed your instructions. Worked great, first time! And yes, it was easy! Thanks. I appreciate your support.

Oh my! you are heaven sent! it worked perfectly! You have explained it so clearly! thanks a bunch!

Brilliant - just what I needed! Thanks again

That worked great, thank-you for your help

Works like a charm! Thank you!!

Its been a long time, am glad you picked my post. I always admired your big heart in helping people... I wish I can do the same. Many thanks Crystal

Happy to say that I was able to get to this today, and it worked like a dream. This is exactly what I was looking for!!! Thanks so much for taking the time to help me out!

I got it, I got it .....YEAAAAHHHH!!!!!! I figured it out.....with your excellent help as well!!!! Thank you,

Hey Crystal, I'm so glad to hear from you! I've seen your name all over UA and used some of your tips.

Thanks a lot. That works like a charm You are awesome.

Crystal--thanks! Will study this carefully and will let you know either way-- Really appreciate the time, talent, experience, and wisdom you are sharing--with me and with everyone.

Excellent suggestions Crystal... You've helped me yet again.

You did it for me once again. Not only did you help me, but you did your best to allow me to help myself. I know a lot of people are just wanting the answers but I am the type of person that needs to understand what I'm doing. You are awesome at helping me do this.

I have learned a lot just by reading your posts to other people. I learned more by just searching for the replies that you have made. I think i'm in love.... Thank you!

Thank you so much for your input on my question to UtterAccess. It helped me to understand the structure way more than I have.

Thanks for all your help! I think I'll take the next hour or so to get acquainted with your tutorials - better late than never!

Just wanted to say thank you for your contributions to UtterAccess and your basic guide in particular. I am working with my staff to help them develop the skills the need to evolve their work from being manual entry of data from paper forms and retrieval via canned procedures to manipulating data programmatically to move electronic submittals from one set of tables to another. I came to UtterAccess to look for a good starting point and came across your excellent guide. The combination of clarity with your reassuring tone will be great for my gang. As someone who has developed their knowledge solely from exploration and experimentation (I'm one of the most pathetic classroom learners ever) UtterAccess has been my mainstay.

Just today, while browsing your guide, I came upon the use of + as a concatenation operator and the simple Day, Month and Year expressions. I had a hearty laugh at myself. Since it was the first way I figured out to do it, I've been writing long, elaborate Format((Datepart([ThisDate]))) and Iif(Isnull([ThisThing]) or Isnull([ThatThing])) expressions to accomplish the same ends.

I was moved to remember the first personal rule that I set in the early stages of learning Access: "If it is really hard to do something that is an everyday thing, you're probably MAKING it too hard." LOL

Hey, that's a great idea. Thanks alot Crystal.

You have saved me more than once! I'll give this a try and report back!!

WOW! All I can say is what cool code that is....... Excellent work as usual.

Once again, Thank you very much... I really appreciate it. You are one of the nicest persons I've met here at UtterAccess. You are always there to help people like me... Thanks again...Crystal...

Excerpt from Letter by Richard Kaplan, Corporate Vice President, Microsoft Corporation

© Copyright 2009 Crystal Long.  All rights reserved.
Last Updated:  January 18, 2010