Search results

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

I did not manage to use the "Nz" or "Len" functions as I am still unsure how I can use it in my codes.. however I used "IsNull": Private Sub cmbLeaveType_AfterUpdate() Dim intMax, intBal As Integer If cmbLeaveType.Value = "Annual" Then Me.txtMedicalBalance = ""...

Thank you for all the comments :D I have modified my code to: Private Sub txtStartDate_AfterUpdate() If IsDate(Me.txtStartDate) And IsDate(Me.txtEndDate) Then If DateDiff("d", Me.txtStartDate, Me.txtEndDate) >= 0 Then Dim intDays As Integer intDays =...

My project on Leave application is almost done, however I'm really stuck at this :confused: This coding happens after the combobox of Staff leave types (Annual, Medical,..) are selected. Private Sub cmbLeaveType_AfterUpdate() Dim strSearch As String Dim intMax, intBal As Integer...

Hi Peter, thank you for the explanations, you're right.. need to place the codes in Form_BeforeUpdate event. However is there a better option? I still hope it can be displayed on the txtDaysLeave, right after the user finishes selecting the dates. So that the page does not need to turn away to...

IMHO I rather not put it in holidays then, since it is abit of a trouble. I cannot say for sure that there will be someone maintaining the table at all time.. I will not have it done then next person who takes over has to take the trouble maintaining it *duh* :p Anyway, for my case.. the staff...