Search results for query: *

I have a relational database that has several fields in it (color, product, format, type, etc). I want the user to be able to identify products based on the defect, format etc. I can write an SQL statement that gets the products if I specify the color programmatically. For example, SELECT...

How do I display the "connect to server" dialog box? I tried clicking Start, Visual Studio 2005 without success. How do I get to the "connect to server" dialog box? Charlix

I am having a problem using the CreateNewUser control in Visual Studio 2005. When I fill in the text boxes with the user information it doesn’t create a new user record in the aspnetdb.mdf database and displays the following error message “Password length minimum: 7 Non alpha-numeric...

I am trying to learn to use asp.net Web application template in the Hello World Tutorials for Visual Studio 2005. When I call up the default.aspx file by clicking it in the solution explorer I get the default.aspx file with the "client side objects and events" tab. How do I get the "SERVER...

Hi everyone, Is it possible to use the msFlexGrid on a web page where the client does not have VisualBasic6 installed? It works fine on my computer but doesn't show on other computers. I have included MSFlexgrid.ocx file but that doesn't help. If I can't use the MSFlexgrid on a web page is...

Hi, I have been unable to delete cetain records from a relational MS Access database.I can delete those records where there is a one-to-one relation between the primary and foreign table BUT I can not detlet the records from the primary table where there is a one-to-many relation. I get the...

Hi, I get the following error message when I try to remove a one to many relationship in my database programatically: ******* arguments are of the wrong type, out of acceptable range or are in conflict with one another ******* This is the code I am using on my asp page" *******************...

Hi, I hope I'm posting this on the correct forum. I get the following error message when I try to remove a one to many relationship in my database programatically: ******* object required '[string: "C:\Caps1\CapsDb1.mdb"]' ******* This is the code I am using on my asp page"...

Hi, I get the following error message when I try to remove a one to many relationship in my database programatically: ******* object required '[string: "C:\Caps1\CapsDb1.mdb"]' ******* This is the code I am using on my asp page" ******************* Set db = "caps1\capsDB1.mdb" set...

I am trying to edit a field in an MS Acess database before the asp page sends it to the user. rs = "(SELECT [Home Code] FROM {User Table]" rs("Home Code") = 1 works, BUT if I try to make it general with code rs = "(SELECT [Home Code] FROM {User Table]" "rs(" & Chr(34) & "Home Code" & Chr(34"...

I would like to remove the menu bar and tool bar from a secondary window. The following code brings up the secondary window but the menubar = 0 and toolbar = 0 have no effect. <a href="Caps.htm" target="_blank", menubar=0, toolbar=0 >Help Page</a> How do I remove the menu and tool bars from...

I have a 'help manual' that I call from an asp page with the following code: <a href="html\HelpManual.chm" > Help Manual</a> This puts the Help Manual in a separate window above the asp page. When I click the ‘x’ in the upper right hand side of the window the window closes and the asp page...

I have a multi-line text box on an asp page that I want the user to enter data. <Text Area Name= "Comments" Rows = 10 Cols = 30 > </Text Area> The data is saved to a Microsoft Access 2000 database in a 'memo' data type field. The information stores properly in the database (i.e., if I...

I am having trouble writing a select statement for an sql. I want to select all items for using three variables that can each have values of 0,1,2,3. I want items that are "0" to always be included. This is my select statement: "SELECT * FROM [Table1] WHERE [Variable1] = 0 OR [Variable1] = 1...

I have a combo box (<SELECT Name = "Defect" >) and a text box (Name = "txtDefect"). I want to copy the value of the combo box into the text box on change. However, it only transfers the value up to the first space. The code I use is: ******************************************** <Script...

I want to have a dll return a recordset to an asp page for processing. My dll is ************ Public Function getOld() As Variant Dim adoConnection As ADODB.Connection Dim rs As ADODB.Recordset Dim connectString As String connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data...

Could anyone tell me how to activate a given command-button by clicking another one on an ASP page. I tried the following three snippets without success. <SCRIPT LANGUAGE="VBScript"> Sub Command1_onClick() Command2.onClick = True End Sub </Script> <SCRIPT LANGUAGE="VBScript"> Sub...

I have an ASP page that has a listbox control that is populated with a list of 'clients' and 'title' by the following code. --------------------------------------------------- Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;) conn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; _...

Hi: Could someone explain why I can recover only numeric values from my database on an ASP page when I enclose the code within <SCRIPT LANGUAGE=&quot;VBScript&quot;> </SCript but can recover both numbers and letters when I enclose the code withing <% %> as in the following code snippet...

When I call the following dll from my ASP page. I get error message “Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only. “ ******************* Public Function setVisitor(ByVal userName As Variant, ByVal password As Variant) As Variant Dim...