Recent content by rubbernilly

Thanks for the reply, strongm... TL;DR version: it's working. Thanks for sending me back to the logging/drawing board to look more closely at what output it was giving me. To your points: You're right that the keys don't always flatten to 16... that must have been my unconscious motor pattern...

Hello, all. It's been a while since I darkened these corners, but I trust you've kept the place up in my absence. I am digging out some code from an old .mdb file and attempting to update it and purpose it in a new 365 ACCDB. This sort of a thing had worked in the mdb, but doesn't in the accdb...

Yep, you can see in the first post that's what I did. I just wondered if anyone else was having the same issue.

Unfortunately, that is not what is happening. There is no such Option Base statement anywhere, and I verified that the expected base is still the expected 0 by dimensioning an array and filling members starting at 0. I've recreated the issue in a small example database (Access 2016 format)...

Just wondering if there is some pre-built code to handle a querydef and parse out the SQL into [FieldName] and [Source]? For instance, given the SQL of: SELECT tblTable1.WidgetID, tblTable1.WidgetName, IIF(ISNULL(tblTable1.WidgetPrice),2.99, tblTable1.WidgetPrice) AS Price...

I believe this is because forms work with a clone of the recordset which isn't changed when you change the underlying source object. If saving the qd and then doing some sort of me.requery doesn't work, then what's probably happening is that the form is doing a requery based on the old SQL...

If I'm understanding your data structure (based on you saying that proposed query working), then you should be able to add the ITEMSSOLD field to the DISTINCT statement, then SUM that on the outside: SELECT STATE, CITY, DEPT, COUNT(SALESID) AS CNT, SUM(ITEMSSOLD) AS SUMITEMS FROM ( SELECT...

Just wondering if someone else has noticed this, or if there is something I'm missing. I have a multi-page form in Access (using the PageBreak control and navigation buttons to go to 'Next' and 'Previous' pages). I set the Form's Cycle property to be "Current Page". That works great to the...

If you are doing this in a report, you can do a GROUP BY on your unique-identifiers, then a COUNT on the items. Then, in your report, turn on Grouping and put your Summation fields in the section footers. One caveat is that I don't see a unique sale identifier in your sample table. Your ID...

OK, further research and trial has demonstrated that it is a matter of the view that I am in. Apparently Report View will expand a 0"-height subreport, but Print Preview will not. I don't know if this is truly an Access 2016 behavior... I don't remember a 0-height subreport being expanded in a...

So, Access 2016 installed and I can confirm that this corrected the problem, with one caveat. All three sub-reports can now be back in the same section of the report, and they will all grow/expand and push lower objects down the page. I no longer need the pseudo group on my main report in order...

I'm sorry if I wasn't clear, Duane... It isn't the length of the section that limits me. If all three of my subreports expand, they would only total about 6-7 inches all together. What is going wrong is that the third sub-report will not expand, even though its expansion might only take the...

That workaround works, thank you Duane! However, I think I'm going to outgrow it pretty soon. If Access only supports growing 2 sub-reports per section, and I have the pseudo header, the detail and the pseudo footer, I'll bump into the limitation again, I think. I am due to be upgraded from...

Apologies if this has been asked elsewhere. My search turned up no direct results. I have a form with three subforms. The subforms are stacked vertically, but do not touch/overlap. They are the width of the main report, and they are 0" height. I want them to expand if there is data in that...

Hello, all... Problem Basics: I have an icon-heavy richtextboxex control on a secondary form, built from my main form. The first time I instantiate a new form2 and build the contents of the RTBex, the form displays no problem. The second time, it dumps out with an unhandled exception in...