Search results for query: *

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...

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)...

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...

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...

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...

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>...

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...

I have fields in my program that needs to accept numbers and only numbers (i.e., characters 0123456789). Right now my program as follows sort of shrugs and accepts whatever is put in (FormatData = Value). Anything else I attempt (i.e., Response.Write &quot;Must be numeric&quot;) comes out very...

I want my Question Set (and accompanying textboxes) to display when the user enters &quot;Edit&quot;. This stuff was showing up before; it does not do so now and I have no idea what I did. I have a clue it is somewhere within the SQL statement, but not sure where...

I have a form where the Administrator selects an Applicant (in hard-coded drop-down), Report (Radio Button), and which user will do the specific report; the users coming from the log-in table. This moves me to subroutine AddNew, where I will either be informed that this specific report is...

I have a script which stores values successfully to a database through textbox, drop-down and radio buttons. (going through &quot;Update&quot; and returning values in &quot;View&quot;) However, when I return to the &quot;Edit&quot; screen, from which I originally entered the values, only the...

I'm trying to figure out what does not happen here. I insert some data in &quot;AddNew&quot;, the text values but not the radio button information are then returned in a page labelled &quot;Edit&quot; after passing through &quot;Insert&quot;. When I fill in the radio button info on...

I am trying to populate some questionnaires with the following code. Some of the answers will be in text boxes, the others will be using Yes/No Radio Buttons. The code for the output table of questions is as follows: Response.Write &quot;<table>&quot; do until rst.EOF Response.Write...

My system crashed and I had to re-install Windows 98 SE yesterday. I can no access Enterprise Manager and get a pop-up window that says &quot;Unable to create a Node Manager. Make sure MMCNDMGR.DLL is registered.&quot; I have this dll file in my Windows/System but have no idea how to register...

I need to transfer large databases between SQL Servers. So far it works quite well using DTS, but the Login passwords in the destination database have null passwords. I know this is how it works according to Microsoft Support, but has anyone found a workaround on this? I am dealing with...