Recent content by UCLA Lorna

  1. U

    referencing a table to impute data

    I have a table with of zip codes and it's associated city. I have a 2nd table with patient information. In my form, I would like to type in the zip code for a patient's address and cross reference the zip code table to automatically impute the city name. I've done this before, but can't...
  2. U

    Compact dB without creating new dB

    that's odd because I'm on I have several dB's on the same computer, all created on the same computer, but only one or two create a new dB when I compact. I will try the hotfix to see if this resolves the problem.
  3. U

    Compact dB without creating new dB

    When I compact my database, Access creates a new database named 'db1.mdb' rather than just overwriting my existing database. How do get it just overwrite the old one? Some of my database just overwrite, but I have one in particular that just keeps creating new databases and I can't figure out...
  4. U

    data from one form to the next

    Thanks for the tips. The code worked perfectly.
  5. U

    data from one form to the next

    regardless of how many fields I have, can I auto populate the ID field from one form onto the next?
  6. U

    data from one form to the next

    i actually have 4 tables because i have 500+ fields for each patient. i only mentioned 2 tables to make the explanation easier.
  7. U

    data from one form to the next

    I am entering patient information and it requires 2 tables and 2 forms to get all the fields entered. Both tables have a field for patient ID. I enter the patient ID in form 1. When I finish entering data in form 1, I want form 2 to automatically open and the ID number to automatically populate...
  8. U

    Mulitple columns for grouped report

    I have a report that prints 1 page per doctor. Each doctor has 1-15 patients that also appear on the page. I want to be able to print the patients names in 2 columns at the below the main text of the letter to keep everything on 1 page. I have done the following: 1. In page setup, under...
  9. U

    Autogenerating study ID number

    I've got some code to create a unique ID number for each patient that enters my research study. It's just in sequential order with an 'S' in front such that the 1st patient is S001 and the 2nd is S002. I first create the sequential number and then add the S to it, but I'm getting the following...
  10. U

    printing a report from a form

    worked great! thanks!
  11. U

    printing a report from a form

    names with single quotes or hyphens My search function works great, except for names with a single quote (O'Connor) or with a hypen (Smith-Doe). How can I fix this?
  12. U

    printing a report from a form

    Thank you!
  13. U

    printing a report from a form

    DoCmd.OpenForm "SecondFormName", , , "LastName = '" & Me.LastName & "'" & "FirstName = '" & Me.FirstName & "'" Adding a second condition this way doesn't work. I tried several different versions of this, none successful.
  14. U

    printing a report from a form

    Thanks! That worked great. What if I want to filter based on 2 conditions rather than just one? I tried modifying it but am getting an error.
  15. U

    printing a report from a form

    I have a form that shows individual patient data. I want be able print out a mailing label for the current record shown on the form. I tried adding a command button the printed my mailing label (report), but the report needs to be linked to a data source and it prints out labels for all the...
See more
Back
Top Bottom