tag:blogger.com,1999:blog-73448842024-03-08T03:00:19.773+11:00vb123Articles and links about Microsoft Access or Microsoft Office Programming.Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.comBlogger431125tag:blogger.com,1999:blog-7344884.post-56471213153324714902018-06-29T11:59:00.000+10:002018-06-29T11:59:26.715+10:00Last chance to purchase the downloads from vb123.com.auAs of the second week in July I will cease to make available all the downloads from Smart Access and all the articles I have written over the last 20 odd years. You may purchase them here before that date if you wish<br />
<br />
<a href="http://www.vb123.com.au/index.html?buythedownloads.htm" style="color: blue; font-family: Verdana, Geneva, Arial, sans-serif; font-size: 12.8px; font-variant-east-asian: normal; font-variant-numeric: normal; text-align: center; text-decoration-line: none;" target="_top">http://www.vb123.com.au/index.html?buythedownloads.htm</a><br />
<br />
If you have already purchased them, thanks very much, those payments kept me motivated.<br />
<br />
All the articles that currently have downloads in Access 2016 format will continue to remain in place.<br />
<br />
Garry Robinson<br />
Access MVP 2006-18<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLv287yrbEdi6cqjqOzdaLpfIZ4eJ01fDqxA0ndCjMuGaF1_neNKQtth_e3-XrOGz-tWaulQnppKmLOGuhAk7gJrz7WBb9wf6dmT_fYRVWNgcWyy-FAKJwJuM6tIE5r5klzBbI/s1600/2004-01_0001_small.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="250" data-original-width="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLv287yrbEdi6cqjqOzdaLpfIZ4eJ01fDqxA0ndCjMuGaF1_neNKQtth_e3-XrOGz-tWaulQnppKmLOGuhAk7gJrz7WBb9wf6dmT_fYRVWNgcWyy-FAKJwJuM6tIE5r5klzBbI/s1600/2004-01_0001_small.jpg" /></a></div>
<br />
<span id="goog_1371918418"></span><span id="goog_1371918419"></span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO8Cn6vzxIXnauNbPJht7aFoecmHrYYOpHji669CICufgmQsIq-XE5N-eBqQwYVF_JB_q2k5H2oQHh_kazolWo49fuU0XEc7cwyVNihg-AFixTRgOK-GnGxLMpeGfCzcjlM6xv/s1600/2006-04_0001_small.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="250" data-original-width="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO8Cn6vzxIXnauNbPJht7aFoecmHrYYOpHji669CICufgmQsIq-XE5N-eBqQwYVF_JB_q2k5H2oQHh_kazolWo49fuU0XEc7cwyVNihg-AFixTRgOK-GnGxLMpeGfCzcjlM6xv/s1600/2006-04_0001_small.jpg" /></a></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-84558954516090520652018-05-17T13:47:00.000+10:002018-05-17T13:47:07.007+10:00How can I change the size of the checkbox on my form?Doug Steele checks all the boxes with this VBA article at <a href="http://vb123.com.au/index.html?200403_ds_aa1.htm">vb123.com.au</a><br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-35834755669531460002018-05-16T07:58:00.002+10:002018-05-16T07:58:31.299+10:00More technical content about queries on the FMS siteFMS have updated their comprehensive pages on <a href="http://fmsinc.com/MicrosoftAccess/query/snytax/append-query.html">Append Queries</a> and <a href="http://fmsinc.com/MicrosoftAccess/query/snytax/delete-query.html">Delete Queries </a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8zYDtb55RSRq_wem3k0oBH3wHlvURBIyzj_7VmP3gZKZc2kqr7NpoNIbk-jG-5IYqOs2H47iU4B5fEngV7ooV4SGvVqzDOFN6D7WO2ZcTYywTiPdAJbCUgthwqkyyyjcdTLJI/s1600/111append-query-design-example.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="325" data-original-width="588" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8zYDtb55RSRq_wem3k0oBH3wHlvURBIyzj_7VmP3gZKZc2kqr7NpoNIbk-jG-5IYqOs2H47iU4B5fEngV7ooV4SGvVqzDOFN6D7WO2ZcTYywTiPdAJbCUgthwqkyyyjcdTLJI/s400/111append-query-design-example.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
If you want more query stories for bed time reading, <a href="http://vb123.com.au/cat_queries.htm">click here</a> </div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com1tag:blogger.com,1999:blog-7344884.post-37710299837322482682018-05-15T13:45:00.002+10:002018-05-15T13:45:30.479+10:00Datasheets article <span style="background-color: white; font-family: Verdana, Geneva, Arial, sans-serif; font-size: 16px;">Datasheets provide a simple yet powerful way to display data to your users. Datasheets also allow you to provide a user interface (UI) that your users can configure to meet their needs. Most developers feel that datasheets give too much control to their users. However, by taking control of your datasheets, you can incorporate them into your applications. Read on using this link at </span><a href="http://vb123.com.au/index.html?200102_mk_datasheets.htm" style="color: #e4641c; font-family: verdana, geneva, arial, sans-serif; font-size: 12.8px; text-align: center;" target="_top">vb123.com.au</a><br />
<br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-18601184861936952522018-05-15T13:32:00.000+10:002018-05-15T13:32:21.051+10:00Dates are not that hard or are they ?Once I realised that date calculations were just about integer mathematics with each day being a number, date maths got a lot easier to understand. Then it was just a matter of getting the arguments correct for the DateAdd and the DateDiff vba functions. Basics are good but <a href="http://vb123.com.au/200409_ds_aa.htm">much better to learn from a pro like Doug Steele</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0NvD6KEPgIIH-tmVfmprA5vehP4t3UT_K5Vowqw2zdsaPQXhOR01tvoWRAl9ztQqSOSJHDtb3R1nkAzk85FN8wdfbtXmzWXPtrTexe9H6JphwRlBoYBBmLFYAgcl6H1ah0uRv/s1600/200409_ds2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="222" data-original-width="444" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0NvD6KEPgIIH-tmVfmprA5vehP4t3UT_K5Vowqw2zdsaPQXhOR01tvoWRAl9ztQqSOSJHDtb3R1nkAzk85FN8wdfbtXmzWXPtrTexe9H6JphwRlBoYBBmLFYAgcl6H1ah0uRv/s400/200409_ds2.jpg" width="400" /></a></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-58757222007488138812018-03-28T07:16:00.000+11:002018-06-29T12:11:20.972+10:00vb123 news will be on Facebook<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipp4EC33rI-U1HOidxUeLUWi-hNR3dUDFMrJInaYOfD6fg_EiXsOlNhPsXplzI3uI-o3tLYZC_l0CDH7XYRMxPgocRwexAdXluM39H9RTVzzc4toRRbBCPwfxRea1i5TVGlMbM/s1600/facebookfindus.gif" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="116" data-original-width="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipp4EC33rI-U1HOidxUeLUWi-hNR3dUDFMrJInaYOfD6fg_EiXsOlNhPsXplzI3uI-o3tLYZC_l0CDH7XYRMxPgocRwexAdXluM39H9RTVzzc4toRRbBCPwfxRea1i5TVGlMbM/s1600/facebookfindus.gif" /></a></div>
I have setup a FaceBook page for <a href="http://vb123.com.au/">vb123.com.au</a> Follow it for links to new and change articles and news related to Microsoft Access.<br />
<br />
I moving to Facebook for vb123.com.au updates. Still deciding what I will do with the newsletter. <br />
<br />
Here is the <a href="https://www.facebook.com/vb123comau">FaceBook page link</a> <br /><br />Thanks Garry<br />
<br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com2tag:blogger.com,1999:blog-7344884.post-83633764875140283712018-03-27T17:59:00.000+11:002018-03-27T17:59:05.248+11:00Drilling with Combo BoxesHere is how you can use your combo boxes for more than just selecting values<br />
<br />
<a href="http://www.vb123.com.au/199904_JR_Combo.htm">http://www.vb123.com.au/199904_JR_Combo.htm</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-66075740812056865852018-03-26T21:22:00.000+11:002018-03-26T21:22:11.941+11:00Three Steps to DisasterNot all computer systems are developed well, Peter Vogel breaks down the likely phases as follows.<br />
<br />
In the first step (Acceptance and Delight), some group of users is given a computer system. They're so excited to have this package (and so pleased that someone has finally spent some time and money on them) that they don't notice that the system doesn't actually match the way the business works.<br />
<br />
In phase two, which Peter calls Workarounds and Disgruntlement, the users start to develop manual systems to compensate for the deficiencies of the computerised system.<br />
<br />
In phase three, which Peter calls Termination and Disgust, the company will have two systems: the official, computerised system and the unofficial, manual system.<br />
<br />
What a lovely story about the life of some computer systems and <a href="http://www.vb123.com.au/199809_pv_ed.htm">you can read about it here</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-60257599433832285052018-03-26T17:52:00.000+11:002018-03-26T17:52:01.590+11:00Building Your Own Data Miner in Microsoft AccessTucked away in the bowels of Access is a powerful graphing tool called MS Graph. A lot of Office users will be familiar with the graphing capabilities of Excel but very few people seem to have successfully implemented graphs of much use inside Access. Both products use similar core elements from the Office charting engine. The difference between the two is that with Excel, you derive your graph data by pointing the graph to cells in a spreadsheet. This allows people to manually move the cells around until they end up with a graph that they are happy with. In Access, you have to manipulate queries until you end up the graph that you want. This is a lot more difficult but the end result is far more versatile as the Access graph will work irrespective of the number of rows of data that you introduce via the query. The other important feature of Access that you will deploy for data mining is the direct support of Structured Query Language in Visual Basic code. This allows you to easily change the exploration queries on the fly. <br />
<br />
<a href="http://vb123.com.au/2016_gr_dataminingsimple.htm">http://vb123.com.au/2016_gr_dataminingsimple.htm</a><br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-21351517137708142912018-03-18T12:10:00.000+11:002018-03-18T12:10:07.203+11:00Use Classes to Enhance List and Combo BoxesIn this article, Jim Ferguson shows you how to make Access unbound list and combo boxes behave more like those in Visual Basic by adding a few new methods and properties via a standard class module. This article was written 21 years ago and the sample is provided in Access 2016 format.<br />
<br />
<a href="http://www.vb123.com.au/199703_JM_class.htm">http://www.vb123.com.au/199703_JM_class.htm</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-46201427103886104552018-03-16T17:40:00.000+11:002018-03-16T17:40:16.623+11:00Helping OutIf the database design is wrong, then, yes, you might be forced to use code to get the performance that you want. Doctors bury their mistakes, architects cover them with ivy, and database designers write code around them <a href="http://www.vb123.com.au/199909_PV_ed.htm">Read the full editorial here</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-88904760393515465052018-03-06T11:45:00.000+11:002018-03-06T11:45:19.410+11:00Lookup tables improve data qualityEliminating data errors at the point of data entry can pay big dividends in the future. Bearing that in mind, <a href="http://vb123.com.au/index.html?2002_gr_lookup_tables.htm">this article describes all the steps involved in changing an existing text box </a> with no data entry validation into a watertight combo box..<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8FGCDPVD0NXvh2IOCziMushbYx8wyvYBMZbnuGLaHOtdba3qRmm6-7tIEcdQBHU2AwCjukAOprn6SXimVI6EgIHCMSN8bUdxWfqr4rrV8mP4He1RLuEZsYTFnp_fXKFP0aRoq/s1600/lu9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="282" data-original-width="364" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8FGCDPVD0NXvh2IOCziMushbYx8wyvYBMZbnuGLaHOtdba3qRmm6-7tIEcdQBHU2AwCjukAOprn6SXimVI6EgIHCMSN8bUdxWfqr4rrV8mP4He1RLuEZsYTFnp_fXKFP0aRoq/s320/lu9.jpg" width="320" /></a></div>
<br />
<br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-12588395108742037602018-03-05T17:33:00.000+11:002018-03-05T17:33:06.020+11:00Access is a tool for creating front ends for databases ...Back in 2000 Peter Vogel, the editor of Smart Access wrote "Access is not a database. Access is a tool for creating front ends for databases. To my mind, Access is the pre-eminent rapid application development tool for creating database applications." Nothing has changed and <a href="http://www.vb123.com.au/200008_pv_notadatabase.htm">you can read this editorial here </a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-81832549889342076062018-02-27T19:26:00.000+11:002018-02-27T19:26:02.169+11:00Sort out those vertical photos once and for allHave you ever wondered why photos sometimes end up being rotated on some screens and not on others. This article explains the issue (especially on windows 7 pc's) and offers up a good solution called JPEG Autorotate which I am using now.<br />
<br />
<a href="https://www.howtogeek.com/254830/why-your-photos-dont-always-appear-correctly-rotated/">Find it on www.howtogeek.com/</a><br />
<br />
Please verify on a small sample folder before going all out on conversions of every photo you have ever taken.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80ACmSxYNXN-Ynr02juNJ60yu_wpZ8wWl6nbsCEbwUiiLD48czMMURa7oDX3CyRFElmkseoSsXvdqOzY9ORDXMsV9Hv-tiQMtIuC_u-xr3-HHN9y6TcuFPUMOrsrHFEH8J_re/s1600/autorotate.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="838" data-original-width="1535" height="347" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80ACmSxYNXN-Ynr02juNJ60yu_wpZ8wWl6nbsCEbwUiiLD48czMMURa7oDX3CyRFElmkseoSsXvdqOzY9ORDXMsV9Hv-tiQMtIuC_u-xr3-HHN9y6TcuFPUMOrsrHFEH8J_re/s640/autorotate.jpg" width="640" /></a></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-12943235442647736042018-02-26T10:22:00.000+11:002018-02-26T10:22:09.223+11:00Analyze Your Data in SpaceWith a few special tricks, some crosstab queries, and MSGraph, you can transform coordinates into useful maps. Garry Robinson demonstrates techniques that can be used for statistics, graphs, and extending your crosstab queries, regardless of how you want to lay out your data.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiVmGMn3TotSy-nULeqLWMWapn-5-wPGlia8_sPi6e1tIyEGKYO2Ehq_Lt0mtKd34H-o1agaZFwP12Jf8iWVJ4xD8uRgcWHv8Rarrt_sGOFjnTl0x5eo8nr48JEn9Aw5ff_Z0k/s1600/2018-01-14_10-10-41.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="956" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiVmGMn3TotSy-nULeqLWMWapn-5-wPGlia8_sPi6e1tIyEGKYO2Ehq_Lt0mtKd34H-o1agaZFwP12Jf8iWVJ4xD8uRgcWHv8Rarrt_sGOFjnTl0x5eo8nr48JEn9Aw5ff_Z0k/s400/2018-01-14_10-10-41.jpg" width="400" /></a></div>
<br />
<br />
<br />
<a href="http://vb123.com.au/index.html?200003_gr_space.htm">Here is the link to the article</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-71492073561930979932018-02-24T16:44:00.000+11:002018-03-01T07:37:41.884+11:00Faith by Peter VogelThe great thing is that most managers seem to hold both attitudes. To borrow a term from George Orwell’s novel 1984, managers indulge in doublethink. They simultaneously believe that maintenance costs are unavoidable and that they should be zero. As Orwell points out in his book, this is an essential requirement of many faith-based systems.<br />
<br />
The result is that I’m always brought in to work on new development but never on maintenance projects. I don’t mind. Maintenance is a much more difficult job than development, requiring the combined skills of programmer, system architect, historian, detective, and psychologist. The stakes are also higher in maintenance than in development. As one contractor I worked with put it, “No one cares if the development system crashes.” But if you do something that crashes a production system, you get phone calls from people whom you’ve never heard of before. <a href="http://vb123.com.au/index.html?faith.htm">Read the full story</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-3149354167364707562018-02-19T09:56:00.000+11:002018-02-19T09:56:07.612+11:00Things You Didn't Know You Could Do With Reports Following are two articles on Access reporting that I have recently released an Access 2016 sample database for<br />
<br />
The first is on <a href="http://vb123.com.au/200105_rg_reports.htm">multiple columns and sub-reports</a> and the second is on <a href="http://vb123.com.au/200311_FS_reports.htm">managing multiple pages and long memo fields on reports </a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTg-Y7fZ2aikQwzTU2aPahmS99OLOu3kiRD6VBkffEI5UGSDLmI7VPZyOwEr3Guu5uScNg_ZVuOr6IQgBAOX9QLzl81cB6mUl9l9RCy_MfdWKtKyQueTDRFwYR-tZUPriWelbS/s1600/200105_rg2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="218" data-original-width="500" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTg-Y7fZ2aikQwzTU2aPahmS99OLOu3kiRD6VBkffEI5UGSDLmI7VPZyOwEr3Guu5uScNg_ZVuOr6IQgBAOX9QLzl81cB6mUl9l9RCy_MfdWKtKyQueTDRFwYR-tZUPriWelbS/s400/200105_rg2.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHPkC1AfRn_haIWN_7uTRpBmC_VP1ggHr6PHlf1PD4nbQ19UuSbWikNmtA-7gbHjT4lFUxSMulyumB4Zlk0_wCE7eZnOsmw8YiHv7dZo0RKIJaniCb9LNuHvIF6q9EPWmdFog7/s1600/200311_FS8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="710" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHPkC1AfRn_haIWN_7uTRpBmC_VP1ggHr6PHlf1PD4nbQ19UuSbWikNmtA-7gbHjT4lFUxSMulyumB4Zlk0_wCE7eZnOsmw8YiHv7dZo0RKIJaniCb9LNuHvIF6q9EPWmdFog7/s400/200311_FS8.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-65697528093108345212018-02-17T09:49:00.000+11:002018-02-17T09:49:00.186+11:00Generic method to control the data for pie charts Microsoft Access does have graphs as an option. Its been around for ever and it still has its place in the Access world. <a href="http://vb123.com.au/200505_cw_pie.htm">This article which I tested recently in 2016 is about Pie Charts</a> and is by Chris Weber.<br />
<br />
Chris says " pie charts can be a very useful tool for the visual display of data... or not. When properly designed and presented, a pie chart can quickly summarize what's happening in the data. But poorly designed pie charts, like any poorly designed display, merely cloud the issue.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_h3MNw6rlFOAcdrOTyX1JQGMou4emQlkeKo-5RB7wZdw0sNR6V6DIJUCAtquJ1JcLY922VaMfXMDhP29yC6B-O_J4URDu-yTqd2EP_bpLFlbf3JiQsASNVI5tN1HO7DOju_9m/s1600/200505_cw2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="374" data-original-width="430" height="347" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_h3MNw6rlFOAcdrOTyX1JQGMou4emQlkeKo-5RB7wZdw0sNR6V6DIJUCAtquJ1JcLY922VaMfXMDhP29yC6B-O_J4URDu-yTqd2EP_bpLFlbf3JiQsASNVI5tN1HO7DOju_9m/s400/200505_cw2.jpg" width="400" /></a></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-52269280945347331522018-02-14T16:39:00.000+11:002018-02-14T16:39:11.660+11:00The No-Problem ProblemMost companies tend to suffer from the "no problem" problem. Management bumps into a worker in the hallway and asks, "How are things going?" The answer is always "No problem." Of course, that’s not the same thing as "Things are going well," but the manager assumes that was what the worker meant and wanders off, content.<br />
<br />
Of course, frequently there are problems. But if you’re the worker, you probably don’t want to tell management about them. First, there’s the concern that a problem will reflect negatively on you. Even scarier, there’s the fear that management will offer to help. If your manager used to be a developer, she might take up your time by making coding suggestions. And that’s the best that you can get. I reported to a vice-president whose response to every problem was, "Well, you’d better work some overtime." Come to think of it, he usually followed up those suggestions with solutions based on his experience in creating VSAM file-based batch programs in PL/1. Workers soon learn that the response to "How are things going?" should always be "No problem, no problem…."<br />
<br />
Yet, as a manager, I always wanted to know when there were problems. I tried to always reward the messenger and never punish anyone for bringing me news that I didn’t like to hear. Still, I have to admit that I made my contribution to the "no problem" problem. <a href="http://vb123.com.au/index.html?200004_pv_ed.htm">Read more of Peters editorial</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-49387124586350287932018-02-07T14:30:00.000+11:002018-02-07T14:30:00.369+11:00Its Update Access MVP Profile Day<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPwWpz3eg5GLIoRYf-UF_C-a1wwELEUsPBnROpPYvP-rmEawsQyTG8b09asi2hHXvXiM-Uw0Q4ZrJQilV0DWIehQlYM43v1iswqCk0mZUjGRfbAUni44VNsCLU45B4bbOJ-IOq/s1600/nsw+australia+and+mvp.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPwWpz3eg5GLIoRYf-UF_C-a1wwELEUsPBnROpPYvP-rmEawsQyTG8b09asi2hHXvXiM-Uw0Q4ZrJQilV0DWIehQlYM43v1iswqCk0mZUjGRfbAUni44VNsCLU45B4bbOJ-IOq/s1600/nsw+australia+and+mvp.png" /></a></div>
<span style="-webkit-text-stroke-width: 0px; background-color: transparent; color: black; display: inline !important; float: none; font-family: Times New Roman; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">Every now and again I have to update my profile at Microsoft with my activities for the year. Today was that day and <a href="https://mvp.microsoft.com/en-us/PublicProfile/33604?fullName=Garry%20%20Robinson">you can read what I have achieved in the last year here.</a></span><b></b><i></i><u></u><sub></sub><sup></sup><strike></strike>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com1tag:blogger.com,1999:blog-7344884.post-22708024277070460472018-02-06T16:35:00.000+11:002018-02-06T16:35:08.960+11:00Eyewitness Testimony by Peter VogelFrom Peter's Editorial on End User Specifications.<br />
<br />
... We remember things selectively and concentrate on what’s important to us. I also shouldn’t have been surprised that I had filled out my fragmentary recollection with spurious details. We are driven to explain things and, when faced with missing information, automatically make up details to fill in what we know is missing. We tend to fill in our recollection with what we “know should have been there.” The older a memory is, the more likely that that the memory has been “fleshed out” with made-up facts. <a href="http://vb123.com.au/index.html?eyewitness_testimony2.htm">Read more</a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com1tag:blogger.com,1999:blog-7344884.post-18781571927165262002018-02-03T09:28:00.000+11:002018-02-03T09:28:06.442+11:00Creating Paired Listbox ControlsPresenting a pair of Listbox controls to the user and allowing the user to move an item from one to the other is a popular and effective user interface technique. Microsoft Access doesn't provide any intrinsic controls for performing this, but as Rebecca Riordan demonstrates, it's possible to create linked Listbox controls and base them on a single table, two tables, or even data created at runtime. <br />
<br />
<a href="http://vb123.com.au/index.html?200405_rr_listbox.htm">Part one of this Listbox article can be read here</a> and <a href="http://www.vb123.com.au/200406_rr_lbox.htm">part two here</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYbCLBZLCcPeoU6P2vyhfiIt12uyE_WtzQTslw2kwDizIUITBvpHS545gqZdf3vAPPJgoMdwlnp9TrUAdV40X0wzEuAANMkHTxgDj8qLPo2CgG5-6BoxIoNNVeDeCqC1cFESsv/s1600/200405_rr1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="358" data-original-width="429" height="534" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYbCLBZLCcPeoU6P2vyhfiIt12uyE_WtzQTslw2kwDizIUITBvpHS545gqZdf3vAPPJgoMdwlnp9TrUAdV40X0wzEuAANMkHTxgDj8qLPo2CgG5-6BoxIoNNVeDeCqC1cFESsv/s640/200405_rr1.jpg" width="640" /></a></div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-57974090768217925432018-01-27T11:03:00.000+11:002018-01-27T11:03:02.002+11:00Software stagnation - Doing nothing can cost you moneyI have been writing Microsoft Access software now for nearly 25 years. In that time I have occasionally had software projects that have not had any development or support for 5 years or more. If the project was small, starting again is no trouble. If the project was big, getting back on top of the project is either costly to me or the customer.<br />
<br />
<a href="http://vb123.com.au/index.html?2016_gr_stagnation.htm">Read more </a>Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com1tag:blogger.com,1999:blog-7344884.post-72287540724383620102018-01-23T09:19:00.000+11:002018-01-23T09:19:00.733+11:00Get More From Your List BoxesDave Gannon <a href="http://vb123.com.au/200004_dg_listbox.htm">shows you how to sort list boxes</a> using the second column in the box, how to create totals from the rows in the box and also how to search the list box.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifgkmLbMFzeIq8UUl3E7h7ZyJHlhMD6e3q9SfmoYNlbb9po7K_52PvxLTyulYSxBoAESglvUNmk9wnTwarWcf2BTuEW41kU7QZ6PskQxlIPWHQ_h8NDKx_17EnWGe-6Pbw54dl/s1600/200004_dg2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="185" data-original-width="367" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifgkmLbMFzeIq8UUl3E7h7ZyJHlhMD6e3q9SfmoYNlbb9po7K_52PvxLTyulYSxBoAESglvUNmk9wnTwarWcf2BTuEW41kU7QZ6PskQxlIPWHQ_h8NDKx_17EnWGe-6Pbw54dl/s320/200004_dg2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtmlrRf6H2KyetLIrKUX7DuV1ECdYCIHGR0nnKFWZKqbfD4v56fx4cIZKjf_AKCu8620hMCVt2adoBfK4UMEpU75UzKp0oWE3wHHOjaZ9CwvZqR4_lgjBsqYO_0tHnai_FBNSl/s1600/200004_dg1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="348" data-original-width="271" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtmlrRf6H2KyetLIrKUX7DuV1ECdYCIHGR0nnKFWZKqbfD4v56fx4cIZKjf_AKCu8620hMCVt2adoBfK4UMEpU75UzKp0oWE3wHHOjaZ9CwvZqR4_lgjBsqYO_0tHnai_FBNSl/s320/200004_dg1.jpg" width="249" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
Get ahead of the game, follow <a href="https://www.facebook.com/vb123comau/">Garry's Access posts on FaceBook</a><br />
<br />
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0tag:blogger.com,1999:blog-7344884.post-36754380512450548322018-01-16T09:11:00.000+11:002018-01-16T09:11:10.515+11:00Opening Any Old File<h4>
Opening Any Old File</h4>
Doug Steele: If I have a document, how can I how can I open it in whatever program is deemed appropriate for that file type? <span id="goog_1771231444"></span><a href="http://vb123.com.au/200501_ds_rego.htm">Read the article here</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBxBfrlwh3OtM_iHlEXCwh1rZN1jIxgXtUhiIIgeg4AREFm3hFFDHDAfEmMvqrNgHIKfK6X3Q-vVBu2zxwaW4vW7bGL8Xi5n8ieD3AexTFcSb2lewzmT7Jb10FkF_2MJxv1Zmi/s1600/200501_ds2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="224" data-original-width="602" height="119" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBxBfrlwh3OtM_iHlEXCwh1rZN1jIxgXtUhiIIgeg4AREFm3hFFDHDAfEmMvqrNgHIKfK6X3Q-vVBu2zxwaW4vW7bGL8Xi5n8ieD3AexTFcSb2lewzmT7Jb10FkF_2MJxv1Zmi/s320/200501_ds2.jpg" width="320" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />Garry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.com0