Recent content by jcpender

While setting the conditional format for the control in question, try setting the values to Format only cells where the: Field Value Is not between #6:00:00 PM# and #6:00:00 AM#. I was able to get this to produce the results I believe you're looking for, highlighting only times between 6:00...

Hey Rural Guy, thanks for the links. I looked at them, but they're a little more involved at than I was looking for. After tinkering with this for a while, I was finally able to figure it out :D. I changed the following: ' If control had previous value, record previous value. ElseIf...

I've been looking through all of the related threads for audit trails, but I haven't come across my situation. I'm only looking to capture the previous value of fields that have been changed. I don't need to know that every other field on a record hasn't been modified. I've applied the...

Thanks a million Craig, that did it. I've been picking at this one for quite a while now! :D

Hey Craig, this is the sql for the query. SELECT [MRB TABLE II].[MRB STATUS], [MRB TABLE II].SHEET_NO, [MRB TABLE II].PART_NUMBE FROM [MRB TABLE II] WHERE ((([MRB TABLE II].SHEET_NO)=[Enter Record Number] Or ([MRB TABLE II].SHEET_NO)=[forms]![Inspection]![Sheet_No]));

Thanks for the quick reply Craig, no luck, comes back with the same results.

I have a what I think should be a simple enough query, but I'm pulling my hair out trying to get this to work. I have a report based off of a query which prompts the user to either enter a record number manually or simply use the record number for the current record being displayed as the...