checkusergroup() not defined 1

[Xzibit7]

I am getting function not define error when I try to open a form that has a checkusergroup() function in VBA. I have not been able to find a solution to this problem online. Do I need install some additional functions in access or something?

 

[Remou]

Where did you get checkusergroup? It should have come with a function for use in a code module. If you do not need the function you can comment the line.

 

[Xzibit7]

I was using it to only show certain items in a form to certain groups for security.

 

[Remou]

Where did you get it? Did it ever work?

 

[Xzibit7]

It is used in this previous post

http://www.tek-tips.com/viewthread.cfm?qid=1453955&page=1

The function does not work for me however. I thought it was just a built in vba function but apparently not. I am heading out for the day so I'll check back. Thanks for the help so far.

 

[Remou]

It is not a built-in function. You can build your own function using this information:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299691