Search results

Thank you all so much. The problem was caused as Arnel identified a null argument in one of the arguments. It stopped all the other values for that pass of the function. CJ also spot-on identifying an unitialized argument, & MajP has helped me more problems than I can count; beyond Long...

Thanks CJ, I was not expecting to see an error but it does generate an error. Something is up with the ID not being passed. I'm investigating now. Arnel also on target; thanks, there is a null which kicks the record off. Like MajP's fine treeview I need a null to identify a 'Root' record. Pete's...

The arguments passed to the function are fine & the query is being processed in correct order. I think it's event related (which I appreciate I need to post the db but I can't do this [apologies I know what I'm asking is impossible to diagnose on this poor info]), but thought I'd post incase...

I don't think the problem is with the function; it's sorting in order perfectly based on a numeric value. It seems as if it's treating the first record in the recordset as Beginning Of File or something like that. I had an #Error on the last record but I got around that with a simple If...

Thanks arnel, it's a string which concatenates values. Function works fine on all other records but it skips the very first record. The first record processed is actually the second in the dataset. Can't find anything on Google yeilding same sort of problem. The dataset is based on a query which...

Sorry to hog forum. In a subform (datasheet) I have a calculated control; which obtains it's vale from a function placed in a global module. First value produces #Type! in the calculated control The calculated control is not processing the first record. Has anyone experienced this sort of thing?

Thanks Dave, yes just a single record & thank you for warning me that opening a hefty recordset delays things. SELECT is the way to go here I think as it will be called from many different places where i don't know what will be happening at runtime.

Faster solution on a single-user system where records increase by around 20k per week. Will be going to a multi-user system where that could be around 100k per week (but that's an idea atm): Select Query on 10k records based on a parent query to restrict the amount of items or Seek on Millions...

Thanks so much Dave, massively appreciated.

Thanks Dave, I've really struggled with the logic. This is the most basic one I have planned & I am failing massively. This looks exactly what I'm after. The only downside I see is that I could get confused with presumably having to pass a var for >. Sometimes >=,<,<=, who knows what on the...

Thanks Minty, that's interesting. "String manipulation to replace holders for the criteria operators"? That's what i was after in the OP, what do you have to do to convert ">" to get it to behave as an operator when being passed through the QueryDef.Parameter as an argument. I'm not after...

Thanks, sorry there were some essentials I left out in the OP. I thought I'd be able to pass the operators as parameters; but you cannot do this. The SQL editor needs the operators or it'll error out when defining the query, so you cannot move forward to the next step. I misread this thinking...

She'd be as the output pictured from the query designer, but I'm fine with altering all of that jazz. I've never used a parameter query before with actual defined parameters in the parameter window & that's got me really confused & I thought Parameter Queries were more powerful than they are...

Thanks Minty, cheekybuddha, yes I understand the previous issue concatenating data-types. I thought maybe I had to force the ">" operator as it was not accepting it & maybe it was one of the quirks of VBA like using a string literal as a table name... This is looking like it is not possible to...

Thanks, sorry I do not understand. How do i actually put the operators in the actual SQL. What is the syntax? As in the OP I do not want to hardcode a queryDef. I know how to do this, I am trying to minimize code on screen as I have amass of code in this particular class and a parametized query...

Thanks Minty, getting there. I think I need to encase in brackets & I need to actually set the SortOrder criteria I think. but another problem occurs. Because I have a same named property in the class this code is running I think I need to explicitly force the value returned from the query...

I want to assign parameters to an action query. I'm trying to avoid doing it by altering the querydef.SQL property in VBA. It would be much nicer to do it in the below fashion but I'm struggling with the syntax of the last two: SortOrderAdjustmentToMake should take the values in the query field...

Thanks MajP, yes I get the issue & thanks for clarifying so I grasp it. I just play around as much as I can creating all sorts of monstrosities trying to learn everything I can, and very often I embarrass myself - an area where I show great talent.

I've experienced this MANY times & it has always been as per @RonPaii's suggestion - a circular reference caused by my bad code not terminating a circular reference. When studying basic C# & C++ (very basic courses) I & the article refer to them as memory leaks. But I've been informed by someone...

Thanks, sure I was not aware of the Get type needed to be defined as the default VBA insert procedure uses variant so that made me completely unaware that when not using the Variant type. But I cannot see how one came to the assumption it being a String datatype when it was defined as long & I...