Recent content by wethumpback

  1. W

    Using both Before and After Update together to track start and end dates

    Apologize ahead of time if I am being dumb here haha... So you are saying that I should move the before and after update events to within the FORM itself . Then, programmatically check to see if the owner control has changed and log from there (this makes sense, I can do that). The form has...
  2. W

    Using both Before and After Update together to track start and end dates

    Adding a Me.Requery on the After Update seems to have fixed the weird behavior. I will now attempt to use the Start and End date on the junction table and see if I can get that working. I should just need to modify the Before Update event to an update sql command. Thank you again for all of...
  3. W

    Using both Before and After Update together to track start and end dates

    I do understand and know all the normal forms (3NF etc...) I have already done exactly what you said by having the Assets, Owners, and Asset Assignment table. My issue lies in the inserting of this table for the new owner. I want the user to be able to select from the a drop down list of Owners...
  4. W

    Using both Before and After Update together to track start and end dates

    Thank you! I have SQL and plenty of programming experience, have never used Access before though and am on the learning curve, much would've preferred to just create a C# .NET MVC App to do this... but I cant. The template for this was there when I created a new Access DB. I tried to link it but...
  5. W

    Using both Before and After Update together to track start and end dates

    So here's the thing, I can't because I am working in a locked-down environment. I can tell you that the DB was built directly off of Microsoft's Asset DB template. The "Asset Details" form is the exact same as the template and the Asset table itself is just modified to include a few extra things...
  6. W

    Using both Before and After Update together to track start and end dates

    I have a database to track assets. I have a form that contains the details of the assets such as the owner. I want to be able to change the owner, use an update query to log the EndDateTime (unassigning the asset), and then add a new insert for the newly assigned owner at the StartDateTime...
See more
Top Bottom