Search results for query: *

SQL 2000 SERVER In SQL SERVER Enterprise Manager. I have a table, and this table has no primary key or index key defined, and it does not have any relationship with other table. When I try to delete a row it gives me an error. Error: Key column information is insufficient or incorrect. Too...

SQL 2000 SERVER In SQL SERVER Enterprise Manager. I have a table, and this table has no primary key or index key defined, and it does not have any relationship with other table. When I try to delete a row it gives me an error. Error: Key column information is insufficient or incorrect. Too...

Access 2003 The query below work, when it is in a saved query, but when I put it in VBA it gives me an error. Syntaxt error into insert statement. ////////////////////////////////////////////// Private Sub Input_Training_Records_Click() Dim Dbs As DAO.Database Set Dbs = CurrentDb...

2) SQL 2000 Server Why a Data Type of "timestamp" in an SQL table that have an eight characters limit can hold The value "Aug 9 2006 4:56PM" and SQL did not flag any error ?

Access 2003 and SQL 2000 Server. Why the field "Last_Access_Date" was not updated in table User_Account. cmd.CommandText = "UPDATE User_Account " _ & "SET Last_Access_Date = '" & Now() & "' "& "WHERE Name = '" & Forms!Main_Login!User_Name & "';"...

Access 2003, and SQL 2000 Server Run-Time error '3711'. Operation cannot be performed while executing asynchronously. //////////////////////////////////////////// The first code below work, but the second one immediately after this fail. cmd.CommandText = "INSERT INTO Table_User_Log_On (...

Access 2003 and SQL 2000 Server. All tables resided in the SQL 2000 Server. All tables are linked using ODBC. The user interface is Access 2003 Run-Time error '3709' The connection cannot be used to perform this operation. It is either closed or invalid in this content The yellow highlight...

Access 2003 and SQL 2000 Server 1) ADO code does not work. I had the two code below to print out the two value and they are both the same, yet, it executed the else condition. MsgBox RecordSet_User_Account!Name MsgBox Forms!Main_Login!User_Name If RecordSet_User_Account!Name =...

Access 2003 Run-time error 438. Object does not support this property or method. /////////////////////////////////////// Public Sub Public_Disable_Text_Boxes(Form_Name, Public_Department_Name) Dim frm As Form Dim ctl As Control Set frm = Form_Name Select Case Public_Department_Name...

Access 2003 How to capture the current record, when a user click a move-next arrow button on the control box. ///////////////////////////////////////////// A form has three fields: Customer_Number, Customer_Name, and Ordered_Date When a user click an arrow-star button on the control box...

Access 2003. How to send an email without Outlook showing a dialog box, and with attachment. The code below will send an email without showing the big window, but it did not have a file attachment although I did specify the name of the file which is "Report_Drawing"...

Access 2003. Can a source name in table definition is set to be a query, such as shown below ? Set Table_Definition = Dbs.CreateTableDef(Query_Name) The code below does not have any error, but it also did enter the loop. The Query_Name is equal to "Query_CrossTab", and the Field_Name is...

Access 2003 The code below did not print out the name of the fields in the table. The For Each was never executed. /////////////////////////////////////////// Sub Determine_If_A_Field_Exist() Dim Dbs As Database Dim Table_Definition As TableDef Dim fldLoop As Field Set Dbs =...

Access 2003. How to have the bar chart list item in descending order by numerical value and not by category name ? On the graph Y axis (vertical axis) is the numeric value X axis (horizontal axis) is the name of the Defect_Category On the query Field: Defect_Category Department_Name...

Access 2003 How To Loop through an array of combo boxes and print its value. There are 5 combo boxes and their names and values are CB_Symbol_1 = AB CB_Symbol_2 = CB CB_Symbol_3 = MB CB_Symbol_4 = XZ CB_Symbol_5 = IB The code that does not work is MsgBox Len( '""& Me!CB_Symbol_" & I & "'...

Access 2003 Is there a string function that will compute the total number of a particular character within a string without using a string array and a for loop ? Private Sub Compute_The_Number_Of_Spaces_Within_A_String Dim A_String As String A_String = "Hello There Everybody" 'There a 3...

Access 2002. SQL 2000 Server The procedure below does run and gives no output message, but the statement below did not execute. MsgBox rst!ord_date /////////////////////////////////////////// Private Sub ADOAsyncQuery_2() Dim cnn As ADODB.Connection Dim cmd As ADODB.Command...

Run-Time Error '3146' ODBC - Call Failed Error at statement cnn.Execute strSQL ////////////////////////////////// Private Sub DAO_SP() Dim wrk As DAO.Workspace Dim cnn As DAO.Connection Dim qdf As DAO.QueryDef Dim strConnect As String, strSQL As String Set wrk =...

Access 2003. SQL 2000 Server Run-Time Error '-2147217900 (80040e14)': There is already an object named 'UpdateAuthors' in the database. How to prevent an error when a stored procedure already exist /////////////////////////////////// Private Sub ADO_SP() Dim cnn As ADODB.Connection Dim cmd...

Run-Time error '13'. Type mismatch Yellow Highlight At: For Each err In DBEngine.Errors //////////////////////////////////////////// Private Sub DAOAsyncQuery_1() Dim wrk As DAO.Workspace Dim cnn As DAO.Connection Dim strConnect As String Dim err As Error On Error GoTo...