Run-time error 438 Run-time error 438 – Object doesn't support this property or method. – (Microsoft Access) This problem often occurs when you Loop through a set of controls with a For Next Loop. It happens because you are examining the properties of a control. However not all controls have the same properties. Different Controls, … Read more
Use “Value” or Not? I’ve noticed a couple of minor glitches caused by the default of a ‘textbox’, the value; not being assigned explicitly. It’s not a big problem and I don’t think it will affect many people, possibly nobody! However I think there’s a good blog in it for someone, possibly me, when I’ve … Read more
Nifty Gotcha’s Most of the time MS Access provide some Nifty features which help you develop your code. However sometimes MS Access can be too helpful; the additions alterations to your code that MS Access makes can really mess you up! I’ve started a list of them here:- Access takes Liberties MS Access takes Liberties … Read more
You cannot Always omit “Value” I often see people are advised they do not need to refer to a Control’s Value implicitly like this:- Dim strValue As String strValue = cboCurrent.Value This advice is given because “Value” is the default, therefore it is unnecessary to append it, So you could write the above like this:- … Read more
Multi Value Fields Links Can you imagine in Microsoft offices, some bright spark, probably someone from marketing comes in and says, MS Access Needs “Multivalued Fields” – we’re going to make MS Access easier for people to use! Can you imagine, all the developers jumping up and down and shouting NO! I can understand the … Read more
