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.

Thanks for your suggestions.

Yes exactly. I want the control Tip Text to change as i select the list and move the mouse up/down the list.

Thanks for your reply. Control Tip Text is shown after selecting an entry into ComboBox. This is what is done in code also. But what i'm looking for is After drop down list is populated and mouse is hovered on the LIST, Control Tip Text should be shown dynamically, if i'm not expecting too much...

Thanks for posting the code. This is what i'm looking for. Also, another thing which i was mentioning is that when mouse is hovered on the list it should show the control tip text some thing like "Fname Sname". I'm not sure whether this can be done in Access or not.

Thanks for your reply. I'm not clear with the statement Me.ComboName.ControlTipText = Me.ComboName.Column(x). ControlTipText should be set with a value looked up from the table. But instead it above statement is doing differently. Can you tell me on how to get the column number 'x' when...

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

Thanks for your reply. But having a combox box to select a particular record is not feasible solution as: 1. The record entries are huge (~thousands). 2. Looking up a record is based on multiple fields and selecting multi fields using combo boxes is also difficult. Is there any other way to do...

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

It is working absolutely fine. Thanks for your help.

Thanks for your quick reply. But i have already tried with that but i'm getting error message. BTW, now i'm using SELECT query to lookup the entry in which weight can be NULL. (I think this wont effect much).

Hi, I'm in a case where i dont want anything to be inserted for age field. How can i go about with this?.

Hi David, I guess we cannot give in that way as the statement should be like Me(StrformField) = rs(SUBJ 1) but if we give Me(StrformField) = rs(StrRstField), It will be interpreted as Me(StrformField) = rs("SUBJ 1").

Thanks a lot. Its working perfectly fine. But, using the same idea, when i want to populate the entries to the form from the table as below For subjIndex = 1 To 21 Me("txtAge" & subjIndex) = rs![SUBJ " & ageIndex & "] (rs is the record set) Next ageIndex I'm getting the following error...

Hi David, Thanks for your reply. I understand your concern and I'm able to figure this out. Any ways, i'm going to change the layout of my tables with proper normalisation added. But right now for my current version i have to make sure that my current code is working fine. Continuing with my...

@DCrake: I dont want to do like that as the number of subjects will be increasing in future, and i know the total number of subjects before hand. So, i think it will be simpler to do in 'for' loop. @gemma-the-husky: I do have those statements which you mentioned.

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 = " &...