GetSetting Function

  • Thread starter Thread starter jbc
  • Start date Start date
J

jbc

Hi,

I have 3 dates that I've stored in the registry. Several
queries need to access these dates and I don't want to
retype them each time I run the query.

I use a command in Word called GetSetting that allows me
to pull information from the registry. I noticed that
there is a similar built-in function command.

I can't figure out the correct syntax to get it to work in
the query.

GetSetting("OrgName", "Mailings", "DateMailing3")

I want it to use the value in DateMailing3.

Thanks.

jbc
 
GetSetting("OrgName", "Mailings", "DateMailing3", "default value")

But you won't be able to call it in a query; the Jet Expression Service
doesn't recognise it. You'll need to create a public function to call it for
you, and then call *that* function from SQL.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top