Recent content by gemma-the-husky

  1. gemma-the-husky

    Solved Transforming database from 2010 model or higher to 2003.

    It's not creating a new dbs though. It's taking an accdb, and trying to revert it to a mdb. It can't be easy even if there are no advanced features. Maybe you can't even copy and paste objects from an accdb firm on to a mdb blank form. No doubt you can copy and paste code though. I'm not sure...
  2. gemma-the-husky

    Documents and/or pictures in my DB

    You can create you own menus. Do you mean the switchboard. Just import an A2003 switchboard and switchboard items table. It still works fine. That's what I use. A modified version, but A2003 code. You don't want to insert objects into a database. Just link to the file and windows/ access will...
  3. gemma-the-husky

    Solved Transforming database from 2010 model or higher to 2003.

    No. A2003 was mdb only. Mdb will still run on current versions. When you change an mdb to an accdb you get warnings, so I guess it's not trivial to reverse the process even if you don't use advanced constructs.
  4. gemma-the-husky

    Update of stock quantity

    If you can find it, I actually think the best inventory database was a MS template I called Dharamsala Tea. I called It that because that was the first product. Just a brilliant example. The only thing I changed was to have stock movements inwards as positive and outwards as negative so you...
  5. gemma-the-husky

    Update of stock quantity

    If you have a lot of transactions though, one thing you can do is for individual (or all) products is undertake stock counts, and adjust your records to store an updated starting point for the stock calculation. if you struck a balance at say 1st August 2025, then you only have to sum 1 months...
  6. gemma-the-husky

    Re-design a wellworking data base

    When you go to login, the 2fa sends you a code to your phone (well mine does). You don't see the "send the code" button until you scroll down, and the number boxes are enormous. Maybe I've enabled accessibility options somehow. And a different thing, it's functionality rather than layout, but...
  7. gemma-the-husky

    Solved Determine What Code Is Still Running?

    So there's an active structure in memory that would be de deleted/released by resetting the program. Wouldn't you get the same if you created a pointer to a remote table to maintain a permanent connection to the data. That would also be deleted on resetting the program, wouldn't it?
  8. gemma-the-husky

    Remote desktop vs. browser based web apps.

    @BlueSpruce I imagine this is the sort of thing that if you don't know the answer might take a lot of time and resources testing to find out.
  9. gemma-the-husky

    Solved Determine What Code Is Still Running?

    I don't quite understand. Do you mean there is no active event, but the program is still running and waiting for an event/interruption, (ie there is an open form) and therefore still won't allow certain code to be changed. The user would actually have to reset the program in order to make code...
  10. gemma-the-husky

    Solved Determine What Code Is Still Running?

    But the forms opened by access will (should) work correctly as supplied, and will never cause a debug error. The prompt you are seeing must be caused because whatever you are trying to do is not compatible with currently running code. You won't see that by editing code while the database is not...
  11. gemma-the-husky

    Re-design a wellworking data base

    You even see things like this with a widescreen laptop compared with a square monitor. I was using the Coventry Building Society website, and it's clearly designed for a full screen monitor. On a laptop things are off the visible screen and it's not immediately apparent you have to or even can...
  12. gemma-the-husky

    Solved Determine What Code Is Still Running?

    Let's say you have a problem with something when you move to a different record in a form. You will either have a current event with code, or the form/program will just sit and wait for you to do something. If you don't have a current event, the program can't jump into your code at this point...
  13. gemma-the-husky

    Solved Determine What Code Is Still Running?

    You can set a break point to halt a program while the code is running normally, and the debugger will open and let you step through the code a line at a time. You can check the value of variables and so on. It's helpful for fixing hard to find problems. In this case you can edit the code, but...
  14. gemma-the-husky

    Solved Determine What Code Is Still Running?

    I think if fixing the debug error needs certain code logic to change, then the debugger can't always continue, and has to close. Sometimes you can fix an issue, and sometimes not, in my experience. This is all part of testing, and developing a robust app that handles any circumstance without...
  15. gemma-the-husky

    Solved Add Record VBA Not working

    If the query for your form is not updateable, it won't allow you to add a new record, or edit an existing one. Is this a new/modified form?
Back
Top Bottom