Search results

How do I give credit for the solution on this forum?

Yes, I am all good now. I created 100% of the database. I was just having a dumb moment. My brain was stuck on tring to use the expression in the properties. And being self taught my mind glitched on the terminology for Event Procedure. I always refer to it as VBA. Thank you for your guidance on...

I do not know how to create an Event Procedure Ahh ok I get it now. I placed it in the event procedure and it now updates with the proper date and populate the main maintenance table! Thank you so much for being patient with me to help me solve this. I am truly eternally greatful to you. it is...

ya i know :( have alot to clean up. Form name is (CamInoutoMaintTF Form). I am attaching the Healthcheck repair document table which is imported as I mentioned previously. The form may need when opening just in case. If needed, Wherever to have the databse saved create s folder called...

I am uploading my original extracted test database. The login below should take you right to the form. I am not sure if it will error not being conneted to the imported Healthcheck Repair Due report. I checks for the report and automaticall updates it after connecting. I believe I disabled that...

Spoke to soon, But I still Love you! I'm doing something wrong of course. Works on the Test2 database but not in my original. Getting a Microsoft Access cannot fint the object 'Me.' message box. Bus field After Update: Me.LastEntryTimeStamp = DMax("[LastEntryTimeStamp]", "[CameraHealthCheck...

That worked! I added it to the afterupdate and it now populates and changes!!!!!!! I love you sooooo much!!!!!!!

of missed that, After Update

ah you didn't use any code you just manually entered the Date/Time?

Yes there should be a date/time after entering a Bus number. But Your Test2 file won't change when the bus number is changed nor work at all on the next record. Or was this just an example of what it should be populated to look like?

This resulted in a #Name? error when used in Default Value

Where should I place the Me. code other than default Value, Unless this usage is ok here?

For my actual database the "Repairs Due Query" is an imported table with specific data fields which includes LastEntryTimeStamp. My maintenance Form records repairs made to the MaintT Table. which has "Repair Date". I have a query that looks at when the repairs were requested to be made...

I made a quick sample database which I uploaded. Table/Query Names were simplified for ease. That basic function of what I am trying to accomplish is the same. Yes, I have been entering this in Default Value this whole time. Where should I be utilyzing this code. I tried entering into the...

This resolved the #Error, but there is no result. Just a blank field.

I made a sample from scratch to replicate my issue db which is giving me the same result. Let me know what you think. I'm not getting a result at all after I enter a Bus number from the repairDue Query that should bring in the LastEntryTimeStamp data for that Bus.

The Data Type for Bus is Number. btw, I was working on that procedure then crashed the db. :/ I have to start from a backup. oh my life.........

I just tried this Dlookup with the same #Error result. Please excuse my ignorance with the string criteria code, as I am self taught. I am not sure where to place this snippet to test. I tried inserting a module to run it but that didn't work out :/ Where should I be placing this?

If you have the patience, can you guide me on these steps?

Bus is a Number Data Type. Sorry, not sure what to do to create a string variable for the criteria to debug.print and see if it is correct. :(