Makeing at least one record required! Re-post

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: James (James_at_discussions.microsoft.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 02:07:01 -0800

I have an employee information form that has a yes/no checkbox for the
employee to be an administrator. There must always be at least 1
administrator or they will not be able to login to the options section(which
is where the employee form link is located). What would you put in the
beforeupdate section to not allow a user to save a record unless there is at
least 1 admin?

thanx

Reply:
James,

This could not happen with a new employee record, right? This could
only happen if you are editing the record for an existing employee who
happens to be the only currently assigned Admin, and you remove the
admin status from this person. Do I understand correctly?

Response:
Correct. The database is started with an employee record called admin with
the admin check box = true. I want them to be able to delete the admin
record but only if one or more records has the admin check box = true.

Relevant Pages

  • Re: Archiving Entries
    ... expert in the sense of a 'network admin'. ... if they were two legitimate purchases, ... purchase was entered twice by mistake, or if the employee tried to ... a request could be entered twice. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Selective access to DB records w/o WHERE
    ... Add the SQL User name to the admin table if the user name is different from ... to do when an employee moves from one state to another.... ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: hacking into my computer at work
    ... My question is in regards to a fellow employee at work, ... As long as they have physical access to your computer and use an admin ... Turn on auditing of login events to see when it is happening. ... You not going through the security admins provided by the ...
    (microsoft.public.security)
  • VERY OT: the VA employee who took 26 million Vets personal info HOME!
    ... a Veteran's Admin ... employee took the personal info of 26 and a half million veterans HOME with ... Said employee did NOT have the right to take this kind of sensitive info ...
    (rec.crafts.textiles.yarn)
  • Re: Makeing at least one record required! Re-post
    ... "James" wrote in message ... > checked it pulls up the msgbox that show you must have at least 1 admin. ... Uhmmm, how does the administrator get in there, ... >>> is where the employee form link is located). ...
    (microsoft.public.access.formscoding)