Recent content by Robjenj

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