changing Find & Replace settings for all users

[Guest]

I have users on about 25 different computers using my database. I know I can
go to Tools -> Options to change the Find & Replace function to default to
"Any Part of Field" instead of "Whole Field". However, it seems that the
change only works on my computer. When a user opens the database from
another computer, the change is not there. Is there anyway to change the
default attributes of the Find & Replace feature for everyone? Or will I
have to go around and change the options on everyone's computer?

Please let me know if additional info is needed. Thanks for any help.

 

[Guest]

Check out Application.SetOption. Below are some I used in A97 databases.

'Set some database defaults found in Tools, Options
' Put in the Open event of the startup form
' Set Default Locking to Edited Record
Application.SetOption "Default Record Locking", 2
' Set Default Open Mode for Databases to Shared
Application.SetOption "Default Open Mode for Databases", 0
' Set Default Find/Replace Behavior to Start of Field Search
Application.SetOption "Default Find/Replace Behavior", 2

In the case of "Application.SetOption "Default Record Locking", 2" Default
Record Locking has three choices and the one I want is the third so, of
course, I put in 2 for the arguement. That's because it starts numbering at 0
instead of 1.

Put the above code in the Open Event of your opening form. One other strange
thing is that the database may need to be opened and closed twice on the
user's computer for the change to take effect. The first time the database
opens, it makes the changes. The second time the changes are in effect.

 

[Guest]

Makes sense, but my database opens to a switchboard form, so there is already
an event in the On Open slot. How do I get around that? I tried putting it
in the On Load slot, but after opening closing like you suggested, the Find &
Replace still searches on the Whole field.

Also, do you know, can you change just the number "8" in correct line of the
Visual Basic code to allow more than 8 buttons on the switchboard?

Thanks!

 

[Pieter Wijnen]

just append the code to the onopen event code

Pieter

 

[Guest]

I don't know how to do that. I tried adding it behind the Event Procedure
that's already in the On Open event slot, but that doesn't work. Can you
give me more details on how to do it?