When you write a program in Access, one of the most complicated things to do is to implement the pop-up windows as it should return the value in the control that opened the window. For example, if we want a combo box that shows all customers and if necessary to change one of that, we need to double click on the control to display a new form ‘acDialog‘ (our pop-up window) with the function OpenForm DoCmd .. .. then as the last parameter to the customer ID to be presented in the form that will take our customers with Me.OpenArgs in the FormLoad event. Then, if you change value in the popup window? The combo box in the parent form should be updated with the new value and how do we implement that? Writing the value in the registry and returning it to update the control in the parent window. The functions are:
SaveSetting “Key”, “SubKey”, “Value”, Me!IDCostumer
GetSetting “Key”, “SubKey”, “Value”, Default
DeleteSetting “Key”, “SubKey”
You can see an example about this topic and more on an application written in Access by me at this address. From these example you can see that I have never made use of macros or anything like that, but only Access Form and VBA code. In this way, I think, Access becomes an exceptional tool for writing business applications in a short time. Of course, Access has limitations starting with the execution speed of complex queries, for this .NET or Java not satisfies me at all, I prefer to write in C/C++ with MFC, STL and ATL, of course I need a very long time to develop applications, but the programs are arrows, see for example Cerere 2010 that was written with VC++ 9.0.