Search results

I think the fact that there is an empty column in between your data causes Excel to just ignore the other column. You would need to manually select the columns and then click sort

Somehow this doesn't surprise me...

Good on you - I wrote it for a reason, so I guess we're on the same page then.

Sorry - yes the one referenced. Has proven a saviour from much frustration.

Interesting - I've been using this technique to start a new Excel instance for almost a year now as I found that if I opened a spreadsheet to run a macro and I already had other sheets open with their own macros, even though they weren't being referenced, the macro I wanted to run would run up...

Easy - The dogs represent your remaining rational braincells who every now and then get a glimpse of reality and are desperate to escape the prison that you have them in. Poor things, better to just put them down before their paws turn into bloodied stumps...

Thanks Colin, certainly seems that way. Have restored from backup now, running OK and looking at plan B which is doing something else other than creating and deleting temporary tables.

Yeah I guess I'll have to read up on how to do it properly as I've not needed to do it before. Thanks though.

Possibly yes. EDIT: OK make that a firm yes, just spoke with the guy and he'd been in it. Oh well, that's one way to learn :D

No - I was still in test mode and hadn't even had the chance to do that before I got this error. Would it cause an issue if it was accessed during this time..?

Well that didn't work - I've now got an error stating that 'ID is not an index in this table' and it seems quite irrecoverable. I will have to get our IS guys to restore from backup and re-think what to do with this.

Right - it's split, I'll see over the next day or two whether this has helped I guess. Cheers

Thanks for the replies chaps.. OK so db is not split and resides on a shared network drive. It is also compacted on close ~ size is approx 175Mb

Hey guys, I was just wondering if there is any update in regards to this issue as it's driving me crazy. I have a simple db (using O365 on Win10) that really only has 2 users, me being one of them. I import text files into it regularly and part of that process creates a temporary table...

This post really is the gift that keeps on giving.... :ROFLMAO:

I think that the much maligned 'foreign-born engineer at microsoft who learned English as a second language' is correct. Example 'My tie and my shirt don't match' I wouldn't say 'My tie and my shirt doesn't match', I would say 'My tie doesn't match my shirt' In this case if you wanted to...

A possible title for that post: "When your zeppelin of delusion crashes headfirst into your planet of irrationality and poor grammar"

I think the preference would be to modify yourself.

Wow, had a look on google and those look pretty massive... Are they very heavy....? I've been fortunate enough to obtain these about a year ago and my ears have never been happier! https://www.shure.com/en-US/products/headphones/srh1540

Hmm now I read that again I think you're right. Oh well, shouldn't be too difficult to tweak...