Search results

  1. R

    Ensuring Data Conservation in Multi-User Environment

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

    Recording how many records are on a form at a given point in time

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

    Bloating of .accde file

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

    Data input writing reversed

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

    Search Key Not Found

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

    Run-time error 3061 - Recordsets

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

    Using Recordset to Automatically Add Missing Data

    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...
Back
Top Bottom