Recent content by gemma-the-husky

  1. gemma-the-husky

    FAYT User type undefined

    Is there an ordering thing? Does the findasyoutypecombo unit/module need to be sorted/declared above the current unit/module
  2. gemma-the-husky

    Solved What have I done?

    Did that work? It's useful on a laptop, where the ribbon just takes up so much screen real estate.
  3. gemma-the-husky

    Solved What have I done?

    Ctrl+F1 maybe to show/hide the ribbon. :D
  4. gemma-the-husky

    Query to Json

    I would have thought it relatively easy to produce JSON file from first principles, but you do need to understand the syntax you want to achieve, and I think that's what @isladogs was suggesting. The file example produced may not satisfy the requirements. By first principles, I mean Open text...
  5. gemma-the-husky

    Access On New Computer

    I think it's probably unreasonable to expect manufacturers to still supply deprecated products which simply because they are old may well contain insecurities that have been dealt with in later issues. Maybe users need to retain their original installation material and installation information...
  6. gemma-the-husky

    Access 2021 compiled for accde file

    I think the last points you make are on point. I think a bigger problem is being aware than an access database is easy to copy, and your data may not be as private as you would like it to be. That may be a real issue as databases will most likely hold sensitive information.
  7. gemma-the-husky

    Solved combo with 2 control sources

    That's a really interesting screen shot, which makes it quite clear to me that I don't need a tool of this sort. Out of interest can the usage column show value instead of items, or do you just click on a blue number to expand the contents? A simple monthly spreadsheet is adequate for my own...
  8. gemma-the-husky

    Access 2021 compiled for accde file

    You could tell the users to only use forms to enter data, and not to use tables directly. In my experience, users won't try to interfere with data, especially if they know how important it is. You can restrict access to the tables in ways explained by others in the thread. Using an accdr is...
  9. gemma-the-husky

    Access 2021 compiled for accde file

    By default a use can see tables and queries, and edit them. They can't edit forms reports or modules though. Sometimes it's useful. If you want to prevent access, you need to hide the database window.
  10. gemma-the-husky

    Solved combo with 2 control sources

    Personally, I would classify accounts as either Balance Sheet or Profit and Loss, the difference being that P&L accounts clear to zero at the end of each year. Expense/income is a poor category type, I would have said. You might need an account number strategy to group income accounts into a...
  11. gemma-the-husky

    Solved combo with 2 control sources

    This is really describing a double entry system, I think. For a payment you credit your bank account and you debit the expense account. By doing both, the double entry is maintained and the total debits correspond to the total credits. It's not so much that the two parts of the transaction...
  12. gemma-the-husky

    Solved combo with 2 control sources

    I am not really familiar with quicken. I thought you were talking about a commercial type accounting system For my own personal finances I just use spreadsheets. I suppose it might be occasionally useful to analyse my expenditure by the supplier, so I can see how much I've spent at different...
  13. gemma-the-husky

    Solved combo with 2 control sources

    How much of quicken are you writing..which ledgers are you doing. I wrote a great NL in a couple of days, and a SL in a little longer. The SL was actually harder, which I didn't expect. You can have the NL if you want it. Accounting is straight forward. I've used the NL for my own accounts for...
  14. gemma-the-husky

    Solved combo with 2 control sources

    You could have two combo boxes, and hide/display the one you want to use etc. Or, once you select the display option you want, simply change the text in the cbo title, set the query to the one you want, and requery the cbo box.
  15. gemma-the-husky

    Win64 version crashing

    I doubt whether converting some processes to 64 bit access is always as simple as "just" adding ptrsafe declarations. Those parameters used with settimer () may not work in 64 bit. That might be the issue.
Top Bottom