Search results

Just trying to find threads where I've touched on the First/Last (or their Domain function equivalents). Not as easy to find as I'd expected. Here's a couple from across the way. http://www.utteraccess.com/forum/DLOOK-latest-entry-t1944015.html...

As someone who is not a member of this "cult" but has, in general, erred on the side of caution over the years - I have to say there's a difference to the extreme Chris offered in his summary there. We treat objects variables differently, they're pointers to objects in memory that we hope will...

Dealing only with the recordset consideration for now - you also have the option to simply request an empty recordset by including the option dbAppendOnly in the Options parameter of the OpenRecordset method. While I agree that "WHERE 1=0" is an old valid trick to limit results, bear in mind...

No worries. The basics of SQL are indeed pretty simple and fairly standard across the differing syntax of T-SQL (as you're using at the moment from your ADP) and Jet/ACE SQL as would be in an MDB/ACCDB. Cheers.

What kind of data type is Active? If you've upsized it was perhaps a Boolean (Yes/No) field and is now a Bit column? WHERE FirstFieldName LIKE 'A%' AND Active = 0 If this is you creating a View in the ADP then consider doing that editing in the SQL pane. The Query grid will adapt to match...

Well, that's fair enough. It all takes time. Didn't want to imply you should have definitely known. However it's rare that you'll get too much information presented in a question... if you know what I mean. (You can pretty safely go to town a bit :-) Cheers.

OK, first of all, please mention in the questions if a file is as radically distinct as an ADP. There's just no reason not to offer that. Secondly where are you entering this? A View in design view? Edit: I see you've just posted that it does work. Glad you're sorted.

I'm sure you'll be able to twist this into your own needs. Function fLoadRstWithSelected(pForm As Access.Form, strPKName As String) As DAO.Recordset Dim intBottom As Integer Dim intTop As Integer Dim intI As Integer Dim strFilter As String Dim rst As DAO.Recordset...

3. Falling asleep while you wait? Perhaps that's just me.

Assuming you'd have mentioned if it were an ADP (not that that's by any means a totally safe assumption... :-s) - you've created a character class by surrounding the criteria in square brackets. Unless this is your intent - you shouldn't include them. The example Bob has supplied would...

>> I can remark the Set dbs but the Set rst = dbs must be there or all I get is an error message. Absolutely. Removing the second recordset opening line wasn't the intention. You need to open that recordset, as it's different from the first. :-) However the database object is the same. You'll...

No worries. Glad you're sorted.

There's nothing wrong with the concept at all. A "check all" is perfectly reasonable (and common) functionality. And if this is genuinely data elements then it is fair enough to set. Ah - what the 'eck. Check the example download again now. Very simple demo of iteration. Cheers.

One remaining question does seem to me - has the file path been confirmed? i.e. apart from attempting to open a connection to it in your ASP - have you just confirmed the path (and considered Server.MapPath if required as mentioned).

Well, if you're making assumptions about the entered data - that could change unless you have rules in place to prevent it. Ultimately - request what you absolutely know you want. If the date criteria should apply to all three, then it's simpler still to do. SELECT Sum(TRNDR) AS SumOfTRNDR...

Just to mention - there should't be any need for a subquery. The overhead added by it won't be substantial - but if it's not needed you might as well dispense with it. Your query can simply be: SELECT Sum(TRNDR) AS SumOfTRNDR FROM TBLTRANS WHERE (TRNACTDTE<=Date() AND TRNTYP="Interest") OR...

I'd have to agree with both fellas (i.e. potentially a combination). Are the records in your subform identifiable by some criteria you've applied - very possibly a foreign key field value? If so then I'd agree the update statement is the preferable option. (The recordset loaded in the subform...

The error is still that? ;-) So, do you have full read/write/create/delete/marry/copulate permission on the directory in question? (You need to be able to create and delete a lock file to have non-exclusive permission and of course you need to edit same file and the MDB itself). Cheers.

Well, in your subquery you have: (a.InteractionType='visit' Or a.InteractionType='Assessed') AND a.txtBehind=True but in the main query only: p.InteractionType='Visit') apart from the matching dates of course. That's the difference I was refering to. How the two behave differently. Ultimately...

The flexability of Jet (or ACE if you're using 2007+, either way it's the database engine). But apart from that - yes. (Though SQL Server accepts the syntax too - I couldn't tell you about Oracle, MySQL etc...) I'm not saying, in this case, that it's a particularly good flexability. Enforcing...