Replies

Hi all
Thanks for the comments (I will take a look at modifying that script)

Cah. You are quite right, in fact that is what I have been doing… Just feels a little clumsy and I was interested if anybody had already dealt with this issue

Cheers

Wow. Now that is an impressive response time!! (If only my project teams could get back to me so fast!)

I note the issue about relative folder references within certain filetypes / programs. Luckily I can live with this as these are data files and have no dependence (The hierachy was anachy – I wanted to address and re organise)

I’ll take a look at the File Sieve, thanks for the pointer. I’ll report back if it’s good

Cheers both – really appreciated

You’re pretty set about the layout of the summary so I suggest you take a look at using arrays in any future work you do. They offer the advantage that they are VERY flexible – use them whenever you know you’re going to be updating ‘data’ and producing a summary.
We use them in a bank environment. The summaries we produce are very sophisticated (Arrays can be dynamic – I can offer more examples if people are interested)

Consider this a pointer as to how I would have gone about producing summary of the type of data you’re entering. If it feels right – great. If not – sorry I couldn’t help more

Bemused

You’re pretty set about the layout of the summary so I suggest you take a look at using arrays in any future work you do. They offer the advantage that they are VERY flexible – use them whenever you know you’re going to be updating ‘data’ and producing a summary.
We use them in a bank environment. The summaries we produce are very sophisticated (Arrays can be dynamic – I can offer more examples if people are interested)

Consider this a pointer as to how I would have gone about producing summary of the type of data you’re entering. If it feels right – great. If not – sorry I couldn’t help more

Bemused

Not really answering your question.
Arrays. I strongly recommend you develop your workbook to run off an array of data that you can simply replace perdiodically.
This way the data can change (in terms of regions etc) but you won’t have to worry (so much) about the flexibility of your workbook.

Perhaps if you post an example I’ll ‘array’ it for you and you can take the Pepsi taste test?

Not really answering your question.
Arrays. I strongly recommend you develop your workbook to run off an array of data that you can simply replace perdiodically.
This way the data can change (in terms of regions etc) but you won’t have to worry (so much) about the flexibility of your workbook.

Perhaps if you post an example I’ll ‘array’ it for you and you can take the Pepsi taste test?

My two cents

Thank you – This was just what I was looking for.

My medical insurance company thanks you (more paid premiums – no claims) and I thank you.

Thank you – This was just what I was looking for.

My medical insurance company thanks you (more paid premiums – no claims) and I thank you.

Thank you – this is the approach I have always used.

However I am getting frustrated by the number of people who do not stick to my policy of “Use a Read Receipt and Die”… The ability to automatically repy with a sharp email to chastise is an option I’m willing to pursue. Too many people choose the “Request read receipt” on all email – simply to see how quickly you scan through your mail box it seems.

If I can get a rule set / script to meet my requirements it will be a snip to alter it so that SOME users under EXCEPTIONAL circumstances can use read receipts.

Read receipts are a pain in my business culture. Turn them off and you get a follow up email or a call. Turn them on (Allow them) and you are unable to manage your workload because good for nothings can’t appreciate that mailbox management might mean that I am not willing to drop everything and rush to their pet projects

Thank you – this is the approach I have always used.

However I am getting frustrated by the number of people who do not stick to my policy of “Use a Read Receipt and Die”… The ability to automatically repy with a sharp email to chastise is an option I’m willing to pursue. Too many people choose the “Request read receipt” on all email – simply to see how quickly you scan through your mail box it seems.

If I can get a rule set / script to meet my requirements it will be a snip to alter it so that SOME users under EXCEPTIONAL circumstances can use read receipts.

Read receipts are a pain in my business culture. Turn them off and you get a follow up email or a call. Turn them on (Allow them) and you are unable to manage your workload because good for nothings can’t appreciate that mailbox management might mean that I am not willing to drop everything and rush to their pet projects

Fantastic(!)

I suppose a work around would be to create a new database and then copy in all the code, queries and tables? (Being careful not to use any import functions) ?
Anybody tried this ??(This database has some pretty beefy forms and I’d hate to have to re create all those fiddly controls for no good reason)

Thanks for the response. That was fast even by your standards!

Indeed it does.

The link also has some other very useful functions. Thank you.

If I view the drive in Computer Management it’s simply Disk 01 (with the Primary master called Disk 00) although it does read the disks volume label “moon” correctly.

Thanks for the links – I’ll take a look around.

If I have any joy I’ll post back. Doc Watson – Thanks, those links have given me some more enthusiasm that I might be able to solve this yet.

Logged in using the Admin account. Not a user with Admin rights.

If I use DOS I have no way of ‘locating’ the drive – No drive letter to get in to.

If I use recovery console I’m told that I don’t have rights to view that folder. (?? – I’m in as Admin)

Is there any way that NTFS might have locked this drive – The computer name has changed when WIndows was reinstalled and I’m suspicious that this second drive is now locked to me because it doen’t recognise the permissions?
Logged in as Admin I don’t know how to affect this drives permissions without first getting a drice letter assigned to it (Which I can’t do)

Frustrating.

– Although I swear I’m not going to give in this time and re format!!