Search results

Hi, I have two tables T1 T2 TID | Len TID | Len2 22 2 22 3 22 4 I need a query to...

Hi, I'm trying to write a query to delete the duplicate records in a Table The table (Table1) contains a single column (TestInput) with many records. I would like to delete the duplicate records from this table leaving atmost one of the duplicate. I tried to write the query as: delete T1 from...

Hi, I have a table as shown below Field1 53 80 47 66 92 How can i write a query to retrieve the sum of all rows in column 'Field1' Can any one of you please let me know. Thanks.

Hi All, I have a select query which selects couple of fields in a table. These fields are used to insert in another table. I just want to know on how can i select and insert the records inside a for loop, which tranverses all the records in the table. Please let me know. Thanks.

Hi, I have a form with a combobox which contains list of school codes stored in a table. The table contains school code and school name. Whenever a school code is selected in the combobox, I would like to display the School Name in control tip text. But i couldnot able to figure out when can...

Hi, I have a form (with some fields) bound to a table. I use this form to add and delete records present in the table using save and delete buttons on the form. I have entered all the details (with unique primary key field) in the form and hit save and able to save the record. I have closed...

Hi, I have a query as shown below which gets called when a button is clicked. For each student i have subjects upto 12, which can be entered on form inside textboxes (txtSubj*). stSql1 = "UPDATE [STUDENT] SET [STUDENT].[SUBJ 1] = (" & txtSubj1.Value & ") WHERE [STUDENT].StudentID = " &...

Hi, While I'm trying to run "insert into" query when "save" button is pressed, i'm getting the following error: "No value given for one or more required parameters." Below is the query: stSql = "INSERT INTO [CUSTOMER] (CustID, Weight, AGE) VALUES (txtCustId, txtWeight, comboAge)"...

Hi, I have a already existing form and subform. I would like to create another form which is similar to the existing form with different fields. Please find the attached form which i want to create. Can any one of you please let me know on how to create the subform "Specimens2" in the...

Hi, I have an MS access 2007 form which is bound to Access Table. The table contains two fields "first" and "second". The same fields are also present in the form as TextBoxes. When a data is entered in the first textbox say "TestInput" then the corresponding second entry (2) should be...