Thanks for the reply, Jim
I found something kind of similar to that about 8 pages deep in my 30th
google search. Of course, the idea is to indicate that the record is locked
before a user wastes time editing it, but the old post I saw I think was
indicating that you could try to update the record on the form's current
event which would throw the error if it were being edited and at least you'd
know, at the time you first entered the record, whether or not it was locked.
Anyway, I may have to play around with that idea a little more. I do
appreciate the response.
CW
"Jim Burke in Novi" wrote:
> I've never used this so I can't say it will do exactly what you want, but
> there's a 'Record Locks' Form Property that you can set to 'Edited Record'. I
> think that this will give a user a default Access error message telling them
> the record is locked. I would think you could find out the error number for
> that message, then in the form's On Current event you could code an On Error
> statement, and check for that error number, and when that error comes up you
> could display your own message in place of the default Access message. I'm
> pretty sure the Record Locks property should work, but the part about
> capturing that error for your own display I'm not sure at all. Like I said, I
> haven't tried this!
>
> "Cheese_whiz" wrote:
>
> > Hi all,
> >
> > I have some forms where I don't want the record selector visible, so the
> > little pencil that indicates a record is currently being edited by another
> > user doesn't show up. Is it possible to check that in vba?
> >
> > Thanks,
> > CW
|
Similar Threads
