Recent content by euphonium01

Hi Uncle Gizmo, I had a quick look at the code you did for dates, and my question is - how the h**l did you do that? It's so complicated, I couldn't contemplate how to even start such a project as that, that code is longer and more complicated than ALL my code put together... wow! I don't...

Thanks MajP, that makes a lot of sense. Not having done a database that requires multi-user functionality, it never occurred to me that one central point of data is available to all, and therefore everyone is 'singing from the same page'... literally! Many thanks for your answer, if I ever...

Hi The_Doc_Man: Yes, I play a Euphonium, after playing with the most famous band in the world for quite a while, I now play at a lower level but still in the top league so to speak. Music is me, I laugh with it, dance to it... and cry with it! It truly is the international language. Paul

Amazing! One has to ask should those people with that level be creating databases? We all start at the beginning (don't I know it.. I'm still at the beginning) but changing filenames etc. is an obvious and basic computer skill, heck, doesn't the guy have a smartphone that he texts from, it's...

Re: Helping Others pbaldy exactly, where would the fun be if it were that easy lol? Uncle Gizmo Thanks so much for the link, there's some very useful stuff on there. Reading through various Threads, I've found a few people saying that copying other's work isn't a good thing, but isn't that...

Thanks isladogs exactly what I needed, never occured to me that the button wouldn't print. Paul

Enjoying being a new member of the Forum, but from versions of Access I've used in years gone by, printing seems to have got a lot more involved and subsequently cumbersome? :confused: When I have a Report on screen, and I select 'File' - 'Print', it prints whatever is highlighted in the...

Thanks Uncle Gizmo, that's sound advice. I had posted that I was going to try a simple Table & Form to see if the code worked, but I came across the problem after taking that closer look. Knowing my level of knowledge on vba it surprised me that I found it, fortunately, the low level of vba...

OMG: WOW: I can't believe it... I fixed it!!!!!! :D It's a bit complicated (for me anyway) but here's what I did: Following the comment from Gasman I checked all Controls that I wanted checking were capable of BackColor changes, they are, I tried it manually and they all went red. I looked...

Oh, again forgive me for any ignorance, I am running Windows 10 64bit build 1803, and Office 2016 64bit, not sure if this is of any relevance what-so-ever? Sorry... Paul

Uncle Gizmo: Thank you for the welcome, in just a few hours it's good to link up with helpers, I will watch you video and see if I can incorporate anything (that means if my brain can work out what I'm supposed to do/type lol). I have posted a reply in my Thread, it contains all the code I...

Hi Paul, many thanks for such a quick reply. I'm sorry about this long post but, it's hard to explain one's difficulty when asking experts for their advice, so I've posted all the codes used for this process just in case, I hope you understand? I triple checked that every Control I needed...

I am using Access 2016. I have a Form with Controls that need to be ALL completed, ie, no Null values. I cheated a little and copied some code from an internet video where it Tagged each control I wanted to check, if there were any then the vba code opened the Form with the appropriate...

Hi to everyone. I have been creating very simple databases in Access for a number of years, simple enough to need Macros instead of vba code. But, I find vba fascinating, and as I have a lot more time on my hands these days (retired now) I enjoy 'upgrading' my databases using it. But...