Search results

  1. I

    Question Intermittent Error

    I keep getting an intermittent error when I exit my database. (see attached) Microsoft Access can't delete C:\home\database\database.mdb after compacting it. The compacted database has been named C:\home\database\database1.mdb If you compact a database using the same name, Microsoft Access...
  2. I

    Easy way to Merg 2 tables

    I created a database back in 2009 and inserted all the patients from 2008 who passed away in the Hospital. Before I inserted all the patients details I had a blank copy of the database which I used to tweek and modify. I then started to use the new database in 2009 (I know this sounds like an...
  3. I

    Inserting a Query into a Table

    I have made an Access database which I use for my own recording only. The database logs all the people who pass away in the hospital where I work. I have a main Register table whith oter tables for wards, consultants ect. Rather than having to use my fingers for calculating the patients age I...
  4. I

    Calculate Age at time of Death

    I have a database, Access 2003, for patients in the Hospital where I work. The Main register has the following fields 1) Date_of_Birth and 2) Date_of_Death. I would like the Age to be calculated automaticly so I created a querie "Age Calculator" which has the two dates in and the following "Age...
  5. I

    2 Database Tables in to the One???

    I am an extreme beginner as you will see from this problem I have. I started to make a database for all the patients who pass through the mortuary in the Hospital where I work. This DB was to be able to give me stats on the RIP's in different wards and so on. Now I initially (I know this was...
  6. I

    Counting Multiple Tick Boxes in a Queery

    Firstly I am a complete Access novice! I have created an Access database for the Mortuary in the hospital where I work. The database has several tables, the main being the register of all patients who have passed away. I have several fields in the main table i.e. name date of birth and date of...
Top Bottom