Learn Microsoft Access Advanced Programming Techniques, Tips and Tricks.


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,

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.


No comments:

Post a Comment

Comments subject to moderation before publishing.




Post Feed


Popular Posts

Blog Archive

Powered by Blogger.


Forms Functions How Tos MS-Access Security Reports msaccess forms Animations msaccess animation Utilities msaccess controls Access and Internet MS-Access Scurity MS-Access and Internet Class Module External Links Queries Array msaccess reports Accesstips WithEvents msaccess tips Downloads Objects Menus and Toolbars Collection Object MsaccessLinks Process Controls Art Work Property msaccess How Tos Combo Boxes Dictionary Object ListView Control Query VBA msaccessQuery Calculation Event Graph Charts ImageList Control List Boxes TreeView Control Command Buttons Controls Data Emails and Alerts Form Custom Functions Custom Wizards DOS Commands Data Type Key Object Reference ms-access functions msaccess functions msaccess graphs msaccess reporttricks Command Button Report msaccess menus msaccessprocess security advanced Access Security Add Auto-Number Field Type Form Instances ImageList Item Macros Menus Nodes RaiseEvent Recordset Top Values Variables Wrapper Classes msaccess email progressmeter Access2007 Copy Excel Export Expression Fields Join Methods Microsoft Numbering System Records Security Split SubForm Table Tables Time Difference Utility WScript Workgroup database function msaccess wizards tutorial Access Emails and Alerts Access Fields Access How Tos Access Mail Merge Access2003 Accounting Year Action Animation Attachment Binary Numbers Bookmarks Budgeting ChDir Color Palette Common Controls Conditional Formatting Data Filtering Database Records Defining Pages Desktop Shortcuts Diagram Disk Dynamic Lookup Error Handler External Filter Formatting Groups Hexadecimal Numbers Import Labels List Logo Macro Mail Merge Main Form Memo Message Box Monitoring Octal Numbers Operating System Paste Primary-Key Product Rank Reading Remove Rich Text Sequence SetFocus Summary Tab-Page Union Query User Users Water-Mark Word automatically commands hyperlinks iSeries Date iif ms-access msaccess msaccess alerts pdf files reference restore switch text toolbar updating upload vba code