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

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

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

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

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

I want the date 'August 15, 2007' to display as 'August 2007'. Suggestions?

I created a shortcut icon on my computer to access an Access dB that's located on the company server. The Access db opened, but immediately froze and wasn't able to do anything (not responding). Any suggestions as to why this happened and how to fix it?

Is there an option so that turning the mouse wheel will scroll through the screen rather than scrolling through the different records in a form? Thanks! :confused:

This might be a basic Access application, but I'm having trouble. I want to create a name and address table that will include all patients in my clinic, identified by unique patient ID numbers. I then want to create 3 other tables for the information collected at the 3 appointments I will have...

I have a button on a form that queries my table for observations that meet a certain set of conditions, and then updates a field to mark these observations. But I keep getting the error message 'Compile error: Method or data member not found.' I have used the code successfully in a previous...