Recent content by jdraw

  1. jdraw

    Solved Adding total row to subform

    See if this subform youtube video by Dr. Verschurren applies. He goes through the set up ~ 6 min mark.
  2. jdraw

    Any idea why the navigation pane has changed the color

    Not sure if it's a bug, but, if not, then an apparent irritant to many with no communication from Microsoft. A surprise; a gift; a new feature; a glitch; a distraction......?
  3. jdraw

    Solved in a form or a subform

    @Lampje, More info please. Can you give us some context for this? You may get some insight from this older thread List all controls on all forms
  4. jdraw

    Access - counting scanned records

    Ms Access vba Do...Loop documentation
  5. jdraw

    Any idea why the navigation pane has changed the color

    Are forum members🕵️‍♂️🕵️‍♀️ really the Microsoft QA team? Seems a lot gets by those performing/assuring the official release. I have same release as Colin referenced.
  6. jdraw

    Any idea why the navigation pane has changed the color

    See the similar threads at the bottom of the page.
  7. jdraw

    Hi Access World

    Welcome to AWF, Seruz!
  8. jdraw

    How to update ID

    You may find this link to Isladogs Relationships helpful.
  9. jdraw

    How to update ID

    I appears that your tables and relationships may have been set up incorrectly and/or that Referential Integrity has not been set. Improper use of autonumber. Might be time to show us the database involved.
  10. jdraw

    How to update ID

    Autonumbers (from a no longer accessible UtterAccess thread) What they are NOT: 1. Row (record) sequence numbers. 2. An "order of entry into the table" number 3. A "gapless" series of numbers. 4. Editable numbers. 5. A series of (necessarily) always increasing numbers. 6. Intended to be...
  11. jdraw

    ShowUsers on another Database

    You may find these links offer some insight link by Jeff Conrad Kick Users Off -Detect Idle Time for ideas and/or This one from Microsoft
  12. jdraw

    How to create a custom random number AutoNumber with no repeats

    Paul, You are quite correct. The OP said they used random,but also Seems that something in his/her set up is at issue. Underlying question, "Why this set up"?, remains.
  13. jdraw

    Status of DatabaseAnswers.org ???

    On this AWF site there are some video tutorials, and there is a request to identify other tutorials, so Jon may have some thoughts.
  14. jdraw

    How to create a custom random number AutoNumber with no repeats

    It could be: - an academic exercise - a misunderstanding of autonumbers - new to Access/database I note that TGPCB has just joined the forum and may be unaware that autonumber can be set to Random. Perhaps OP will return and tell us more.....
  15. jdraw

    "The Text is too long to be edited"

    You maybe able to adapt the approach in this thread ---Exclude Data using a table by Bob Larson. Can also be used for Include.
Top Bottom