Search results

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,

The simple way to expose classes in referenced databases - basically what I do with those in my Library database is in the database to be references add the code module below and run fClassMultiUse before before use. Can't remeber wherte the code came from but I've used it for years. I...

The OpenArgs parameter is text and has to be manipulated - obvious values such as number use default casts.

I know the solutions to this thread is to avoid UNION but it is worth pointing out that ODBC Drivers are notorious for not handling UNION. Test the usage against Access rear end, but to use against the target database use Pass through queries.

According to Bill Gate C# is Visual Basic for snobs. He only had it created because IT professional demanded it. It's underlying engine is identical to VB.NET.