Recent content by guy.murray

Hi all, I have an Access 97 database working as a web database. Is there any way of opening the Access DBMS without locking out all the web clients? many thanks Guy

Ignore this post, accidental duplication

Brilliant! Just what I needed. many thanks Guy

Hi, I have a subForm in which I have defined a subroutine. I want to call this subroutine from an event in the parent form. Would be much obliged if someone could explain how to do this. Guy

Many thanks for your efforts! Guy

Thanks for replying. Produces the same error message. Curiously, putting "msgbox text1.Value" before calling the subroutine behaves as one would expect. The Subroutine seems to treate the object reference as synonymous with its Value property. I wonder what happens with later versions of...

Hi, am trying to pass a textBox object (Text1) to a subroutine as in the following simplified eg... Public Sub testSub(objRef As Object) MsgBox objRef.Value End Sub Private Sub Text1_AfterUpdate() testSub (Text1) End Sub This just produces an "Object required" Run-time error...