Modifying Defaults for the Find Function

[CMA]

I am learning VBA, and I manage a small database that is used by managers
with "run-time"

We use a data entry form to search for records. I know a redesign would be
useful, but I am leaving that form later.

Currently when we use a control box labelled "find", the built-in access
find and replace function is used to locate records. The managers wish for
defaults in this find and replace to be adjusted.

In the "Look In" drop down we have two options, and they wish to default to
the second option

In the "Match" drop down the default is "Whole Field" and the managers wish
the default to be "Any Part of Field".

How can I satsify their requests?

The code associated with this function is as follows:

Private Sub Find_Record_Click()
On Error GoTo Err_Find_Record_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Find_Audit_Click:
Exit Sub

Err_Find_Audit_Click:
MsgBox Err.Description
Resume Exit_Find_Record_Click

End Sub

 

[Peter Hibbs]

CMA

Have a look at the section "Have Access search the way you want by
default (95/97/2000)" at -

http://www.computerbooksonline.com/tips/access2.asp

HTH

Peter Hibbs.

 

[CMA]

Peter,

Thank-you for directing me to another useful resource for MS Access.

However, the information within "Have Access search the way you want" does
not solve my problem. The changes did work on my own computer (I am running
MS Access). However, when I went to the computer of a user, the changes were
not implemented, and we don't have access to the "tools/options" menu because
they are using a run-time version.

Could you, or someone else assist me in finding a solution that can be
programmed into the form for the benefit of these users?

 

[Peter Hibbs]

Hi CMA

Not sure what you mean by the 'run time version'. Do these other PCs
have Access installed but have the menus and tool-bars hidden or are
they 'stand-alone' files that have been created for use where Access
is NOT installed. In a previous post you mentioned the VBA code so I
presume you have Access installed and that you can look at the code
which indicates that you are using the .MDB version rather than the
..MDE version.

Maybe you should open the database with the Shift key held down to
display the menus, etc which would give you access to the Tools menu.

Also, if you enable this facility on another database on the same PC
it affects ALL databases on the same hard drive. You could create
another temporary database on the same PC and then set the flag which
will then activate the facility on your main database.

If that doesn't work you may need someone with more knowledge than me.

Good luck with that, let us know if it works or not.

Peter Hibbs.

 

[CMA]

Not sure what you mean by the 'run time version'.

Maybe I am not describing it correctly. My computer has the MS Access
License, theirs does not. They are able to view the Database and make changes
to data, but cannot make changes to the interface or design of the database.

 

[Peter Hibbs]

Hi CMA,

What is your set-up. Are these other computers on a network and if so,
are you using a split database (with a back-end file on a server and a
front-end file on each PC) or are all the PCs just linked to the same
database file.

Peter Hibbs.

 

[CMA]

Our set-up is simple.

We are networked. I manage a single database file using my MS Access License
and this database file is kept in a shared folder.

Other users who do not have an MS Access License can open the file, perform
switchboard functions such as data entry and report running.

I am a far way from solving my problem...

 

[Peter Hibbs]

Hi CMA,

The problem may be because you have not split the database into front
end and back end. See this link for why you should do this -

http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB

I realise that there may be financial implications in having Access
installed on each PC on the network but I think you are storing up big
trouble for the future by not splitting the database (just look at
numerous posts on this subject in this forum).

If you can split the database I suspect that the original Find
facility default settings that I suggested would work OK.

If you can't split, then I suggest you start a new post asking why
this option does not work where other PCs are linked to the same
database file over a network. I can't check that method because I
don't have a network set up here. Be warned though, every reply will
advise you to split the database first.

Good luck.

Peter Hibbs.