• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by Dumferling

  1. D

    Solved Long Text in Report cuts off

    OK. Solved it. You have to change the Totals line to "First" and not "Group By". Judging by the comments there are many ways to solve this issue - some work one way and some another. For me, for this issue it has been to change the totals to "First"
  2. D

    Solved Long Text in Report cuts off

    I am sure that there is something I should be doing but it is just beyond what I can remember. I have Long Text (O365 version) fields in my reports but it cuts off after what I assume is 255 characters. Both field and section is set to can grow and shrink. How do I fix this?
  3. D

    Solved Dynamically moving subreports

    Ah, that works. Great. Thanks.
  4. D

    Solved Dynamically moving subreports

    As in height = 0?
  5. D

    Solved Dynamically moving subreports

    I have a report with multiple subreports, one below the other. All reports are set to Can Grow/ Shrink which works fine until a report has more lines and runs over the report underneath it. Is there a way to dynamically move the location of each report based on the final size and location of the...
  6. D

    Solved Access not opening in editable version

    Ah, I think you have hit the proverbial nail. Open with shows options for both 2016 and 365. If I click on the 365 option the database opens normally. If I select the 206 icon, it opens under runtime. Its as simple as the association (and some poor uninstalling by Microsoft and probably my IT...
  7. D

    Solved Access not opening in editable version

    The extension is accdb. I will try the open with option but I am also thinking there is a registry issue somewhere.
  8. D

    Solved Access not opening in editable version

    Tried that. Issue persists
  9. D

    Solved Access not opening in editable version

    I was running Access 2016 and my database front ends were on my desktop in a trusted location. I could click on them and open them in editable format (i.e. not runtime). My office upgraded me to 365 (with Access) and two days later my database front ends are opening only in runtime mode and I...
  10. D

    Add new records from a filtered query

    I am not sure how I go about this. I have contracts which are listed in one table (Contracts). A contract can be affected by different regulations, depending on the industry (lets say Insurance) So, I have a related table (Regulations) on which I want to list the different regulations for each...
  11. D

    Working Remotely with Access DB on Company Network

    Working remotely (like everyone else) I am hardwired to my router and have to use a VPN to log into my database BE. If I go off hardwired and onto WiFi the whole system slows down drastically and is more prone to drops. On a hardwired link with fibre (in South Africa fibre is not so widespread)...
  12. D

    Office 365 and Runtimes

    I have developed an access database in Office 2016 and distributed it, partially successfully with 2016 runtimes (issue are security related only). My company is moving to Office 365 over the next few months or maybe longer (16000 employees take a long time to move). I want to move to 365 now...
  13. D

    Solved Runtime files and split database

    I thought originally that what you are suggesting would work but when it did not I found J Street Relinker and put that in. I think something on the network in the corporate environment is to blame - possible network shares. J Street works fine though (it is a great piece of code - Thanks...
  14. D

    Solved Runtime files and split database

    Thanks for this assurance. You can't be too careful these days but I am happy to trust this community
  15. D

    Solved Runtime files and split database

    This is the exe I downloaded but I do not know whether to trust it or not.
Top Bottom