Search results

And to be clear, I wasn't advocating anything. Just stating eventualities. Naturally, records wanted in a specific order should be requested in that order. (Even if they're wanted in primary key order.)

As far as I'm concerned, nothing I said is contradicted there. I stand by what I said. Note, I said records are returned. (Not stored.)

Hi all. Random thoughts as they pass through my fingertips (having bypassed my brain of course!) Unles otherwise specified, records should be returned ordered by the primary key - though it's true they aren't necessarily stored in that order (unless you've just compacted the database)...

No worries. Little things are easy to miss.

Hi, welcome to AWF. Can you confirm that you're getting a compile error or a runtime error - and which line it's pointing to? The Open method or some reference to a URL that you were making? I notice in your code that you end up with a output.Value = oXMLHttp.responseTextwithout declaring...

Blah? It depends greatly on the content of the Blah. Directly as above (i.e. a Keyset cursor) there should always be a RecordCount available. It depends on "Blah" and what you mean by "useless".

No worries.

Hi A very natural request to avoid the onscreen movement. Assuming you're using Access 2000 or newer (a safe assumption these days surely ;-) you can access the form's recordset property and accomplish the above with a single line of code. Me.frmDOC.Form.Recordset.Movenext Cheers.

Are you using linked tables in this Access application of yours? If so - it's worth considering having a simple or even dummy table in the BE that you hold a recordset open to - so that the connection that is persisted is the same one your linked tables are using. You could repeatedly open...

A few questions spring to mind. First of all - storing a value in another field based on the autonumber field value is textbook data redundancy (violating normalisation). Do you even need to do this at all? What purpose does it serve? What's the source of this data? An MDB/ACCDB file (aka...

Seriously? That's your response?

Doug Steele covers drag and drop emulation in Access in an article from... a while ago. http://www.accessmvp.com/DJSteele/SmartAccess.html You'll need to invest some time and effort - it's not at all inherent functionality. Cheers

Started answering it over the way here :-)

Yes a report in design view has no option but to execute the passthrough to obtain the definition - as, unlike liinked tables, there's no way that the schema can be cached (it can be an ad hoc query which could even return different columns each time it runs!) Perhaps surprisingly though...

I'd agree - the shorter the better. Hence why I'd probably view returning multiple spaces as a result of the Reg Exp replace, and so something to be subsequently handled. (Otherwise the expression becomes more and more unwieldy - as you've found. ;-) For example (and again I don't know if...

Heh, I wouldn't exactly say I'm getting in on it. (Such time elludes me at the moment.) Just thought I'd throw out something I'd previously done. I'll leave you to your lengthy expressions. It looks like you've got a solution anyway... Cheers.

That would be the ish factor. ;-)

Hi Bob. 1024 ish characters but yes - it's limited. Though it seems the implication is that it's not down to this testing methodology. We'll see.

I understand the scenario you're decribing. But we'd really need more to go on than that. For example, the details of the two functions. i.e. how the second one uses the same variable as the first - and exactly how you've determined that it is truncated (where is that tested and what is the...

Hi Paul My first rule of debugging - eliminate the discrepencies. Eventually you get to Sherlock Holmes old axiom (often repeated in modern media - in shows such as CSI). "When you have eliminated the impossible, whatever remains, however improbable, must be the truth" I find that hard to...