Search results

  1. gemma-the-husky

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

    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...
  3. 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...
  4. 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?
  5. 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".
  6. 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.
  7. 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...
  8. 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.
  9. 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...
  10. gemma-the-husky

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

    It's better to make it foolproof, than find you got rogue data into your system. :D
  11. gemma-the-husky

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

    I think there's 2 options. Either accept the data columns without checking, or specify the column headers. (Maybe this is importing a csv, rather than a spreadsheet.) For safety I like to check the column headers are what I expect. Especially as it's always possible that the spreadsheet my...
  12. gemma-the-husky

    Undo Changes on a Main form and associated Sub Forms

    Do you mean design changes, or data edits? Edit - looking at the previous thread, I take it data. Do you mean reverse the change after the edit and update has taken place?
  13. gemma-the-husky

    Access vs Comercially available databases

    And from the sound of it, they already have a working system.
  14. gemma-the-husky

    Add clock values to report query

    @Technics You don't do a night shift do you? If you have employees clocking on at 6pm say, and finishing at 2pm, you now have different days for each time stamp, and this will need to be taken into account.
  15. gemma-the-husky

    This database was created with the 32-bit version of Microsoft Access. Please open it with the 32-bit version of Microsoft Access.

    Or Remove 64 bit office, and install 32 bit office. Part of this is caused because MS used to install 32bit by default, and now installs 64 bit. As I just found out, it's very difficult to remove 64 bit in order to install 32 bit. It just said "cant install 32bit". It didn't offer to...
  16. gemma-the-husky

    Access vs Comercially available databases

    It's good to see a lot more answers on this, but I thought the real question the OP was asking is whether the functionality of a commercial system would be better than the system that was already in place.
  17. gemma-the-husky

    Solved Table Updates - PK changes - help

    I've not read the whole thread, but surely a few product descriptions doesn't matter Add a column, number probably Mark the active items as 1 Mark the archived items as 2 Mark the redundant items as 3 Then you can cascade delete all of the "3" records, and any related records, deal with the...
  18. gemma-the-husky

    Access 2007...

    Well runtime will crash instantly on any unhandled error. If you were getting errors on your old machine that you could recover from, you will not get that opportunity to resolve the problem with run time. You are OK running well tested apps on run time, but you still really need a...
  19. gemma-the-husky

    Clear out data

    If you split the database, your users don't need to add any new forms. They just replace the old front end with a new front end. If you want to add new data to their backend, you can give them a single process that inserts all the new data for them It would just look like the way an install...
  20. gemma-the-husky

    Access 2007...

    But didn't you say you don't have Access installed on the new PC. (#14) How can you be running an access database?
Back
Top Bottom