Ms Access, vb and SQL question ?

Question

I have a vb form that needs a little visible counter that says you have x new requests but it should refresh automatically every few seconds and it should get the number from a sum query

can you help me do that (code would be most appreciated) I am using ms access, please don't answer if you don't know how.

no .net backround, just plain vb sql and access

Answer 1

Use a timer. Set the timer for the time you want to refresh like 1000 = 1 second. So maybe every 60 seconds? 60000.

In the timer code

con=currentdb

strsql = "select sum(abc) abc from table where blah=1"

rs=con.execute(strsql)

text1.text = rs("abc")

Something like that.