Search results

Sorry I must have miss lead you earlier. The error occurs when either of us close the program, but we don't both use the program at the same time. Microsoft Access 10, the application, is on a stand alone PC and the database file was on the file server. Wife logs on as Wife and runs Access 10...

C&R all switched off. I am definitely to only user, I have even moved the DB to my local PC so as not to have the chance of a second user opening by accident. I have been reading up on splitting, I have even had a little play, but I have a macro driven switchboard and when I split the DB id...

I will try this. It's not a problem when I am using this database but when the wife uses it and it happens that when I get the "I can't open the program" question. Does C&R cause problems?

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...

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...

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...

OK can I ask one more question? It is part of this problem and I am a novice and this is not for profit! I created a Query called Age Calculator and I now have my 3 fields in, DOB, RIP & the Age (calculated from the above formula). When I go back to my main Register Table and add a field Age...

Worked a treat :) Thanks verry much! Now all I have to do is figure out how to put the data (Age) into the form ;)

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...

Will have to do that from home, the firewall here wont let me upload images. I can e mail to home tho :)

Chris, Unfortunatly I have the tables linked (I think). As well as keeping a register of the Deaths I also need to add the Undertaker, the Ward/Other Hospital and the Consultant. This data is all stored in separate tables (i.e. a table for Consultants, one for the Ward ect) this way I can add a...

Yes both the Primary Keys are auto numbers and I think this is where the problem is, some of 2008 and 2009's data have the same numbers! 2009, as this was the first development, starts from 1 and goes to 1100+. I started 2008 after 2009 and the primary key on this starts at 190. I think I need...

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...

Thanks very much for all your help. If you ever need my help...... well let's just say I hope you don't :)

So two more questions from here. I put a -1 in the Criteria and all Refered to Coroners now only appear, with a -1 in the columb. Do I need to turn the -1 in to a +1 in order to count (Count rather than Sum)? Second Question. If I want a report to show Total Coroners and Total Post Mortems...

OK I have my Query. Now lets say 20 people have died in November and of that 20, 10 were refered to the Coroner. Out of the 10 refered to the Coroner only 1 post mortem was ordered. My Query for November gives 20 records. If I put =Yes into the Crieria of Refered to Coroner I now only get 10...

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...