Search results for query: *

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.

I am running the following code reading the records of a table in Access. I get the following message Microsoft VBScript compilation (0x800A03FB) Expected 'Loop' siting the line where I am setting the objRS to nothing at the end. Any ideas what's wrong? <TABLE BORDER=1>...

lobstah -- Thanks so much. I had actually originally obtained some code something like what you are suggesting here, but yours makes a lot more sense. I will be trying this. :-D

When I set the values to &quot;0&quot;, it works fine! My problem is that some of the fields may have to remain Null. All the fields that I am updating are numeric and in the Database design, that is permitted. I don't know if I can (per my client's instructions) just set everything to zero...

Yes! numPool and numTrans are both empty! Does this make a difference? If so, what should I do for these fields, some of which will remain empty?

I am trying to update fields in a SQL Table which already has all the States and some data in it. I keep getting an error of &quot;Incorrect Syntax near ','. What am I missing or not doing right to return my values to a &quot;Read Only&quot; page here? The form data from the previous page is...