Search results

Thanks for all your help. The last code from "SomeGuy" works great.

Mike, In response to your question, as we enter the new year, I want to make sure that the users don't enter the year 2000. If they enter the year 2000 and they run a report based on data for the year 2001, the data won't show up.

When I click on my drop down box to select a record, and I select ex. Mary Smith to bring up her form, if there is more than one person with the same last name, ex. Ann Smith, John Smith and Debbie Smith, it will bring up Ann Smith first, and then I would have to click the next button to get to...

As we go into a new year, is there a formula I can enter on my subform in the date field that will tell me if I enter the wrong year? Example: You entered 1/1/00 and it should be 1/1/01. Any help in advance is greatly appreciated.

I have 2 forms: a main form and notes and comment form. One opens the other. My database is setup where some of the forms have the same ID# (Unique Key). The reason, ex. Tom Smith was discharged from care and then readmitted with a different Admission Date but the ID# will stay the same. My...

How do I coordinate my find field in my main form so when I click on Smith, Kathy her form comes up. The way my form is currently setup,if I choose Smith, Kathy and I have more that one "Smith" in my database, example (Smith, Jane; Smith, Tom) Jane will display first. Any help in advance is...

I have a main form and second form that are linked. When I open up the main form and go to the second form the patient name is the same in both forms which is correct. My question is when I open up the second form and I have 2 filters I want the link to be based on the admission date. My main...

I created a main form and want to keep the patient records together. (Some of the patients are entered more than once). Their IDS are the same but their admission dates are different. When I sort the forms I come across several records with the last name "Smith" with first names Jane and Tom...

I created a main form and want to lock some of the fields because I don't want the user to accidentally delete the data in that field. Is there a code that I could write that would prompt the user that says "Are you sure you want to make a change to this field." Once he/she makes the change it...

My question is say I am entering data for Mr. Johnson on my main form, and I need to go to another form or page to enter notes and comments, I want that second form to open up with Mr. Johnson's name and not at the being of the alphabet. (PatientID is my primary key on the main form) The...

I have a few questions: 1. I have a main form and one subform that are linked. Do I add the notes and comments field to the main form or do I set up a separate table called notes and comments and a separate form? 2. Once I add a button and I click on that button to open up the notes and...

One of our nurses would like to click a button on the form and another screen would open up to type notes and comments. They are currently hand writing and tracking their notes in a notebook. Can this be done? Thanks for any help in advance.

Thanks for your help on question #1. Its works great!!!!!!!!

I have a combo box that when you select an item in the drop down box, it brings up related data in the other three fields. My problem is when one of the fields is empty I am getting a zero length string error. What code do I need to write that will accept fields that are blank? My second...

Thanks for your help. It works great!!!!!

I have a find record combo box. When you click the drop down box, you select a name from the list. Sometimes, the names are listed more than once because there is more than one record for each name (some are active and some are inactive. For example, Jane Doe has two records. One is active...