Recent content by cheekybuddha

  1. cheekybuddha

    Solved Form Size

    Sorry, I'm not thinking very clearly!! 😬 Increasing the detail height will not work here because it is a continuous form, and you will only see one record (the others will be below)
  2. cheekybuddha

    Solved Form Size

    Actually, it doesn't look like you have a subform control. I'm not sure why you have only one row displayed unless you have filtered the RecordSource, ????
  3. cheekybuddha

    Solved Form Size

    Then add a similar expression for the subform control
  4. cheekybuddha

    Solved Form Size

    Try this in the Form_Resize event: Private Sub Form_Resize() Const w As Long = 28440, h As Long = 11835 With Me ' Set the inside width to exactly 28440 twips If Not .InsideWidth = w Then .InsideWidth = w ' Set the inside height to exactly 11835 twips If Not .Detail.Height...
  5. cheekybuddha

    SQL problem

    The real question is why you need to store this info in a table (counted) when the SELECT query you use to populate it will always give you the answer in the first place, and is less likely to be out of date.
  6. cheekybuddha

    Solved New detail records being added despite disabled button in master form

    The trick is to look at the answer in SO, not just the question
  7. cheekybuddha

    Table Design and Efficiency Help

    I see this advice trotted out regularly, and I would suggest it's unnecessary. If anything, it risks ascribing meaning to the PK of a table which it shouldn't have - the only job of the PK is to be a unique identifier for each row of a table. Note how often folks get their knockers in a twist...
  8. cheekybuddha

    Solved New detail records being added despite disabled button in master form

    None of the code in the answer in that thread is Excel specific
  9. cheekybuddha

    Seeking a Moderator for the Moderators

    Hmmm... I seem to remember there was also an Isaac who behaved much the same on UA and was also banned. :unsure:
  10. cheekybuddha

    Solved New detail records being added despite disabled button in master form

    I'm not sure Ron's suggestion is the answer. If the customer is null you should fall through to the Else anyway. I'm on my phone and can't see your image very clearly. Are you sure the subform has AllowAdditions property set to False? Could they be adding a new record via the navigation buttons?
  11. cheekybuddha

    Solved Afterupdate with no update.

    My turn for a dumb question: how is a user meant to enter data in a control if, every time they click on it, focus moves to the next control?
  12. cheekybuddha

    Solved Afterupdate with no update.

    Haha! So, instead of spending 15 minutes setting the tab order you've wasted 24 hours trying to code a solution that breaks anyone's natural muscle memory for navigating between fields! Just want to make sure that you are aware that you can arrange tab order using drag and drop, not just by...
  13. cheekybuddha

    Inconsequential Query

    Erm, isn't that an internet connection? 😉
  14. cheekybuddha

    Interfacing Access With Arduino Device

    ` You may wish to consider whether you actually want to use an Arduino board going forward. Arduino was just bought by Qualcomm and the enshitification has begun. you might also be interested in the quirks of their new board
Back
Top Bottom