Is Record Open

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

can anyone please point in the right direction for the problem i have below.

i have a multiuser database and when 1 user opens the form to edit a record i
want to be able to show a message box if another user tries to view/edit that
same record that will prevent the form from opening.

of course when user 1 has closed the record user 2 can then open it.

any help ...

thanks
Lee-Anne


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200508/1
.

Relevant Pages

  • Is Application running or not/Set Application in foreground
    ... When my program lost focus - cause the user opens another program. ... Martin ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)
  • Start a new record when opening form
    ... On my databases, I ... would like to set up the forms so that when a user opens the form it will ... Thanks Folks!! ... Prev by Date: ...
    (microsoft.public.access.forms)
  • System Crashing while opening HTML Code
    ... If a user opens following code, the system crashes. ... <HTML> ... Prev by Date: ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Timestamp on form
    ... user opens the form to enter a record the "In" automatically insert the ... they will selcet "completed" from a drop down which ... Prev by Date: ...
    (microsoft.public.access.forms)