Search results

The answer is no it doesn't mean that BUT you'll need some way of preventing them selecting more than three conditions. I generally only pre-set CFs and as (by choice) my ribbons are hidden to users so I'd need some way of invoking a method of selection, but I can't see me doing it so I can't...

As I said I agree with you that the utilities are the answer: my recommendation (which is no more than a couple of hours work) would be a first indication to give an idea if any real work is necessity. My experience is that any inherited database is far more work than one expects even if it...

Agreed but this needs nothing except a text editor!

Just been looking at previous threads on the subject where it is suggested that it is a bug. (And work rounds using VBA). I then checked on my old laptop running 2003 where you cannot actually add more than three, and since in 2021 I can add lots of CFs I assume the bug explanation has credence.

First question is which version of Access? In Access 2003 / 2007 the built in limit was three. Certainly in Ver 2021 I've used 4 (I think they all worked but I'm not certain) but never bothered with the finding out the limit. You'll need to look it up for your version.

My first step would be to save all the objects in the database using the SaveAsText (hidden), Then use a text editor (such as which allows you to Find In Files to search for usage of each file in your database. Those not referred to should be a good first cockshy at not used. Would be very...

I like 'chimera' - better than my simple dismissal 'Profersional stye' as fashion.

Exactly my point - what was the best compromise 200+ years ago could easily (technically that is, not politically) be replaced by a country wide consistent vote of all citizens.

As an observer I have really enjoyed following this thread for a number of reasons: I really admire the passion that Americans put into their politics. I am amused that a system (EC) invented to cater with the communication and travel problems of 200 plus years ago, which have long...

That's why Gentleman's Clubs were so useful: nothing wrong with discussions about politics and religion but in the correct place: the pub (street corners etc) and church (chapel, temple, mosque etc... ), but one needs sanctuaries.

If I had my way it would be like an old fashioned Gentleman's Club and politics and religion would be totally banned!:sleep: What me? Old fashioned?

I was just about to ask that!! :)

Definitely see your point!

I've never seen this as a real problem - a little navigation is only a couple of seconds in a manual process . Must admit, however, I seldom ever build an .accde from the SaveAs dialog. My .accde files are built from my Releases database in code, where you can guarantee where you are saving...

Given that the control is a ListBox then it could be as simple as if you have set Column Heads = true then the row 0 is the headings and you will be trying to assign the column title in col 0 which would explain the data error.

This really depends on how many people you are administering leave for. I suggest that if it is less than twenty it's easier done on papaer!

Well done for flagging a this which can be a real problem - years back when I served in a tri-service unit it was a nightmare as each of the three services calculated entitlements and counting of days taken in different ways. (Not bad when in theory we all had the same numbers of days annually!)

If you are really worried you can put a line in any code that runs at start up: SetOption "ANSI Query Mode", 0

Being a Brit I don't have any stake in this particular argument, but as an outsider looking in there are so many faults and anomalies in the whole voting system for the president that I wonder why anyone is surprised at the outcome of votes!

As an aside to the main thread how many others are baffled like me at Microsoft's decision to prevent classes being exposed in referenced access databases? Seems crass to me, given that most referenced databases usage is for Library databases,