Search results

thanks! that worked awesome!

Hello Rich! Thanks for your help with this problem i have. I tried putting your code into a module in my db. (called it "modPrevRecVal") Then in the text box in my form i made its controlsource =PrevRecVal("tblFX13","subfrmFX13","Date",[Date],"TroughRead") But the thing is giving me an error...

Is it possible to use a variable when setting a control property of an object? (ie. Me.Visible=false --> replace "Me" with variable for FormName to be hidden) i've tried to guess at the syntax, but nothing's worked so i'm thinking it's not possible. And Help doesn't mention it that i can find...

If there wasn't a reading for the previous day, then it can take the difference between the two readings anyway. (for simplicity's sake) Any suggestions on what exactly i should have the FindPrevious search for?

For some reason i cannot find "PrevRec" function in the Help (Access or VB). I can find "FindPrevious,MovePrevious, Seek", but no PrevRec. What does this function do? Next suggestion?

SITUATION: consumption rates of water taken from meter readings. Want to know daily consumption based on today's reading subtract yesterday's reading. (Each reading is in it's own record. Readings are not always taken daily so cannot use <date> as a criteria.) Tried using crosstab query but...

i have a report that opens after selecting certain criteria in a previous form. the report itself is grouped by PERIOD. i can get textboxes in the period footer to sum/count records for each period. but the query can also select only certain records that match a GROUP within that PERIOD. i...

could try target_date = null

i had similiar trouble with the calendar control and trying to copy date values. i found that the control had to have focus (once again an annoyance) before i could copy its value. here`s the sub that i`ve used to complete this task. -------- Private Sub GoBack_Click() On Error GoTo...