Forum

Peter Morris
@pjm
Eminent Member
Joined: Jul 20, 2019
Topics: 6 / Replies: 10
Reply
RE: Using 'From File from Folder' doesn't handle errors or ''key' doesnt exist

Hi Phil, I do use 'try .... otherwise' in certain areas, but as I understand it I can only use that construct over individual lines of code. That wo...

4 years ago
Forum
Reply
RE: Using 'From File from Folder' doesn't handle errors or ''key' doesnt exist

Hi Phil, I'm rather constrained on what I can share due to company rules. The key thing I'm trying to understand is how to 'trap' an error that oc...

4 years ago
Forum
Reply
RE: Detect when a category on a PivotChart is expanded

Hi Mynda, Absolutely happy with your placing the post wherever best suits the forum. You commented that I "..need to ... is alter the filters af...

5 years ago
Forum
Topic
Reply
RE: Marrying Budget and Expenditure Data in a Many-to-Many situation

Thanks Mynda, I have never yet had occasion to really use them. However, I've just had a quick look at a blog (on

5 years ago
Forum
Reply
RE: Marrying Budget and Expenditure Data in a Many-to-Many situation

Hi Mynda, Finally fixed it. I had to extend the M2M concept to manage also at the Sub-Section level. This resulted in a more complex Diagram view...

5 years ago
Forum
Reply
RE: Marrying Budget and Expenditure Data in a Many-to-Many situation

Hi Mynda, Firstly apologies for delay in replying, we've have internet/phone problems. I've used PQ to create the qryDailyBudget which has an en...

5 years ago
Forum
Reply
RE: Marrying Budget and Expenditure Data in a Many-to-Many situation

Hi Mynda, Thanks for the quick reply - I'll investigate using Powerquery to add the dates as the users would be confused if I included it on the bu...

5 years ago
Forum
Reply
RE: Calling a Function using Hyperlink

Thanks Phil, much appreciated - I wish I'd realised it was that simple. I'm learning. Many thanks.

5 years ago
Forum
Topic
Forum
Replies: 3
Views: 462
Reply
RE: Duplicate Entries when Importing .CSV from Folder

HI, I believe I've found the answer and am posting in case it helps anyone else with the same problem: 1. Group by Download File, Date, Retailer...

6 years ago
Forum
Page 1 / 2