Search results

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

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

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