How to track amount of work done (production)

[bdhtexas]

Access '97 - Is there a way to track the amount of work completed by an individual. I have about 10 users and the Auditing Department wants to know how many records were updated the previous day and if those records updated can be listed somehow. I said that I would ask, so here you go!

 

[WayneRyan]

Matthew,

Access and the JET engine both have requirements for
working with STRINGS.

Dim psw As String
Dim x As Variant
'
' Access wants double quotes to let it know what a
' string is.
'
psw = "dennis"
'
' JET want single-quotes to let it know what a string is
'
x = dlookup ("[DBAdmin]", "tblAdmin", "[Password] = '" & psw & "'")
If IsNull(x) Then
   MsgBox("Bad password")
   Exit Sub
End If

JET wants the single-quotes for a string, so to put it in the
string you need to encase it double-quotes for Access. Rats,
now I'm getting confused.

I used a Variant for x, because if the DLookUp finds no records,
it returns a Null, which can't be assigned to a string.

You'll get used to it. If the password was a DateTime field, then
you'd switch the single-quotes to a "#" (without the quotes). If
it is a number than you don't "bracket" it with anything.

Wayne

 

[WayneRyan]

bdh,

You can add a new field to your table called LastUpdate.
Obviously, it is a DateTime field.

You can use your BeforeUpdate event of your form to set
the value of LastUpdate to =Now().

However, if you have user's that access your tables
directly or programatically then you need a solution
that does not involve Access (No table triggers).

Sorry ... Ignore my last post as I don't know my Ctrl-V from
my Ctrl-C.

Wayne

 

[Mitch_____W]

Access '97 - Is there a way to track the amount of work completed by an individual. I have about 10 users and the Auditing Department wants to know how many records were updated the previous day and if those records updated can be listed somehow. I said that I would ask, so here you go!

Check out the "Audit Trail Demo" db here:

http://members.shaw.ca/glenk/access2000.html