As you start to do more and more advanced vba development you may have the need to determine whether your user is using the full blown version of MS Access or the runtime version. Some code/procedures will throw errors in the runtime, that normally would not in the full blown version of MS Access. So how can you determine this? Well, it is surprisingly simple! A simple IF statement can determine this for you, as shown below.
If SysCmd(acSysCmdRuntime) = False Then 'The user is using a full blown version of MS Access Else 'The user is using the runtime version of MS Access End If
Monday, November 1st, 2010, 4:16 pm | 
MS Access VBA Programming | 
RSS feed
Pinging is disabled. But you can skip to the end and leave a 
response.