Workflow Approval - Approval Button? (1 Viewer)

Hey

Sorry for so many posts but google isn't helping because it's sending me to sharepoint which we dont have...

I need to add an approval button onto a form that once clicked will in fill in various properties... easy. However I need it to look at who the logged in user is (computer login, not database login) and then work out if they are actually allowed to approve this form,

Previously in excel I had it ping the server to check connection, lookup application user name, check this against an if else or statement and if all ok approve the document and send an email stating it had been approved, if not all ok, bring up a message box that gave people crap for trying to approve something they shouldn't.

I have tried moving this over to access but I can't get it to work at all. Any ideas, or hint on how to get this to work?

Thanks,
Cat

have a table of Approved people.

tblAuthorized (tbl)
ID (autnumber)
AuthorizedName (text)

fill the table of all Computer name on your network.

using Environ("UserName"), you can get the Computer name of the workstation.
you can then compare this to the values in the Table:

If DCount("1", "tblAuthorized", "AuthorizedName ='" & Environ("UserName")) > 0 Then
'valid to approved
Else
'no valid
End If

arnelgp said:

have a table of Approved people.

tblAuthorized (tbl)
ID (autnumber)
AuthorizedName (text)

fill the table of all Computer name on your network.

using Environ("UserName"), you can get the Computer name of the workstation.
you can then compare this to the values in the Table:

If DCount("1", "tblAuthorized", "AuthorizedName ='" & Environ("UserName")) > 0 Then
'valid to approved
Else
'no valid
End If

Click to expand...

Will give this a go, thanks

there is a catch here.
somebody may used an authorized person's computer and
do the entry there.

Its possible, but unlikely. This is no more or less secure than our current Excel based system...