Recent content by MePenguin

Sound advice. Some long nights ahead I suppose. But this is not to be one of them. Thanks, and good night (at least Central European Time) Phil --------------- Pass me the ether.

Thank's PHV. I think I was just starting to realise that. Could you give me some advice? I've (stupidly) used double data type fields as primary keys in various places - how much trouble am I going to get into by changing these to decimal? I know the scale & precision needed for all my values...

... (not only,) but also Val(CDbl(Int(CDec(87.0290060) * 10000000) / 10000000))<87.0290060 = false Val(CDbl(Int(CDec(87.0290070) * 10000000) / 10000000))<87.0290070 = false something to do with MSKB 242933 ? Phil --------------- Pass me the ether.

Can anybody explain the following for me: CDbl(Int(CDec(87.0290060) * 10000000) / 10000000)<87.0290060 = false BUT CDbl(Int(CDec(87.0290070) * 10000000) / 10000000)<87.0290070 = true I find this totally bizarre, and it's giving me a headache... %-( (Oh, and it seems to be crippling my...

A quick update - no file size change on following your decompile tip, Tom. I'll remember the tip anyway, thanks. Phil Phil --------------- Pass me the ether.

Thank's Tom, I'll try that, and read the other. MSKB has a reasonable binding explanation too: http://support.microsoft.com/kb/245115/EN-US/ Sounds like it could have been a compatibility issue between versions... although of what, and why it only started recently I have no idea. I blame...

Many, many backups in far away places :-) Late binding worked - and I'd love it if you could explain why! Please? It also seems to be a lot faster, so maybe this was all for the best. After all I still have some hair left... I ran a repair install on Office & got my help back just for good...

Thanks Tom, I was considering the binding timing, although am reluctant incase there are any cascading consequences - could there be? Or am I jsut generally being too reluctant about everything today? This may be symtomatic of greater Office problems though, since my Office help failed a while...

Tom: WinXP Home SP1. (Other test machine is XPHome SP2... the development machine is too critical at the moment for me to risk installing SP2) Phil --------------- Pass me the ether.

Steve3110: reasonable question, answer = yes. Haven't tried with Excel in the background - other bits of the routines will not work if Excel is open when run, but I suppose I could circumvent that & try. Tom: WinXP Home, Office 2000DEV. Do you mean that it might have forgotten a library...

My app has developed an Error 424 "Object required" on the line marked below, but only on my WinXP Home developing machine: Dim ObjExcel As Object Dim ObjNewSheet As Object Set ObjExcel = CreateObject("Excel.Sheet") '*error here It worked a few weeks ago, and as far as I know I have not...

I have a problem getting a report based on a crosstab query to export to Excel in the format my users would like. (They want to click a button from report preview... got the button, but...) The query is created on demand in VBA (columns are dynamic), and the report will be eventually if I can...

You have missed absolutely nothing, PHV, as always. I, on the other hand, obviously missed that I should have taken a break and come back to the problem later. A clear case of a subconscious desire to make things more complicated than they really are?.. Have star for having your head in the...

I have two tables: TBiology & tblTempSearchTextBiol tblTempSearchTextBiol contains a single text field which stores user entered keywords, e.g. CriteriaItem water wood TBiology contains about 250K records of extracted text data in a memo field (field:data), with a CODE identifier field (not...

Thanks carrr, already read that and thought it wasn't much help, since that would still need several key presses to get to deeply nested commands. BUT by posting it you made me think of a nice workaround, posted here incase it's of any use to people. Even if it isn't particularly clever, it...