Search results

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

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

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

[SOLVED] Date comparison What is wrong with the code below, it keep having "Run-time error '2185': You can't reference a property or method for a control unless the control has the focus." I just want to calculate the difference of the days with the input txtStartDate.Text & txtEndDate.Text...

[SOLVED] Code to insert attachment in email (Access) Hi guys, I've been stuck with this for very long, searching everywhere to no avail.. I'm using an Attachment box on my access form. And I'm working on coding that can allow me to open outlook with clicking a button & the address, attachment...