Search results

  1. C

    FindLast method

    I'm trying to use the FindLast method to look up a patient's last visit by visitid when adding a new visit. When I add a new visit I would like it to look up their last visit and use the values in some of the fields as the default value of the new visit. Does that make sense? The visitid is...
  2. C

    Search for previous record based on id

    I'm still searching the form for something that will help me but so far I haven't quite found what I need. I have a database that tracks patient visits. On their first visit, their patient history is entered. On their next visit, there are some fields that need to show what was entered on the...
  3. C

    Link subform and form

    I have a form set up with 3 drop down boxes. From the first box the user selects from a category of patient types. The next box then lists patient names based on their selection in the first box. The last box lists the patients visit dates based on the patient they picked. I now need to add...
  4. C

    Subform problem

    I have a form set up with 3 drop down boxes. From the first box the user selects from a category of patient types. The next box then lists patient names based on their selection in the first box. The last box lists the patients visit dates based on the patient they picked. I now need to add...
  5. C

    Combine fields in one textbox on a report

    I have a database with phone numbers, pager numbers, etc. Some people have pager numbers that are private, not published to other employees. I currently have a report that will bring up a list of people by department, etc that shows their phone and pager numbers along with other information...
  6. C

    Navigating combo box

    If an answer to this is out there, sorry. I haven't had luck finding anything. I have a form with an unbound combo box. When you select an item from the box, the objects on the form and subform fill in based on the selection. The person using this would like to click arrows to navigate...
  7. C

    Track changes by users

    What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
  8. C

    Import data help

    I'm importing data from a spreadsheet to a new table in access. After the import, there are 10 empty records added at the end of the table. I think this has happened before but I don't remember why. Any ideas? Thanks!:confused:
Back
Top Bottom