C
CLEMAY
Hi~
DB is split - and has links to a non split database on a
network that is only used to pull reports. The split
database is used for data entry purposes and is only used
by three individuals on a daily basis. Recently one user
has been locked out by another when using spell check
button on a form. Code is as follows:
Private Sub Spell_Check_Click()
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
SendKeys "{F7}"
End Sub
The locked user can not continue until either the other
user that is locking the form goes to a new page or closes
the form. Any suggestions.... I thought about doing a
sendkeys function at the enter event of one of the very
first fields to select f9. Thanks CLEMAY
DB is split - and has links to a non split database on a
network that is only used to pull reports. The split
database is used for data entry purposes and is only used
by three individuals on a daily basis. Recently one user
has been locked out by another when using spell check
button on a form. Code is as follows:
Private Sub Spell_Check_Click()
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
SendKeys "{F7}"
End Sub
The locked user can not continue until either the other
user that is locking the form goes to a new page or closes
the form. Any suggestions.... I thought about doing a
sendkeys function at the enter event of one of the very
first fields to select f9. Thanks CLEMAY