Search results

I’m trying to get this code to work, but I’ get “Type Mismatch” on the strFilterCriteria line. C_CG_Prod is the name of my query, and Data the name of a field in the query. Dim db As Database Dim strFilterCriteria As Date strFilterCriteria = "SELECT * FROM C_CG_Prod WHERE Data = #" & InputBox...

Hi! I have a form, which has 3 fields. One is the date, the other is the meter value (TarA), and the last is the consumption (CTarA) which is the difference between the today's meter value and yesterday's. I also want to have the option to correct previous readings if necessary, and so I have...

I'm working with a form (based on a table) that has one numeric field (CTarA) that is dependent on a different numeric field (TarA) of the previous record. When using the AfterUpdate method on field TarA, on an old record, is there a simple way of updating field CtarA of the next record? I'm at...