Replies

Thanks Hans.

Thanks for your clear explanation, and I am away. My main mistake was not to eliminate other months’ sums in the first two queries, I was trying to do that in the final query. Because I ended up with an awful mess, I started thinking I needed a crosstab. The other reason for the crosstab was to see each months’ data in the same query – still thinking about that. I had also tried to do a right join and left join with tblAccounts in the middle. I think that might have been OK if a little ugly.

Marty

ps. The cashflow report I had in mind turns out to be practically useless! Having realised this, I found a way to reorganise the report to give something more meaningful. Make more mistakes, and learn more!

Thanks Hans.

Thanks for your clear explanation, and I am away. My main mistake was not to eliminate other months’ sums in the first two queries, I was trying to do that in the final query. Because I ended up with an awful mess, I started thinking I needed a crosstab. The other reason for the crosstab was to see each months’ data in the same query – still thinking about that. I had also tried to do a right join and left join with tblAccounts in the middle. I think that might have been OK if a little ugly.

Marty

ps. The cashflow report I had in mind turns out to be practically useless! Having realised this, I found a way to reorganise the report to give something more meaningful. Make more mistakes, and learn more!

We fixed it. Fdisk works wonders. It’s a new machine to be delivered to the customer, and I don’t subscribe to dodgy installations in these situations.
Thanks for your suggestion though.

Marty

Drew,
We downloaded it from microsoft.com. It does it’s file verify fne.
Marty

The product is iHistorian by Intellution. iHistorian is an add-on to iFix, which is a SCADA package.
I have not yet found out what exactly was the cause of the problem. Given the cause is not known, I’m not sure the experience is sufficient to avoid the product.

Many thanks for the replies!! I rolled both together to get a sub which works very well.
One problem left, however. What about a cell containing several words, one of which has been altered from default? (grr…)

thanks for the help
Marty

My intention was to copy the files out, reformat the drive, and then copy the files back in. Hopefully without disturbing any installations (two large programs). One worked fine, the other refused to behave and insisted on being uninstalled. Once it was, I recovered all my disk space and things have been fine.

Now have a few quiet questions for the software manufacturer why they think 3GB of invisible files are an acceptable way of infecting their customers PCs.

Thanks for the suggestions.

Marty

Thanks. I got that to do bitwise XORs by changing the data type. Now WXOR(10,8) = 2 as it should.

Works in NT too, thanks

To answer all the new points:
[1] I can’t select the option mentioned because it is greyed out (which is the problem I am trying to fix)
[2] I am running NT4sp6
[3] The problem is apparent in a new document (ie based on the normal template). In the new document, there is no protection (so the menu reads Tools > Protect Document). The same is true when I open the template.

This is a stand alone version.
If it was a decision by IT how would they enforce/ inflict this change (might give me a clue how to undo the situation).

I appreciate the question, but I had to chuckle; the closest we come to an IT department is myself and one of the other guys. We’re not totally witless, but “IT Department” is stretching the description!!

Elegant, simple, perfect.
Thank you

Can I ask why the echo. and find?
How about (tested on NT):

if NOT “%LOGGING%”==”YES” GOTO NOTLOGGING
echo Already up to date with the latest virus identities >>%SGETDIR%IDEFETCH.LOG
DATE /t>>%SGETDIR%IDEFETCH.LOG
TIME /t>>%SGETDIR%IDEFETCH.LOG
:NOTLOGGING

Also, does anyone know where to find a comprehensive batch file guide for NT? Something that explains in detail the command extensions for the SET command, for instance. Maybe some clever examples and tricks, that sort of thing… ?

Thanks Charlotte.

I hadn’t realised I could build the function into the SQL rather than call it as I made the SQL clause. Simple really.

Works just luvverly.

From the subform you can do this:

If Me.RecordsetClone.RecordCount > 1 Then

From the main form you can do this:
If Me.[frmMySubform].Form.RecordsetClone.RecordCount > 1 Then

The handy thing here is you don’t have to move through the recordset before you query RecordCount.