Search results

Thanks for responding Summerwind. ADO code is fine too. I was just using DAO because that is the code I found. I do have it finding the patient's ID. I just didn't include that part. I will give this a try.

I'm trying to use the FindLast method to look up a patient's last visit by visitid when adding a new visit. When I add a new visit I would like it to look up their last visit and use the values in some of the fields as the default value of the new visit. Does that make sense? The visitid is...

I'm still searching the form for something that will help me but so far I haven't quite found what I need. I have a database that tracks patient visits. On their first visit, their patient history is entered. On their next visit, there are some fields that need to show what was entered on the...

I have a form set up with 3 drop down boxes. From the first box the user selects from a category of patient types. The next box then lists patient names based on their selection in the first box. The last box lists the patients visit dates based on the patient they picked. I now need to add...

Anybody? Any ideas are appreciated. :D

I have a form set up with 3 drop down boxes. From the first box the user selects from a category of patient types. The next box then lists patient names based on their selection in the first box. The last box lists the patients visit dates based on the patient they picked. I now need to add...

I have a database with phone numbers, pager numbers, etc. Some people have pager numbers that are private, not published to other employees. I currently have a report that will bring up a list of people by department, etc that shows their phone and pager numbers along with other information...

They want to use arrows to navigate through the combo box. Does that make sense?

If an answer to this is out there, sorry. I haven't had luck finding anything. I have a form with an unbound combo box. When you select an item from the box, the objects on the form and subform fill in based on the selection. The person using this would like to click arrows to navigate...

I'm looking to do the same thing you are. I just found this post and it has a link that I'm looking at now. I think this will help you as well. http://www.access-programmers.co.uk/forums/showthread.php?t=103194&highlight=combo+boxes

OK, I got the date to go into the table by putting lastupdated=now() in the beforeupdate event procedure. How do I capture the username to put in my updateby field? Thanks for bearing with me!

Thanks for the help. I do really just want to know who modified it last. I've tried searching the forums but haven't found anything that is clear enough. I don't write code much anymore so I'm just having a tough time understanding some of what is out there. I have the 2 fields added to my...

I don't want to do an Audit Trail really. I just want to know who made a change,when and to what record. I don't need to track the changes to the record. I can't seem to find anything that will give me a basic step by step of how to do this.

What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?

I'm importing data from a spreadsheet to a new table in access. After the import, there are 10 empty records added at the end of the table. I think this has happened before but I don't remember why. Any ideas? Thanks!:confused: