Testimony

Bogdan R.
30 Jan 2018

to me
Dear Sir,
Today I found your "LEARN MS-ACCESS TIPS AND TRICKS" on msaccesstips.com. I must say that, until today, I was thinking that I am, maybe halfway on my path to learning Access. Well, please tell me that "I am not an Access Guru and not through MS Access yet." The phrase of yours is old and not valid now, or else I must quit learning.

 
Seriously, I think you are too modest. So many advanced topics exposed with so much clarity in one place are hard to find. Believe me, I've searched and I've seen that, from a point on, the information is repetitive. From this point of view, for me, your blog is like an oasis in the desert. I want to personally thank you for your effort and your kindness in sharing your (advanced) knowledge. You definitely win my trust and this is the reason why I dare to ask for your advice.
In short, I want to run a database in runtime mode and I need, from time to time, to modify the position of some textboxes on a report. The problem is that, in runtime mode, I have no access to layout or design report functions. To solve this, I began to study RibbonX customization and XML code, which can restore some functions through the idMso's. I found that it is possible for print preview, export/import data, etc., but not for layout/design functions. I was resigned to that but, today, I found on your blog a post about a custom-made Report Wizard and that restored my faith. So, my question is this: do you think is it possible to recreate (in vba maybe) the layout or design function, or even just the part that allows to move some controls (textboxes in my case)? It will be of great help to me if you find time to answer but, if not, I will understand.

I wish you all the best in the world.
With much consideration,
Bogdan Rizea,
Romania-Europe.


From a distinguished Subscriber: Grovelli

This is the only Tutorial available that goes in depth in Access Classes; not even Access Developer's Handbook had such a broad perspective and it was published almost twenty years ago. Congrats A.P.R. :-)

From Keith Kittle, US Army

4th October, 2023

Mr. Pillai -

Just wanted to say how much I truly appreciate your website.  So incredibly helpful and (FINALLY!) explains advanced VBA concepts in a way I can understand and put into use.  I'm active duty US Army and have used Access to solve a lot of problems as I've progressed throughout the past 21 years of service.  Your MS Access Tips and Tricks website is an incredible resource!

You rock!

Keith Kittle - keithkittle@gmail.com

Keith Kittle,

18th October, 2023.

Mr. Pillai -

Please know that the small grammar errors don't impede the clarity of explanations or understanding of concepts in your work. Furthermore, it's immediately clear the level of detail, passion, and time that you have invested in this.  It's really quite remarkable!

I'm not an expert in MS Access development by any means; I'm actually quite a novice compared to your level of expertise and experience. What I really appreciate about your work is that you have steered away from the typical beginner tutorials that seem to be everywhere. Instead, you offer more complex lesson topics that are often hard to find for those who've moved past the beginner stage. What's even better is that you present these complex concepts in a step-by-step manner that genuinely supports learning them. For example, your "Stream-Lining Form Module Code" series is a perfect example of what I've been looking for. In my career field, I relocate every 3-4 years, and with each move, I encounter a new challenge that I address using MS Access. Having a way to repurpose my form menus, reports, and other elements for a different use is absolutely what I am looking to establish (lots of work initially, but a time saver later). Your approach is more in line with experts like Allen Browne and (a very few) others I have found. Additionally, I appreciate that your motivation appears to come from a genuine desire to educate and nurture the subject matter, rather than solely monetary gains (though, of course, financial considerations are important, we all need to make a living).

I'd also like to offer my perspective as someone who approaches this as an amateur. My limited experience might make it easier for me to spot areas that may be glossed over by more experienced developers. There may be topics that I find require further explanation or a deeper dive for me to grasp fully.  Maybe you would find some value in that?

In any case, I'm not certain about your ultimate goals, but having benefited significantly from various free resources, I see this as a way I may contribute back a bit.

Once again, I want to express my immense gratitude for your work and the respect I have for it.

Thanks!