In Chapter 7 when I click on the "Add" icon in the toolbar for the Groups panel, I get an error message saying "Undefined function 'Dete' in expression." I've searched every piece of code and every SQL query in the database and found nothing about 'dete' (whatever that is). Thanks for any help!

I did find a solution to this problem, but I don't understand why it works! For the usp_InsertGroup, I had originally used the SQL code shown on pg 161. This produced the mysterious 'Dete' message. However, when I rewrote the SQL code to :
"INSERT INTO Groups (GroupID, GroupName, GroupDescription, LastUpdateDate )
SELECT [@GroupID] AS Expr1, [@GroupName] AS Expr2, [@GroupDescription] AS Expr3, Date()+Time() AS Expr4;" the insert worked like a champ. I'm using XP Pro and Access 2003. -
Thanks - Dee