Recent content by abzalali

@plog, thank you so much, I'm really sorry that I delayed replying. but finally get the result the way you show.

@Ranman256, could you please brief for the purpose of tExpense subquery? That would help me to make this subquery.

Because param_startdate goes in previous year agreement range and param_enddate comes another year agreement range that why we need to calculate the bill two different years rate. If both param in between a single year range then we need not split this anymore.

Truly it's out of my frequency Because I need to generate a monthly bill from this recordset with between date parameter. interval_start interval_end rate space_sft 09/09/2016 08/09/2017 95 312 09/09/2017 08/09/2018 105 312 09/09/2018 08/09/2019 115 312 Such as my param_startdate 01/09/2017...

@arnelgp, Thank you so much, It works nicely.

Dim t_id, ag_id, rate, incr_rate As Integer Dim stDate, nxstDate, nxenDate, nxyrDate, enDate As Date Dim StrSQL As String t_id = Me.tenant_id ag_id = Me.id stDate = Me.startdate enDate = Me.enddate rate = Me.initial_rate incr_rate = Me.increase_rate...

Dear sxschech, I need to put it an array and update all field that are mentions in if statements. How could I do this? Thanks

Dear Experts, I'm trying to update some field value depending two string field using a function with if and case, function below: Private Function checkDATI(tipotransazione As String, tipovendita As String) As String Dim r As String r = "" If tipotransazione = "VENDITA" Then Select Case...

It is now working with this code: On Error GoTo CmdPrint_Click_Error DoCmd.OpenReport "rptECN", acViewPreview, , , acHidden DoCmd.SelectObject acReport, "rptECN" DoCmd.RunCommand acCmdPrint DoCmd.Close acReport, "rptECN" Exit Sub CmdPrint_Click_Error...

Dear Expert, Actually I need to select printer before printing report. That's why I need to call printer dialog to select printer using "PrintObject" in macro. But it's print the form not report. I need to print a specific report. How can I do this? Please help me. Thanks Mir

getting same error with this code: If I press debug then go to the line: Forms![frmDepartmentReview]![cboDepartment].SetFocus

Dear Expert, I'm using form with subform. Main form header contain a combobox. I need to check the combobox is null or not before update a subform filed. If combobox is null then its back to Main form combobox from subform. The code below that I'm trying to: Private Sub...

Also same with this: SELECT tblImpact.Impact FROM tblImpact ORDER BY tblImpact.Impact;

SELECT tblImpact.Impact FROM tblImpact WHERE (((tblImpact.Impact) Is Not Null)) ORDER BY tblImpact.Impact;

debug.print me.impact it shows nothing that mean blank. But other current form field print in immediate window. Still I see data in the impact filed on form