Search results

  1. A

    Problem with SQL

    When I used this without DISTINCT it worked but I need to have only distinct records which does not include duplicate records. Worked without distinct 'Set rstCount = CurrentDb.OpenRecordset("SELECT COUNT([RID]) AS RIDCount " & _ "FROM tblResource WHERE...
  2. A

    Problem with ECount function

    Any help on ECount function.
  3. A

    Problem with SQL

    I still have a problem in the query Syntax Error (missing operator) in query expression 'COUNT(DISTINCT [RID])' Set rstCount = CurrentDb.OpenRecordset("SELECT COUNT(DISTINCT [RID]) AS RIDCount " & _ "FROM tblResourceDemand GROUP BY [ResourceID] HAVING [ProjectID] = " & labProjectID)...
  4. A

    Problem with SQL

    I have to 3 records with RID's. (2 records have same RID's and 1 iwith different RID) When i try use this code it print 0 instead of 2. intX = Val("SELECT COUNT(DISTINCT [RID]) FROM tblResource GROUP BY [RID] HAVING [ProjectID] =" & labProjectID) Any Help.
  5. A

    Problem with ECount function

    I have a problem with ECount. The statement generates an error: int X = ECount("[ID]", "tblResource", "[ProjectID] =" & labID, True) The Ecount should generate unique values of ID from the tblResource where projectId = labID Error says & labID sub or function not defined. (labID is...
  6. A

    Problem with "count" function

    I still have a problem. The statement generates an error: int X = ECount("[ID]", "tblResource", "[ProjectID] =" & labID) The Ecount should generate unique values if ID from the tblResource where projectId = labID Any help
  7. A

    Problem with "count" function

    I have to count only unquie values in the table where Dcount do not work. Any help
  8. A

    Problem with "count" function

    Dim X as integer X = Val("SELECT COUNT(DISTINCT ID) FROM tblResource GROUP BY ID HAVING ProjectID =" & labID) I have a problem with this query. This should return 3 but return 0. Any help
  9. A

    Select an Item from combobox

    Not able to figure it out.
  10. A

    Select an Item from combobox

    Hey please check the example of what I am trying to do. This is not working . I have table Resource with field "Type" In form i have a textbox and the combo box. The combobox should display the items in the "Type" field of the table When I check the item in combobox that item should be...
  11. A

    Select an Item from combobox

    When I click the item that should go in the textbox. Any help?
  12. A

    Select an Item from combobox

    In combo box, there are X items when I click on one of item that item should be populated in the text box. The Code I wrote but there is error that update cannot be done. Any help please. Public Function Update(Row As Integer) Dim cboCount As Integer Dim intX As Integer...
  13. A

    Select an Item from combobox

    I got it. I have one more issue. me.yourtextboxname= me.comboname.column(whatever# the text is in) In code how to select an item instead of directly writing the item value in it.
  14. A

    Select an Item from combobox

    I have a combo box with 4 items in it. When select an item in combo box that item should be displayed in text box. Can anyone help me with any pseudo code.
  15. A

    Select an item in combo box

    What value is picked from the list of values in combo box.
  16. A

    Select an item in combo box

    I have a combo box which is populated by a SQL query. Till here it is working fine. Now I have write the code to slected an item from the list of items in combo box. Can anyone help me with this.
  17. A

    Selecting value in combobox

    Can you help me with pseudo code.
  18. A

    Selecting value in combobox

    combo box gets values from the table. and when I enter a new value in combo box it should edit in the table. When I try to select the value it doess not show up in combo textbox. Any help please.
  19. A

    Selecting value in combobox

    I have a combobox and list of values when I select the value it is does not show in combo textbox. Can any one help me with the VBA pseudo code.
  20. A

    Combo box

    I have a combo box. The values of the should be pulled from table. Can any one help with pseudo code of : How to add an item in the combo box.
Back
Top Bottom