Recent content by cheekybuddha

I'm not sure my logic is correct! WE need to hear from @mloucel for clarification of what is required.

Can you post the full SQL of this original query?

SELECT InitialDate, FN, LN, ApprovedD WHERE InitialDate >= Date() - 15 OR ( InitialDate >= Date() - 90 AND ApprovedD IS NOT NULL ) ;

Equally, if you have the ItemNode object, you can also do: tvw.Nodes.Remove (ItemNode.Index)

What are you expecting tvw.Nodes("IT" & Me.ItemID) to return?

Are you sure that it is actually returning the caption - how are you discovering this? Is it by hovering your mouse over the variable in break mode? If so, the intellisense may just be showing the default property of the object, all the while the actual object is being returned in the code.

You can try: Set ItemNode = tvw.Nodes("IT" & Me.ItemID).Object ' or Set ItemNode = tvw.Nodes.Item("IT" & Me.ItemID)

OP has gone AWOLfor the time being. I guess we'll have to wait for clarification. For an array of c.200 values, I think a temp table is still probably the best solution - you can index the values for better performance on the join (if only a subset of array values is required), and also handle...

The two can achieve much the same effect. (eg SELECT a.ID, a.Fld FROM a INNER JOIN b ON a.Fld = b.Fld ; -- will produce the same as SELECT a.ID, a.Fld FROM a WHERE a.Fld IN ( SELECT b.Fld FROM b ); -- if table b contains three records in Fld: 'a', 'b', 'c', then also...

Usually. See Section 2 in this link (last bullet point).

Certainly won't be able to use any indexes there then?

By the time you have a recordset it is too late. You can't join recordsets. Your 2 real options are: 1. Build the array into an SQL WHERE clause (per Post #3) 2. Load the array in to a temp table and join that to your existing table (more hassle if BE is in Access, easier in an RDBMS)

I haven't read this whole thread, so forgive me if this is irrelevant or already covered. If you need the hWnd of an Access control there is a method here on The Access Web: https://theaccessweb.com/api/api0027.htm

Is that something to do with the new query editor? Just a guess because of the form name.

Do you really need to do the loop to get the line number? What happens if you try: Function GetLineNumber(F As Form, KeyName As String, KeyValue) ' ... ' Loop backward, counting the lines. ' Do Until RS.BOF ' CountLines = CountLines + 1 ' RS.MovePrevious ' Loop...