Using the Registry. How to know if Key exists?

Cross posted at Access World.
http://www.access-programmers.co.uk/...d.php?t=182552

This is a sample structure.

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\GeoMeasure\CMM Data\SomeKey

The text in orange is the Section Name, the text in violet is the Key.
Writing to and reading from the registry is easy to do, determining if a "Key" exists is not so easy.
In this case the string "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" will always be the same, its the standard naming thru VBA.

How can I find out if a specific Key exists in "HKEY_CURRENT_USER\Software\VB and VBA Program Settings"?

FYI
There is an example for "IsBroken" but it appears to be for file association only.

You can use GetAllSettings:

Please Login or Register  to view this content.

Thank you, your example works for "Section Name", not Keys which means I did not ask my question correctly.

I have fixed my original question as follows:
This is a sample structure.

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\GeoMeasure\CMM Data\SomeKey\

The text in orange is the SectionName, the text in violet is the Key.
Writing to and reading from the registry is easy to do, determining if a "Key" exists is not so easy.
In this case the string "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" will always be the same, its the standard naming thru VBA.

How can I find out if a specific Key exists in "HKEY_CURRENT_USER\Software\VB and VBA Program Settings"?

You can still use the code above. If the App Name and section exist, then the returned value is an array of keys and values, so you just need to loop through it.

A simple change to romperstomper's example worked out.

Please Login or Register  to view this content.

Strange how "IsEmpty(varSettings)" did not work.
Using:

Please Login or Register  to view this content.

Displays an empty messagebox when I use a Key that doesnt exist.

Strange how "IsEmpty(varSettings)" did not work.

From Help:

GetSetting(appname, section, key[, default])

The GetSetting function syntax has these named arguments:

appname Required. String expression containing the name of the application or project whose key setting is requested. On the Macintosh, this is the filename of the initialization file in the Preferences folder in the System folder.
section Required. String expression containing the name of the section where the key setting is found.
key Required. String expression containing the name of the key setting to return.
default Optional. Expression containing the value to return if no value is set in the key setting. If omitted, default is assumed to be a zero-length string ("").

I did read that in my help file, and I am failing to understand why IsEmpty did not work.
I guess I am not understanding how to use IsEmpty.

IsEmpty fails because the function returns "", and so the Variant actually contains an empty string, not nothing.

Also, Empty <> IsEmpty(). Run this and look at the results in the Immediate window:

Please Login or Register  to view this content.

Please Login or Register  to view this content.