I use the FileDateTime-Function on application startup to check the date created/modified property of the .exe file currently in use. I compare that to date and time of the .exe file that sits on the server and, if that one is newer, give the user a message to upgrade (you can even check with...
Actually, your 'MoveFirst' statement needs to be outside the loop, otherwise you keep returning to the first record with every cycle. Try it like this:
rsJobCost.MoveFirst
Do While rsJobCost.EOF = False
MsgBox Left(del_date, 4)
If Left(del_date, 4) <> YearTxt Then
YTD = YTD
End...
Have you tried installing the Access runtime version? It's part of Office Developer (at least the 2000 version, don't know about the 97 version) and you can include it in your application setup program when you use the Package & Deployment Wizard.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.