Domain Function builder

[jwm]

In an exchange with Tony D'Ambra at aadconsulting.com, Tony forwarded me an
Access 97 Domain Function builder add-in, which I haven't tried as I have to
re-install A97 to try it.

Tony advised that MS never issued any updates to the add-in. Accordingly, is
anyone aware of an updated version of the add-in which would run on
A2003...available elsewhere?

Actually, what I'm seeking is a tool which would convert SQL to a DLookup
expression as I invariably leave out a parenthesis, quotes, or commas. LOL

TIA.

 

[Douglas J Steele]

You should be able to convert the Access 97 add-in to Access 2003 without
difficulties.

 

[jwm]

It's in mde format. Tried converting it and threw it in the Add-Ins
folder...both to no avail.

jwm

 

[Douglas J Steele]

Sorry, I was assuming it was part of the unlocked wizards that Microsoft
provided for Access 97.

http://support.microsoft.com/?id=172183 is the article about the add-in, but
the download link isn't working for me at the moment (seems to be a proxy
error, though, not an invalid URL)

 

[jwm]

No problem...I don't even remember it being in A97...must have missed it
completely.

However, it seems to me that an add-in, or capability within Access itself,
to take a SQL statement or Query, and convert it to a DLookup expression
would be a rather nifty addition.

jwm