Custom Registry Settings in Microsoft Access
Provided by: FMS Development Team
To store a value to the registry, use the SaveSetting command in VBA.
SaveSetting appname:="MyApp", Section:="Startup",
This statement will make a new Key named "MyApp", a sub key named "Startup",
a String value named "Top" with a value of "75" in the following location:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\
To view the change to the registry, click on the Window Start Button and
click the Run... option. Enter: Regedit and click OK. The registry will
open, and you can browse the tree to locate the entry. (Don't delete or
modify anything, as it may have detrimental effects on your system!)
To retrieve your custom settings, you can use the GetSetting or the
To delete the registry keys that you made, use:
DeleteSetting "MyApp", "Startup"
See the Microsoft Access Help File for more information.
Return to the tips page