Recent content by sjohnson77

Thank Newman, but I have explored that option and it doesn't appear to be the solution. I know it appears like there are recordsets still open, but the first MyRS.Open runs and update query, which closes itself as soon as it runs (doesn't require an MyRS.Close).

Error Type: Microsoft VBScript runtime (0x800A01FB) An exception occurred: 'Open' /bingohopasp/post.asp, line 428 I am getting this error when trying to insert a record into a recordset. It also locks up access and the only way to free it up again is to reset IIS. The insert works with some...

Thanks Gromit g- Thanks for all your help and time looking into this. I was hoping to keep it in "stored procedure/view" form, but have now decided to just pass the entire update string to Access, instead of just the parameters. This method seems to work fine, but still frustrates me that it...

Arg* Thanks g, but I have done that. Sorry I haven't listed through all the things I have tried. I've also notices that if I only supply 1 value to the variable([Enter MessageIDs]), it updates just fine. I am perplexed.... Thanks Steve

This is driving me absolutely insane, can anyone find why this won't work? UPDATE tbl_PrivateMessages SET tbl_PrivateMessages.RecipientStatus = 1 WHERE tbl_PrivateMessages.MessageID IN ([Enter MessageIDs]); I've tried updating it through ASP with the following: Execute UPDATE_INBOX_MSG_STATUS...

Sorry, Pat, I do apologize. I'm new to the forum and did do a couple searches, but in the wrong categories, so I found no results. I found some help from MS last night just before I left the office and was able to successfully implement it this morning. Much thanks, Steve Johnson BTW - Here...

I think I may know... When sorting UNION queries, I believe that you have to ORDER BY the column number, rather than column name. If both column names do not match, it confuses the system. SELECT 0,"<<ALL","TEAM MEMBERS>>" from Contacts UNION (SELECT Contacts.ID, Contacts.[First Name]...

Is there a way to update a field in a sorted query with its recordnumber value, as if to assign a rank to it? Example Table contains Name, Grade, Rank sorted by Grade ASC Record 1: John, A, *Update here* Record 2: Tony, C, *Update here* Record 3: Eric, D, *Update here* The *Update here* is...