Changing Access Control Defaults

[Guest]

There are two items that I am looking to change. The default setting for a
find and replace is Match Whole Field and I know there is a way to, through
application setup, change the default to Any Part of, I just don't know how.
Also, in the insert object window, can you set the default to be Create from
File rather then Create New. If so, please help, and I wouldn't know exactly
where to place the code. I saw a reference to VBA application setup but I
can't find it.

Thanks in advance for any suggestions.

Mark

 

[Guest]

Hi,
you might want to concider creating your custom solutions for these options.
There are ways to manipulate the find and replace tab e.g.:
http://support.microsoft.com/?kbid=208923
But you will be better off doing your own search and showing the user really
only what they need to see.
For the instert part you could use an api call to open the standard
open/save dialog e.g.:
http://www.mvps.org/access/api/api0001.htm
This will return the full path of what was selected and you can then store
this value, or use it at runtime to display/open whatever it leads to.
HTH
Good luck