Search results

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

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.

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

Thanks for the tips. The code worked perfectly.

regardless of how many fields I have, can I auto populate the ID field from one form onto 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.

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

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

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

worked great! thanks!

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?

Thank you!

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.

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.

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

Thanks. The query function doesn't recognize the 'replace' function. Any suggestions?

names with apostrophe This RetrievalField method worked great in finding patient names in my database, except if my name includes an apostrophe, like O'Donnell. I get an error and the search is abandoned. Suggestions on how to fix this? Thanks.

Thank you so much! Worked like a charm.

I have a form to enter data for patients into my table. In the past, I created a button to search records by patient last name using the button wizard to create a record navigation button. However, I had to make sure to repeat the search until I searched the entire table especially if I searched...

Thank you! I works lovely now.