HELP! Errors after ACCESS to SQL

Most things work correctly but there are a few errors that I get in certain places on the forums.  Here is what I get when I try to register.  The error occurs after filling in user information and clicking the register button:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Author_ID', table 'InsideStilesForums.dbo.tblAuthor'; column does not allow nulls. INSERT fails.
/webwiz/forum/register.asp, line 821

This next error happens when I try to add a user to my buddy list:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Address_ID', table 'InsideStilesForums.dbo.tblBuddyList'; column does not allow nulls. INSERT fails.
/webwiz/forum/pm_add_buddy.asp, line 152

I checked the SQL tables and it is like the forum isn't trying to put a number in those fields.  Should I allow NULLS in the tables?  Or should I be looking somewhere else?  Please help!

Well that took care of those problems.  Thanks for your help.

Now I have some new ones that hopefully you can help me with.

After adding a new test user I click on the Members List button and get the following:

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/members.asp, line 341

I also get the following error if I click on the membership admin button on the admin page.  It must have to do with this CLng field or value.

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/admin/select_members.asp, line 279

Please help.  Thanks

Ok I started from scratch.  Made a new database, ran the MS SQL setup, i comletely configured the forums from the admin page, I registered a test user (so far all is well).

I went to test posting for the first time and I get this:

Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'CuLocation'
/webwiz/forum/post_message.asp, line 590

Any suggestions?

THANK YOU THANK YOU

That worked.  That was the only thing that I couldn't do.

Thanks again.