form reacting differently depending on how db is accessed
am 15.11.2007 19:08:32 von rdpacerI 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!