Recent content by NeAlvey

I removed my Log In button from being a tabstop and it now works...Don't know if it'll help you or not, but it's fine for me! Good luck!

Any luck with this? I'm working on the same thing. I found I could change the <enter> key's behavior under the "Other" tab to New Line In Field and it works, however it appears to be adding the enter character to the password, thus it's wrong (if they mistype it once).

Hi all, Attached is a VERY generic database that includes the audit trail I've been using for the past several months. It is pretty flexible and can be updated to your liking. One downfall of it (IMO) is if you're using cascading updates and deletes, those will not show up in the audit table...

There can't be duplicate Study_IDs. There are multiple studies in tblStudy, however they are all unique. There are then multiple Patient_IDs per Study_ID, and then multiple Case_Nos per Patient_IDs. I guess it's just how I was taught in school. If I have fields that can be used as the key...

Hi all, I’m working on a temporary (so they say) database to keep track of case reports and I’m running into some issues. Very generically speaking, the logic works like this: The database will keep track of multiple studies. There are multiple patients in each study, and there is the...

Hi all. I'm working on a temporary database (Access 2003) for work until we get our system validated. Is it okay or acceptable to have a single-field table or do I need to throw an autonumber on there for the key? I really just need this table to populate a combobox/listbox in the form. I...

Thanks Pat for the reply...I've actually found another way around it now. I figure that since it isn't using multiple tables, I could just use frames within the tabs. If I broke the table apart into multiple tables then it worked better, but I can only imagine what that would do to the queries!

I've noticed that it appears to be going through the on_current event 4 times. However, if you're on record 20, go up to 21, then back to 20, it only runs the on_current event 2 times for record 20. Also, if I open the subform by itself (not within the main form) and go through the records, it...

I'm trying to clean up one HUGE and ugly form by using subforms within tabs. I have a main form with "BottleID" as the key field and linking field. The tab displays pictures based on the BottleID and it works like a dream. My problem is that the "on_current" event happens 4 times on each...