Hi opainc
I think you should be able to do the things you want to do within access.
If you setup a routine, you could run a query which outputted your records into a temp table in Title Case, or straight into excel.
This link http://support.microsoft.com/default.aspx?scid=kb;EN-US;291323...
On the "Find button" the onclick event will start the search. Either you used the wizard, or you have your own. Either way....
dim searchTerm as String
searchTerm = """*" & Me.txtSearchTerm.Value & "*"""
This will append wildcards (*) around the search term. Then use the string as required...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.