I just inherited an Access 2007 database that was done in an earlier version of Access, and have to get it modified before tomorrow. I haven't worked with VB or Access for years, so I'm banging my head at the moment.
There is a table called "participants."
There is a field within the table called "minutes."
On the entry form, there is text box called "minutesCurrent" that displays the value in the "minutes" field.
There is another text box on the entry form called "newMinutes."
There is a Command Button with a plus symbol in it that calls an event procedure. In the VB code it looks like this:
Private Sub addNewMinutes_Click()
[minutesCurrent] = [minutesCurrent] + [newMinutes]
[newMinutes] = 0
In theory, clicking on the command button should take whatever value has been put into newMinutes, add it to minutesCurrent (and refresh that text box), and clear out newMinutes. It doesn't do anything, of course.
If anyone could point me in the general direction of what the VB should be doing, I would appreciate it.