Meter Reader in Access

[gulsarwar]

hi

I m new, and i want to make a meter reader in Access for daily use. i want to be enter only last reading every day at data entry form and that last reading must appear as first reading of the next day automaticaly in same table, because i have only one table in my database. fields are "date", "1streading", "2ndreading" & one data entry form and one report. is it possible in access, if so please help me. thanks

 

[RuralGuy]

You might find this link of some help.

 

[RuralGuy]

While I am thinking about it, you should not use Date as the name of a field.
Problem names and reserved words in Access

 

[gulsarwar]

Thanku for reply, please explain it by attch example, if possible.

 

[ajetrumpet]

First of all, RuralGuy is correct. Scrap the "date" field name. That'll surely stop you in the future.

And, you don't necessarily need to take Microsoft's advice on this (although Method #1 in the above article should not be too difficult to follow). Maybe you could just start the new day's record when you finish out the current day's data entry. Say, like this:

dim rs as recordset
   set rs = me.recordsetclone

rs.addnew
   rs!DateField = date() + 1
   rs!1stReading = me.ControlThatHoldsThe2ndReadingForToday
rs.update
rs.close

set rs = nothing

That simple piece of code can start you rolling on the next day. Maybe you could stick it behind a button on your form....??

 

[gulsarwar]

please attach an example

 

[namliam]

Please make fix my problem for me ...

 

[gulsarwar]

i do it, i take a unbound hidded text box on form, data source is Max value of 2nd reading field & insert this value to 1st reading text box thru vb code. it works fine. thanks for help