Database Login Form required? please help

[Gary]

to set the scence: -

six salesman and one admin team, the admin team consists of 3 people.
so in total with have 9 users of the database.
----

The database has a custom menu bar. Only one menu heading at the
moments, and that is called 'leads' off of this there is only one
option at the moment. 'add new lead'.

The idea is that each member of the admin team will have the database
open. when a new lead comes through they will choose that menu option i
just explained. This loads a form which allows them to enter the
callers name, telephone number, and via a dropdown box indicate the
salesman they are passing the lead through to.

the salesman then when he gets the call through clicks on a yet to be
invented menu option 'take lead'.

I want this to display the last lead entered lead for the salesman
CURRENTLY LOGGED IN.

i have no idea how i should achieve this.

Should i make a custom login form at the start of the database, which
stores the salesman's name in a string and then use this string in a
query? If i do this i would have the problem that all records for that
particular salesman will be displayed by the query, however using the
following code (gleamed from an earlier post) i think I can get around
this (can someone clarify if i'm on the right lines here please.) -

SELECT * FROM yourtable
WHERE [Field 2] = (SELECT Max([Field 2]) FROM yourtable AS X
WHERE X.[Salesman] LIKE [Enter salesman's name:] & "*")

my question is should i make my own login form, and if so how should i
do this? thanks

Gary.

 

[Lynn Trapp]

Gary,
Why reinvent the wheel? Access has a built in User Level Security option
that should suit your purposes quite well. When properly implemented, the
users will be prompted to log on. Then, you can reference each user through
the CurrentUser() function. There is a Security FAQ document that you need
to follow to the letter, after reading it several times. There is a link to
it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Douglas J Steele]

OTOH, Access Security might be overkill in this situation, as I don't see
any need to control access to the data.

The GetUserName API, illustrated in
http://www.mvps.org/access/api/api0008.htm at "The Access Web", might
suffice.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Gary,
Why reinvent the wheel? Access has a built in User Level Security option
that should suit your purposes quite well. When properly implemented, the
users will be prompted to log on. Then, you can reference each user through
the CurrentUser() function. There is a Security FAQ document that you need
to follow to the letter, after reading it several times. There is a link to
it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

to set the scence: -

six salesman and one admin team, the admin team consists of 3 people.
so in total with have 9 users of the database.
----

The database has a custom menu bar. Only one menu heading at the
moments, and that is called 'leads' off of this there is only one
option at the moment. 'add new lead'.

The idea is that each member of the admin team will have the database
open. when a new lead comes through they will choose that menu option i
just explained. This loads a form which allows them to enter the
callers name, telephone number, and via a dropdown box indicate the
salesman they are passing the lead through to.

the salesman then when he gets the call through clicks on a yet to be
invented menu option 'take lead'.

I want this to display the last lead entered lead for the salesman
CURRENTLY LOGGED IN.

i have no idea how i should achieve this.

Should i make a custom login form at the start of the database, which
stores the salesman's name in a string and then use this string in a
query? If i do this i would have the problem that all records for that
particular salesman will be displayed by the query, however using the
following code (gleamed from an earlier post) i think I can get around
this (can someone clarify if i'm on the right lines here please.) -

SELECT * FROM yourtable
WHERE [Field 2] = (SELECT Max([Field 2]) FROM yourtable AS X
WHERE X.[Salesman] LIKE [Enter salesman's name:] & "*")

my question is should i make my own login form, and if so how should i
do this? thanks

Gary.

 

[Lynn Trapp]

Excellent observation, Doug. You are probably right here.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

OTOH, Access Security might be overkill in this situation, as I don't see
any need to control access to the data.

The GetUserName API, illustrated in
http://www.mvps.org/access/api/api0008.htm at "The Access Web", might
suffice.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Gary,
Why reinvent the wheel? Access has a built in User Level Security option
that should suit your purposes quite well. When properly implemented, the
users will be prompted to log on. Then, you can reference each user through
the CurrentUser() function. There is a Security FAQ document that you
need
to follow to the letter, after reading it several times. There is a link to
it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

to set the scence: -

six salesman and one admin team, the admin team consists of 3 people.
so in total with have 9 users of the database.
----

The database has a custom menu bar. Only one menu heading at the
moments, and that is called 'leads' off of this there is only one
option at the moment. 'add new lead'.

The idea is that each member of the admin team will have the database
open. when a new lead comes through they will choose that menu option i
just explained. This loads a form which allows them to enter the
callers name, telephone number, and via a dropdown box indicate the
salesman they are passing the lead through to.

the salesman then when he gets the call through clicks on a yet to be
invented menu option 'take lead'.

I want this to display the last lead entered lead for the salesman
CURRENTLY LOGGED IN.

i have no idea how i should achieve this.

Should i make a custom login form at the start of the database, which
stores the salesman's name in a string and then use this string in a
query? If i do this i would have the problem that all records for that
particular salesman will be displayed by the query, however using the
following code (gleamed from an earlier post) i think I can get around
this (can someone clarify if i'm on the right lines here please.) -

SELECT * FROM yourtable
WHERE [Field 2] = (SELECT Max([Field 2]) FROM yourtable AS X
WHERE X.[Salesman] LIKE [Enter salesman's name:] & "*")

my question is should i make my own login form, and if so how should i
do this? thanks

Gary.

 

[aaron.kempf]

you know; access data projects have a real security model.

i mean-- you can secure objects based on username and allow read or
read-write functionality

 

[aaron.kempf]

you know; access data projects have a real security model.

i mean-- you can secure objects based on username and allow read or
read-write functionality

 

[Lynn Trapp]

Well, it doesn't appear to me that the OP is concerned about what ADP's can
or cannot do.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[aaron.kempf]

Lynn

I dont give a shit; they're having problems that aren't present in ADP

sorry your a sql-wimp Lynn

learn ADP it rocks!