Recent content by GWPhoenix

On my program, it writes Michael"s contacts when I have it display the executed SQL statement, but when I go to view the recordset itself, it's fine.

Thanks, angst! That will work great. I guess you can tell I'm not the most adept person at this stuff....

Thanks, Feng. Problem is, this is an Access Database.

I have a large form (about 20 fields) in which to update and insert new recordsets. The database is not accepting the apostrophe value as part of a string. I am familiar with the code: Value = replace(value,"'","''") where "value" was the only possible...

In a "view only" table which displays certain major fields of the recordset, I wanted an "X" where the above value was checked. It only started showing accurately when my "If" statement was "If fieldname = TRUE" after trying "0", "1&quot...

Sorry if I came off as unclear. I was trying to not enter so much code. The line of code I entered is part of a "Response.Write" statement. The value is set for true because in an Access Database where the datatype for this question is "Yes/No", it actually holds a...

I have a checkbox where if it is checked, the value is "True" going to an Access 97 database. Problem is, my table is not allowing any but the True value to be entered and will not update the database with a new recordset UNLESS the box is checked (and value would then be TRUE)...

Yes! It worked! Thank you! Time for dancing in the streets! :)

This may be pretty basic, but here goes -- I have a table in Access 97 that is a yes/no checkbox where if the box is checked, it means &quot;yes&quot;. My HTML document shows: <tr><TD>Pref EZ/EC?</TD><td><INPUT TYPE=CHECKBOX NAME=&quot;prefezec&quot; VALUE=&quot;yes&quot;></TD></TR> and...

ymitz -- Thanks for your help, but nothing has changed. I have a DSN, which is NOFA9 (see original code) and it works fine, mostly on my &quot;Read Only&quot; Functions. Any other ideas?

Thanks, but that didn't work. You did, however, make me realize that I had not included my adovbs file, which also didn't help. Still trying other stuff...

I am updating fields in an Access Database, some of which may contain null values. I get an error stating &quot;COUNT field incorrect&quot; on the following statement: oRS.Open strSQL, objConn I have attempted to use objConn Execute strSQL I have worked on a similar program before (in...

Thank you both! It works great now! I am more familiar with working in SQL Server, so I have allowed myself to be careless about closing the connections.

I am working on a number of pages which have the following connection code. When I go to load the pages in a browser (IE6), I get an &quot;Unspecified Error&quot; which points to the line which reads &quot;objConn.Open&quot;, although sometimes the page loads properly only to receive the error...

That was it! Thanks mucho! Couldn't see for looking.