Search results

I'm a medical student, and trying to organize diseases, lab tests, physical exam findings, and symptoms into a database.The disease will be related to 2+ "symptoms", 2+ physical exam findings, and 2+ lab tests to diagnose. So when I pull up a disease in the query, I want to see all of the...

But I want the entire record to be unique - not just a field or two...For example, I have another table called "Keys". There are fields called "Building" and "Room". There are two buildings, and the two buildings have overlapping room numbers because they are separate buildings....therefore, I'm...

Hi everyone! I have several fields in my table "Employees". But I want to make sure that a user doesn't enter the same employee information twice...more specifically, I'm not trying to prevent a single field (like "Last Name") but trying to prevent duplicating the record (which includes all the...

Thanks a lot!!!! is there a place where I can find these code bits?

Hi everyone! I have a form with a field that has a drop down menu (which links back to a field in another table). When entering data in this field, the user can either select data from the drop down menu or manually type it (and of course there is an error when the entered name is not part of...

hehe...i didn't enable macros... thanks so much john...you helped me so much on this. I'll watch out for your threads so I can return the favor (when I get to the point that I know my stuff hehe)

It only works for me because I have my cursor in the LastName field (and the field is highlighted when you open it). If I click on another field (like email), and hit the "Submit" button or the new record icon, it goes to the next record but the same field (email).... is this happening to you too?

Thanks so much John. The only problem now is that it isn't setting the focus to "Lastname" after I inserted the current event code......:( When I go to a new record, it doesn't automatically go to Lastname....

The control name was "Last Name". I changed it to "LastName"...and reinserted the code. I still get the error message. Here is the updated database with the new control if you need to look at it: http://www.megaupload.com/?d=ZA5JS5X1

I've renamed the field in the table...it automatically updated the form as well. Here is my database if it helps: http://www.megaupload.com/?d=LCXNA1AS

I've tried the code after taking out the space in the field name. But I still get the same error message after I put the code in. I've attached my code insertion and the error message. What is going wrong??? (the line above the code is the cursor)

Where do I insert the code? I've tried inserting in "On Current Event" in sheet properties, but it gave me a error for not being able to recognize it. I also don't know where to put it in visual basic...i'm really new to this. Can someone guide me...

All I could find was how to go to the next record...but I also want to go to the first field of the record

I'm trying to set up a "Submit Button" which will allow you to go to the next record and the first field of the record upon clicking or pressing enter on it (in a form). How can set up this command? Thanks in advance!

DUDE! you solved all my problems. You also clued me into how to build a subdatasheet with my own fields (i didn't know we could use queries to do this!) THANKS A TON!!

Hi everyone, I currently have a subform in my form, but it is only viewable when I scroll down through the form (it doesn't take up the whole screen). The subform can be potentially viewable on the same screen because it fits the screen. But the form's border prevents viewing that....how can I...

I actually figured it out...thanks a lot!!! I was wondering how i can extend the border of the form so I can show the subform without scrolling?

could you please elaborate on how to set this up? I'm a beginner to access.

is there any way to pull out the relevant fields that I posted about? Presenting simply an "ID" is irrelevant to the user. Please let me know.

Hi everyone, I'm trying to make the subdatasheet for my tables (I've attached a snapshot of the relationships) which shows the following: - The "Key Users" table with a subdatasheet that shows everything from table "Key Assignments" and fields "Building" and "Room" from table "Key" - The...