we'll be sure to go through all the tsql. and the .net needs upgrading too; it was built on v1! it doesn't even have a master page. user controls on...

thanks.

i've done some searching and see there's quite a discussion going on with this and great info. one link (started in 2002!): http://www.sqlservercentral.com/Forums/Topic8041-65-1.aspx

i think usp might do for my needs....

great. thanks for the help.

- w.

edit:

ah, what do you use, if anything, to prefix sps? i think i've seen sproc_ before. any suggestions? (i'll do some searching too.) tnx again.

i knew i must be missing something.

What do...

i added 3 lines (commented-out). looks pretty close i think ...

With rst

Do

...

it looks like you're comparing rs to only one row in rsadd and not checking the whole table to see if it's there. you're checking one row, if it doesn't...

it's been a while since you posted but i think it's working now. don't use 'date' as the name of a field. hth.

both of these worked for me:

Public Function AdoYesNo()

Dim rs As New ADODB.Recordset

rs.Open "tbl2", CurrentProject.Connection, _

...

beforeupdate.