Search results

A little askew, but I have used quite a few programming/ scheduling applications: Various Gantt Charts in Excel - paid & free; they are not very good https://elecosoft.com/products/asta/asta-powerproject/ - this is the UK standard application for scheduling construction projects & every single...

Thanks RonPaii, another nice technique there. Thanks MajP, yes it makes far more sense to wrap in a function in my mind & I find it comforting that I discovered the multiple benefits on my own. Thanks MarkK. This is such an elegant solution to hierarchical data in Access it beggars belief...

Thanks Ron, that addresses my requirements more so - in obtaining different fields from the same queryDef. But I am not keeping the recordset open. I am not leaving the recordset open so that is not an issue. Thanks DocMan - that addresses my requirements more so & similar to what I've been up...

Thanks for the input, it cannot be done at once because the process I'm replicating is recursion. 'Repeating Group', I'm not exactly sure on this, but as a regular user I'm sure you're familiar with MajP's Treeview. That's what I'm up to, but with a Subform, & as I said, instead of using...

Thanks Tom, I've spent my life-savings on the project, quit my job & about to go bankrupt :ROFLMAO:. Long-term plan is to go MSSQL Server/ Azure, but for now I just need to get it working & get back to work, before i am homeless. :eek: That's a great link so thank you.

I cannot see how a domain function is the route when these queries are getting executed tens of thousands of times, against recordsets of around 10k records. Are in around 30 different locations (the callers I mean). Maybe an idea to submit a request to site development to remove the like button...

Thanks Pat, no the benefit is I have a single parametized query, which returns several different fields. This parametized query gets executed in many different procedures, many times. Sometimes it returns the same fields, sometimes not. In my little mind this reduces many different queries...

Thanks Doc_Man, Pat. Correct, that's what I'm up to; a query parameter executed from a function & from your great book recommendation using a saved query for the benefit you mentioned. But in my little mind I have the benefit of only a single line of code calling the function to return the...

So is Azure quick when using Access as the front-end? I think I've read quite a few posts stating it is nut. My limited understanding is that MS Access does not run well with online solutions as it was designed to work on local machines/ networks & something to do with packet-sizes on a network...

I'm considering doing this but it does not seemed a recommended solution & I'm confused why this is not a more common question; I'm obviously missing something. I have a common precompiled select query (as it's used so often to maximise speed) to obtain different values assigning the result to...

I wondered why people only seem to talk about MS SQL Server/ Azure. Azure seems to be ridiculously expensive & always wondered why don't people use PHP/ MySQL...

Thanks Doc_Man

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...