Recent content by PNGBill

Thanks Pat, I think the issue may well have been 32 to 64 bit. The earlier version may have been older than 2012. History now as luckily we no longer need the database. I know with Excel there is a difference between 365 and desktop versions in regard to functions. Wondered if Access also had...

Appreciate the responses. I have done a lot of access work with v2012 and it is annoying that newer versions require work to be done for vba to work. May go with 365 if continuous updates smooth this issue somewhat.

Hi, I have been away from MS Access for a few years and now want to build a database for our rental properties. We have Office 2016 Pro and would like advice on best option to upgrade our desk top version or change to 365 ? Appreciate your feedback :coffee:

This works =SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,">=01/01/2019",Data!$B$7:$B$150000, "<=31/12/2019",Data!$F$7:$F$150000, Customers!A7) Not sure why but on this attempt I didn't type the last part of code.

Hi Forum, This Sumfs sums the sales amounts in Sheet Data Col D where customer name Sheet Data Col F matches with current sheet (Customers A7 - Works well. =SUMIFS(Data!$D$7:$D$150000,Data!$F$7:$F$150000, Customers!A7) This Sumfs is similar but sums all the sales amounts for 2019. Sheet Data...

Hi Forum, I have a Worksheet (A) with 50,000 plus rows and the records have been updated. Headings are Invoice Number, Part Number, Sell Price & Cost Price, Customer, plus the updated column. This Workbook / Worksheet is copied from another Workbook (B) that downloads from a Database. The...

Just realised the code is xl (XL) not x1 :banghead:

Hi Forum, Learning Excel VBA and I could not get code to run. Copied code from file and it worked. Trial and error proved the problem was my keyboard typing number one "1" was not accepted. The copied code 1 and my 1 look exactly the same but must be different behind the scene :eek: Anyone...

Hi, I am looking for software to keep track of our investment properties income and expenditure. Anyone have suggestions on this. Want to avoid the monthly rental versions. Appreciate advice.

Thanks June7, Your help is much appreciated. The Project was never going to be easy as the Raw Data was not good but at least we have a result better than guess work. The Data is nearly 70,000 rows but we do not have to run every week. Maybe once or twice a year.

Hi Forum, Is it possible to Copy Rows from Workbook A to Workbook B where they do not already exist in Workbook B ? Workbook A is populated by MYSQL from a Database and overwrites data. Workbook B has 5 Columns from Workbook A. It would be great if the code to Copy from Workbook A to Workbook...

Thanks again June7. Just got up and will try again in a hour or so when at work. I was thinking... Should the Sheet be Sorted first ? Sort by A Descending then E Descending. Run through the records and where an x is found, check the next record and if value in A is the same, then x E, check...

Just realised my Software details were out of date. Now using Win 10 with Office 2016.

Thanks again June7. I don't have ActiveX Data Objects x.x Library 2.0, 2.1, 2.5, 2.6, 2.7, 2.8, 6.1 plus ..Objects Recordset 2.8 Library & 6.0 Library

Thanks June7, Some records in the last column have an x. Where a row has an x. All Rows with the same reference in column A also need to have an x. This is Sheet1. Trust this helps and many thanks for your assistance. However we need all of the rows that have an x in one or more