Search results

Thanks, SteveR! All forms on our system are bound, because during the construction of the system from scratch I had not appreciated that there were advantages in using unbound forms. I shall now investigate the advantages of unbound forms. You guys have given me a lot of thought-food, which I...

Thanks, essaytee! Greatly appreciate your help!

Thanks again guys! It really is wonderful to be able to tap into good support before the head-bashing cracks the skull or the wall falls down! Thanks for the ref to Tech Republic. I am a member there, but had not thought of searching there. At the wildlife hospital we run a hard-wired system...

Thank you all VERY much for all your help. A few replies:- Smig:- • 8 Client computers with 11 individual .accde Client files linked to central server data record file. • FE cannot be opened without C&R. SteveR:- • ” I would encourage you to do an internet/forum search concerning MS Access data...

Many thanks indeed SteveR, and Smig! Greatly appreciated. The data loss is actually complete record loss. An illustration is a vet entering copious notes on a koala's Patient Record one afternoon, then closing the Patient Record form and proceeding to write up another patient's record. The...

Current Situation:- • Busy but impoverished veterinary wildlife hospital with 30 – 40 new patients each day (more in the summer), and 1 pro bono inexperienced programmer (that’s me!). • Software (in Access 2010) is 100% proven working on individual computers in a linked file system currently...

Thanks again, Galaxiom! Based on what you and MarkK say, I think I'm going to go with Windows Scheduler, which will have to open the Master Client file on the server, which will then run the query, and close down on the timer. Your advice much appreciated!

Thanks, Galaxiom! Your help greatly appreciated. My use of the opening of the table was in order to generate only one count per day. (The In-House List is used by the vets to select which animal gets their attention next, so once opened it stays open for the day). However, I have to find...

OK, thanks again! Almost there, but not quite. We now have:- Private Sub Form_Current() DoCmd.OpenForm "FRM_InHouseCount", acNormal, , , acFormAdd Forms!FRM_InHouseCount.CountTime = Now() Forms!FRM_InHouseCount.InHouseCount = Me.Recordset.RecordCount DoCmd.Close acForm...

The problem with MarkK's method is that it does not take into account the animals held in the hospital under observation.

Many thanks MarkK, and Galaxiom! Mark, Galaxiom is correct, since the objective is to produce historical records for trending and budgetary purposes. I appreciate that simply calculating your results "live" is better than recording a calculated number, but in this case we need to record the...

Hi guys! I'm working pro bono on an Access db system for a wildlife hospital. We need to be able to record from the system how many patients (animals) we have every night. We have a form that shows the number of animals in-house as we admit and discharge animals, but I need to be able to record...

Thank you Bob Fitz, and again MarkK! I had been suspecting for a while that the set-up may be at fault, and yes, I can confirm that your interpretation is quite correct. The set-up has been that way for a couple of years at least, and it has taken me a long time to become aware of the bloating...

Thanks MarkK! Your comments greatly appreciated. Yes, by stability I was referring to steadily increasing file size. If I was to set AlwaysCompactOnClose would this cause 10 CoCs one after the other as my users shut down? Running 3 instances of the file on one machine will I believe cause that...

Hi guys! I need help with this one! I work as a volunteer for a busy wildlife hospital in Australia. I have a current Access 2010 application of a front-end Client file (.accde) linked to a back-end data file (.accdb) which records all veterinary records for all patients admitted to and...

Hi guys! Strangest thing I've seen yet - I'm running pro bono a linked file database for a wildlife hospital in Australia. I have a Form in which there are several fields for vets to enter data about a wildlife patient. One of these is the Collection Plan (for the patient). This is a memo field...

Hi guys! I'm maintaining an Access database application pro bono for a busy wildlife hospital on Australia's Gold Coast. The db now has close on 24k records. It is serviced on a linked file system running on 7 different client instances. They need to delete a problem record, but find they...

Got myself in real need of help here, and wonder whether you’d be able to assist? Problem:- In a wildlife hospital we want to automatically select the ‘Previous Accession Number’ under which an animal known by its ‘First Accession Number’ (or ‘PatientID’) was last treated by CWH before...

Many thanks Beetle! Reason for two apparently identical sets of data is that first column is used to identify occasions of a wildlife animal being brought into a wildlife hospital, whereas the second column provides an ID by which the animal is then known throughout maybe several re-visits...

Hi guys! I am trying to use a DAO recordset in an Access2007 client file to loop through a series of records using vba to find in a record where a specific field is null, and if so set the field equal to the record ID. I have tried:- Dim db As Database Dim rs As DAO.Recordset...