Recent content by E9-Tech

This was the issue, I have changed this and now working!

I changed the code to Private Sub CmdAdd_Click() DoCmd.OpenForm "frmSalary", acNormal, , , acFormAdd End Sub Still no luck The query is SELECT tblSalary.IDSalary, tblSalary.DateValid, tblSalary.SalaryAnnual, tblSalary.SalaryBasic...

I have various forms displaying a list of records the record sourse is set to a query. I have a Add Record button to add a new record and these has been working perfectly fine on all various forms I have apart from one form that I cannot figure out why when launching the Add button it will open...

This code works! Thanks

I have a union query to, both tables have a date formatted as "yyyy mm" to group records by month, I need to combine the PaidTime from tblDuties and PaidTimeAnnualLeave from tblAnnualLeave as AveragePaidTime SELECT Format([DutyDate],"yyyy mm") AS YearMonth, Avg(tblDuties.PaidTime) AS...

How do I go about calculating the % variation based on the previous record E.g. below I would like on 2nd record to show 20% as the increase versus the previous value of 100, on the last record should be 8.33 increase from 120

I receive email notifications for any answer I get, the screenshot shows the email I received with "" As TOT, Then if I go to the thread it shows a different code which is strange. Thanks for the additional information!

Thanks for the solution. Something really weird, the email notification I received came with a difference code as per screenshot below, the code in the browser still shows Null As TOT vs the email showing "" As TOT

Still confused!!!! I changed the code to SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType, FundName, Payments, UnitsTransaction, "" FROM tblPension UNION SELECT PayslipDate, [PensionEmployee], [PensionEmployer], Null As Col4, Null As Col5, Null As Col6, Null As Col7...

I have a Union Query which I want to add calculated field SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType, FundName, Payments, UnitsTransaction, TOT FROM tblPension UNION SELECT PayslipDate, PensionEmployee, PensionEmployer, Null As Col4, Null As Col5, Null As Col6...

I am looking to develop further my DB project, I am currently tracking payslip data where I have 2 columns with amounts related to payments to a pension scheme, I would like to track transactions of the pension scheme in details and therefore I have additional transaction (e.g. purchase and...

Thanks this did the trick!

I have a code to add a file link to a txt box and another code to access this file, is all working perfectly and have a minor issue if I decide not to add the link and pres Cancel within the dialog window the errror is The code is: Private Sub CmdAddPayslip_Click() With...

Thanks for the solution!

I have the following code to auto fill a form when is loaded as it reads the latest correct values from a table Private Sub Form_Load() SalaryAnnual.DefaultValue = """" & DLookup("SalaryAnnual", "tblSalary") & """" SalaryBasicPay.DefaultValue = """" & DLookup("SalaryBasic", "tblSalary")...