Window Control

  • Thread starter Thread starter Zanstemic
  • Start date Start date
Z

Zanstemic

Currently I have a data entry screen that the user sometimes navigates away
from in order to send emails or make phone calls. When they return, they
sometimes forget the window is open and they open a second window and
recreate the record.

I'm looking for a way to control Access windows while allowing them to go to
Outlook.

Any suggestions are appreciated on how to best approach this with Access.
 
Currently I have a data entry screen that the user sometimes navigates away
from in order to send emails or make phone calls. When they return, they
sometimes forget the window is open and they open a second window and
recreate the record.

I'm looking for a way to control Access windows while allowing them to goto
Outlook.

Any suggestions are appreciated on how to best approach this with Access.
Click to expand...

Check to see if the form is loaded before trying to open it again.
Private Sub Command6_Click()
If CurrentProject.AllForms("Form1").IsLoaded Then
MsgBox "Form1 is already loaded"
Forms.Item("form1").SetFocus
Else
DoCmd.OpenForm "Form1"
End If
End Sub
 
Upgrade to a better caliber of user!

;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted viahttp://www.accessmonster.com
Click to expand...

Only problem with that is that it causes system crashes when you try
to run the update... maybe MS and human OSes are incompatible.....?
 
Back
Top