Trouble with user password change form 1

[mguidry5]

I'm trying out the user password change form in faq702-4282, and I've run into a snag.

I'm getting an error message "User-defined object not defined" in the dim grp as DAO.grp segment of code in

Private Function UserIsInGroup(UserName As String, GroupName As String) As Boolean
    Dim grp As DAO.Group
    
    On Error Resume Next
    Set grp = DBEngine(0).Users(UserName).Groups(GroupName)
    UserIsInGroup = Not grp Is Nothing
    Set grp = Nothing
End Function

Any ideas?

 

[KenReay]

Hi

Are you using Access2000 or later version?

If yes, are you sure you haev set a reference to the DAO library?

If not, do so, in any code module design view, choose Tools\references and select the DAO library from the list

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mguidry5]

Thanks, KenReay. That was a rookie mistake. I forgot where to set references.