Recent content by michane

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:

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

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.

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

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

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

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

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

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

Here it is :)

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

Attached a screenshot of my "Supplier" table

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

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

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