Search results

  1. 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?
  2. gemma-the-husky

    Re-design a wellworking data base

    I am not completely familiar with everything invoiced. Do the remote users not need any sort of special set up and/or training?
  3. gemma-the-husky

    Re-design a wellworking data base

    In passing, note that if the processing takes place at HO, but users are working from a remote location, you need to consider some issues. Namely, providing things like printing, saving output and providing integrated email and internet services at the remote location where those functions need...
  4. gemma-the-husky

    Re-design a wellworking data base

    Even if you use SQL server, you still need terminal services. If users are running the database at the remote location, they won't get an adequate response over a WAN. So they need to connect to HO and run on the TS at head office, assuming you still want some work to be carried out at the...
  5. gemma-the-husky

    Help with moving Access database

    I always thought it was the same. It must be easier for MS to just produce one version and limit what it can do than maintain 2 different versions. I'll take your word for it though.
  6. gemma-the-husky

    Help with moving Access database

    Ah, but runtime access IS full access,just not licenced. You can't run an accident without installing Access of some sort.
  7. gemma-the-husky

    Re-design a wellworking data base

    One other thought is "duplicating" your system at the new location, and running it as a separate standalone company on the same software. If you intend to merge the two companies into a single entity, then this won't be such a good idea, but if you want to keep them separate you then need to...
  8. gemma-the-husky

    MVF Technical Discussion and Uses (If you plan to Use Them)

    Because multi select anything is really not relational, more presentational. I had a system where selling prices were displayed in a grid with products as row entries, and packsizes as column entries. That's non relational, so I stored the data as relational, Rows with column entries for...
  9. gemma-the-husky

    Future of Access

    I think the difficult thing with web software is enforcing the time-sequential nature of things. The very way web sites work makes ensuring the logic flow of a commercial (database) application is awkward. Not sure what the technical terms are.
  10. gemma-the-husky

    Help with moving Access database

    I don't think you can avoid that message with an unlicensed copy of access. You have to set the location/database as trusted somehow. You only have to click "yes" once on opening don't you?
  11. gemma-the-husky

    Solved Functionality differences between .accdb and .accde

    There are some design changes that you can make in a accdb, but which aren't stored in a accde. For example, I think if you change column widths in a spreadsheet type form they don't get permanently stored in a accde. Error 2501 just means the form couldn't open, but doesn't identify the exact...
  12. gemma-the-husky

    Solved Begginer! please help.

    What I meant is... I just googled "software for vets " and got a list of a number of packages. None of them are really saying how much their solution costs, but if you know any of them from other vet practices you might get some help. Doesn't your national vets association have some advice. It's...
  13. gemma-the-husky

    Solved Begginer! please help.

    Before you build this yourself. Is there not a reasonably inexpensive commercial system available you could use? Maybe a single user system would work, or one for a small number of users. That might be much more effective than doing it yourself. An experienced developer might put something...
  14. gemma-the-husky

    Access throws Error 3625 - Saying the text file [Import] specification doesn't exist, but it does.

    @Papa_Bear1 I was going to post this. I had reached the end of Page 1, and didn't realise there was a P2. Anyway parts of this may still be helpful. I doubt very much the problem is access. Secondly, the code you have posted is not complete. Importantly, where is your error handling for the...
  15. gemma-the-husky

    Access throws Error 3625 - Saying the text file [Import] specification doesn't exist, but it does.

    What line of code displays the error? Can you not display the spec that it's trying to use to make sure you understand the error?
  16. gemma-the-husky

    2 queries in one form

    Well what you do is issue serial numbers from a way that guarantees a sequence (I prefer a seed table to dmax, personally), and don't delete records. Instead of delete mark it as "ignore".
  17. gemma-the-husky

    Finding which queries use specific control from the main form

    You mean to store and display the results, rather than extract the data? For my purposes, I am happy to just to save and display a text file. Anyway, the code was really to show how easy it was to use the querydef object.
  18. gemma-the-husky

    Finding which queries use specific control from the main form

    You can iterate the queries (querydefs) and search for particular text. I use variations of this. This produces a report of all queries including the findtext text You can easily modify this to include multiple findtext values (such as your "from" and "to" requirements) Sub...
  19. gemma-the-husky

    Importing a spreadsheet to existing table where column names don't match

    And yet, with Access, users are likely to find and use short cuts and cut and paste operations you never even new existed.
  20. gemma-the-husky

    Table - After Update question

    I don't think you can do this with an after update macro. You no longer have .oldvalues once the update has completed. You have to record/audit the changes before the commit, so the beforeupdate event. You also have to consider carefully what you are trying to do. If a person changes his phone...
Back
Top Bottom