form reacting differently depending on how db is accessed

form reacting differently depending on how db is accessed

am 15.11.2007 19:08:32 von rdpacer

I have a database form where users frequently use ctrl-F to find a
record. Doing so brings up the Find and Replace box.

When accessing the database directly, as in my case as the developer,
the search function displays the "...item was not found" message. The
users however do not receive this message box. Instead, they receive
a small note in the bottom left corner of the database telling them
them "[search text] not found".

As much as I'd like them to just look in the corner there, they really
prefer having the message box because it makes things easier.

They access the database through a "portal" Access database where they
click on a button, enter their password, and it launches the
following:

Dim appAccess As New Access.Application
appAccess.OpenCurrentDatabase ("database_path"), False
appAccess.DoCmd.RunCommand acCmdAppMaximize
DoCmd.Quit acQuitPrompt

Does anyone have ideas on why using this method changes the way the
basic Find/Replace function displays its results? I've checked the vb
References and have found no differences.

Thanks!

Re: form reacting differently depending on how db is accessed

am 19.11.2007 21:07:20 von rdpacer

Just bumping this back to the top of the list, since the board has
been hit by those MI5 postings.