Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Ms Access update field automatically

 
Loh Ying Hui
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to add numbers automatically into a certain field in a table for every record whenever it reaches month-end. This action has to be automatic, means, no action button should be clicked by admin for this. How is this possible with Access ?
 
Amit Tiwary
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have posted a one like urs.Hope u get answer quickly.
Where r the brains today???
It might be due to Valentines day.
Anyway,Happy Valentines day
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this a JDBC question?
In SQL Server you can set up a stored procedure that executes every so often. I don't have a clue about Access; it's probably much more limited.
Alternatively, you can use the WinNT/2K/XP scheduler to run an Access or Java application every month.
- Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic