Run-time error 438

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

Value

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

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

TempVars Value Error

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

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

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.