Recent content by michane

  1. M

    Command buttons for Access 2003

    I have a similar problem where the radiobutton I insert on my form, when 1 option is selected, the selection becomes the same for the rest of the other pages that I currently have. How do I make it such that when user select, it is only for that particular page on the form? :confused:
  2. M

    Report not filtering correctly with date inputs

    I found that the problem actually lies here, I have changed FROM: strQry = "SELECT Invoice_Details.*, Invoice_Details.Date_Received FROM Invoice_Details " TO: strQry = "SELECT Invoice_Details.* FROM Invoice_Details " Eventually tidied up my code to: Private Sub btnReport_Click() Dim...
  3. M

    Report not filtering correctly with date inputs

    Thank you! I tried & tested & keep trying, it just keeps showing, Run-time error '3079': The specific field 'Date_Received' could refer to more than one table listed in the FROM clause of your SQL statement.
  4. M

    Report not filtering correctly with date inputs

    Ok, I am trying to put it in a query instead. Do you think if this is ok.. I might be lost in the brackets :rolleyes:: SELECT Invoice_Details.*, Invoice_Details.Date_Received FROM Invoice_Details WHERE (((Invoice_Details.Date_Received) BETWEEN #(Format([Forms]![frm_Reports]![ProcStartDate]...
  5. M

    Report not filtering correctly with date inputs

    Thank you for that Paul, it worked really well. Do u know the coding to clear my report results from previous search, before the user uses the form for next one? My only problem now is actually, when I do a search with both my date textboxes (ProcStartDate & ProcEndDate) input as 14-03-2013...
  6. M

    Report not filtering correctly with date inputs

    Now I am thinking it could have read my date input 1/2/2013 as 2/1/2013 ?
  7. M

    Report not filtering correctly with date inputs

    My report generates base on 2 date inputs(from textboxes) namely, ProcStartDate & ProcEndDate & a combobox(cmbRptSupplier) to select the supplier: Private Sub btnReport_Click() Dim strDocName, strWHERECondition As String strWHERECondition = "" If Me.cmbRptSupplier = "" Or...
  8. M

    Display only the Month of a Date Field

    pbaldy, can I use the same format above as an expression under the "Group on", for my report?
  9. M

    Combobox items cannot be selected

    Please ignore the previous attachment, I have included the form together with the DB here ;)
  10. M

    Combobox items cannot be selected

    Here it is :)
  11. M

    Combobox items cannot be selected

    John, my actual DB size too big even after zipped... paul, where do I do a join? I tried to change the lookup inside Supplier table to combobox though, but still doesn't work..
  12. M

    Combobox items cannot be selected

    Attached a screenshot of my "Supplier" table
  13. M

    Combobox items cannot be selected

    I have checked, but nothing to do with my Column Count :(
  14. M

    Combobox items cannot be selected

    [SOLVED] Combobox items cannot be selected I know this sounds stupid.. but I am stumped at this issue now :eek: I have a combobox, which loads a list of supplier names. Managed to get it out on the form, but when I tried to select any one supplier, there is a sound played - "Ding" , basically...
  15. M

    Handling "null" return by DLookup on an integer

    I managed to use Nz now, thank you! :o Found out my earlier problem & removed all those " - CInt(Me.txtDaysLeave)" at the beginning of the codes to put together with "Me.txtAnnualBalance = intBal" instead: Private Sub cmbLeaveType_AfterUpdate() Dim strSearch As String Dim intMax, intBal...
Back
Top Bottom