Recent content by paulcherianc

Hi, Thanks! Can I add multiple sheet names to the code as follows? Dim appXL As Excel.Application Dim wks As Excel.Workbook Set appXL = CreateObject("Excel.Application") Set wks = appXL.Workbooks.Open("C:\Users\SomeUser\Documents\YourExcelFile.xlsx") appXL.Visible =...

Can anyone help me to find the VBA to print specific excel worksheets on a workbook from access vba.

I think i have found a workaround! Set rs = db.OpenRecordset("SELECT QUG_Accident_Register_MainTable.* FROM QUG_Accident_Register_MainTable ORDER BY QUG_Accident_Register_MainTable.Date ASC;")

Am trying to transfer a table to excel with the following code. But i am not getting the data in ascending order with a specific column. Can anyone help me plz.:banghead: Set rs = db.OpenRecordset("QUG_Accident_Register_MainTable", dbOpenSnapshot)

Dear Arnel, I tried with this. But couldn't fix my issue.

Dear Arnel, Thanks. But I don't think I could resolve my issue with my requirement. Can you please help me to resolve this. I will attach the result I want in excel and the access query also. Monthly cost in excel should match with the same cost in access query "Lease Cost". Thanks in advance!

Hi , How can I add 2 days to the date difference. Can you please help me. Monthly Cost: IIf([PartMonth]="Y",DateDiff("d",[EffStartDate],[EffEndDate])*12*[MonthlyRent]/365,[MonthlyRent])

Here you may download : Subcontractor management system: 1. Subcontractor Management 2. Contracts Management 3. Invoice Management 4. Payments Management 5. User Management 6. Reporting Etc. Enjoy! User Name: admin Password: 12345 Cheers!

Oh it's Perfect Arnel! Many thanks for your immense support..!

Dear Arnel, I could see the current record's "Advance Payment Balance" is changing only once when I change the Previous records "Advance Payment" or " WorkCertified" field. Can you please help me to fix this. Regards, Paul C

Dear Arnel, I checked your file. I have the following issues: 1. Advance Payment Balance is not updated on updating the "Work Certified" field. It is only updating upon creating a new invoice now. Actually, it should calculate as when I update the work certified or advance amount. 2. After...

Dear Arnel, Instead of keeping inside the query, can I use the same on the subform design view?:banghead: Someone suggested me the following: With that, I could remove the data entry lock but I am not able to get the result. Using calculations in a query make the underlying recordset not...

Oh ok.. Actually i forgot!! Arnel, can you kindly look into my database data entry lock.

Dear Arnel, Can you please look into the data lock issue if you are free. Thanks in Advance! Regards, Paul C

Perfect!!! I have integrated your coding to my main database. However, I am not able to add any records on the form. it's locked. Can you please look into it. I have attached my main database for your kind review. Thanks a ton!