Search results

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.

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

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.

Don't apologise - I personally am delighted you did - it has been a fascinating cultural exchange lesson. Anyway the thread was under Water Cooler so it's the sort of way these discussion around the watercolour go in real life.

Two problems here - an item can more than one shelf price in UK(for instance if you are using a Loyalty Card) and in the USA, the shelf price is normally pre-tax so it's not what you pay at the till anyway (usage and tax rates vary by state).

Yours sounds excellent process to me. And that's where it all falls down for the USA and the UK. People just are not willing to engage in security. They just flash their contactless card and wander off. No idea what they have been actually charged and far worse, no interest. Indeed talking to...

Having driven round the Magic Roundabout many times I have to say it very easy to use.