Search results

Didn't say they were useless merely that you confine yourself the a fixed number of buttons. The task they do isn't pointless just that there are easier and more flexible ways of doing it (and they are data driven too).

The whole Switchboard discussion is a but like building the a better musket in the 21st century ie pointless. Haven't used one in years as they are far too restrictive and. limited

Oh what a surprise - double standards!! It's hardly a new problem: back in 1971 when I started at University the Catholic Society and the Jewish Association were banned from the Student Union, but not the Humanist Association or the Islamic Students Group. This was a fiat decision of the Union...

Sorry - yet again you don't understand the menu system in pre-ribbon MS Office. - the menus at the top (or side, or bottom, or floating according to where you put it) are just another toolbar - called Main, and the applications regard all of them as toolbars. And the other toolbars have menus...

As promised. Next time I log on to my Laptop I print off some images. The floating menu will come first In reality all menus are floating - you just dock them where you want or drag into the main area.

Next time I log on to my Laptop I print off some images. The floating menu will come first as I'll have to hunt for more complicated menus on my old BU hdds, since I seldom needed them. What I didn't cover in my post was bit further down yours. Your description of multi level security is...

Whereas I would say you never really understood menus. Ribbons are merely intrusive, inflexible menus. You can't put Ribbons where you want them, you can't have floating ribbons to name but a few of the inflexibilities of ribbons. All these you can do on menus and you can build them as you go...

Given that the Shift-F2 to initiate the Zoom box for any text field is 'built-in' this whole thread sounds somewhat like reinventing the wheel, although I readily accept that it is probably not the answer to what the thread starter wanted.

Purely apocryphal in that we are now 14+ years on but I was told as an aside by an MS employee at slough that the team given the task of converting the menu system to xml, refused to talk to the team responsible for the menus in office and just said huge chunks of functionality were pointless...

I loved reading how your transition to VBA from COBOL involved getting used to a different mindset. My start point in professional programming was Pl/I, which did have functions, very powerful arrays and we used an event controlled model for our online systems (albeit, of course character...

The the chart is great but it merely proves exactly my point - - TO ME there are few advantages, and significant omissions in Access 2021 over 2003. My post was always about my preferences, and usage.

You are absolutely correct:giggle: And above all I really miss Visual SourceSafe. Although I have successfully adopted a number of the suggestions from discussions of config management, it was a lot easier having it all in one place with a full history. Secondly I miss menus - I know this...

I jumped straight from 2003 to 2021 and don't think I came across the problem to need to deal with I for my minor occaisional usage of 2010. Did you try saving the font size as well?

Not quite applicable to this thread but there is one gotcha with DISTINCT: the normal default is ALL but on UNION queries the default is DISTINCT.

The whole purpose of pass through queries is irrelevant against a separate Access data source, and would achieve nothing that a linked data source is designed to do. As GPGeorge says they are designed to enable Server side processing by tSQL, MySQL, Oracle etc, and to aĺlow sending ƁE specific...

Thereby hangs a tale. When my PCs had died and I got a new SSD I was told Access 2003 wouldn't run on Windows 10, so I bought Office Pro 2021 from Amazon for just £29 which registers with MS without problem. I quite like 2021 but apart from being able to an image AND text on a button, instead...

You didn't say what version of Access you are using. I have just created a tab control and then changed it from Calibri to Segoe UI without any reversion in Access 2021. Try changing the font size at the same time as this was a solution to this problem years ago in Access 2003, that needed...

:) At least you can still buy USB floppy drives on Amazon (and discs). And anyone still got copies of Access 2? Moral of the story - if it ain't broke don't fix it. Let's face it most Microsoft upgrades are simply to let them keep selling.

Heartily agree: always been surprised that the decimal data type hasn't been incorporated into VBA as a native data type.. I was using decimal data type in PL/I forty years ago.

I stick to the nmonic May I Have A Large Container Of Coffee Cream And Sugar. - 10 decimal places. I've never needed more than this, I 've normally never needed to use pi in code., but often on paper.