Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rubbernilly

  1. rubbernilly

    Behavior Difference in KeyDown (masking KeyCodes)?

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

    Behavior Difference in KeyDown (masking KeyCodes)?

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

    Cycle Property = Current Page skips TabStop 0

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

    Cycle Property = Current Page skips TabStop 0

    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)...
  5. rubbernilly

    VBA to parse SQL into [FieldName] and [Source]

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

    Change SQL property of saved query

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

    Sum Distinct Count

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

    Cycle Property = Current Page skips TabStop 0

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

    Sum Distinct Count

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

    Third SubReport Will Not Grow

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

    Third SubReport Will Not Grow

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

    Third SubReport Will Not Grow

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

    Third SubReport Will Not Grow

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

    Third SubReport Will Not Grow

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

    Getting Disposed Object Exception with icon-heavy form

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

Part and Inventory Search

Back
Top