Search results

I had a quick stab at this and this might get you started towards the solution that you're after. It works using the Worksheet_Change event based on the input of patient numbers in column B.

Thanks for the input Doc, I don't know why but I didn't even think about those updates. I should have, as pretty much every problem I've had over the last 10 years has been from M$ 'improving' something :ROFLMAO: Will follow the recommendations to compact on local drive, thanks guys.

Yip that is exactly what I have been doing for the last week. There is only ever 2 of us that use it and we sit next to each other so we have a good idea of who is using it and when. So as stated, we have been operating like this with the same file (set to C&R upon close) in the same folder...

I've just started getting this lovely message when I try to compact my database... "The compact and repair operation has been cancelled. You might not have adequate permissions to the folder that the database is located in. You need full permissions to the directory the database is located to...

Well it’s been a rough few days for the North island of NZ specifically the east coast. We are in the middle of a national emergency with our region pretty much cut off due to destroyed bridges, roads and power substations. Luckily my family and home is all ok but the same can’t be said for...

Very tricky to sing along to however :ROFLMAO:

Justin Hawkins from The Darkness did a review of this a couple of weeks ago on his YouTube channel. A lot of different art styles crammed into one for sure. Not for everyone but that's art I guess.

If you'd seen the things I've tried to do in Access you may rethink that...

I think the plane fare might make it a tad un-economic, but you're more than welcome. Those speakers need a good workout!

Mainly brewing :)

Ahh was wondering if you had the best shed ever... Well to give you shed envy then, mine is 8 x 12 x 3 metres!

Yip - I'd rather try to copy Joe Satriani... An equally impossible challenge but at least he uses a pick lol

From aforementioned album for others who haven't heard it yet..

NG is that in feet or yards..?

His work on Roger Waters' album Amused to Death is some of the most incredibly emotive, mind-blowing guitaring I've ever heard.

Now I don't expect many (any lol) of you to actually like this song as it's pretty strange (check the lyrics if you want a chuckle) and aggressive, but the drumming in it is just mind blowing so thought I'd share anyway. Since there is no decent footage of the actual Tool drummer performing...

28, 58

Ah the dreaded auto-start feature. About as helpful as the 'I'm putting MS Edge on your taskbar whether you like it or not' feature..

Yip so have changed the default and that seems to have done the trick. Seems to be a 'feature' of this program that after a PC re-start, it always opens on the default monitor regardless of where it was last closed. Cheers CJ

Yeah unfortunately monitor 1 is 43" and the other one is 24"