Re: Makeing at least one record required! Re-post

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 05:22:41 -0800

James

Are you saying that you want to prevent any records until an administrator
is in the database? Uhmmm, how does the administrator get in there, then?
<g>

If you wrote some code to count the number of rows with the Admin checked,
you could use this to confirm the presence of at least one... 

-- 
Good luck
Jeff Boyce
<Access MVP>
"James" <James@discussions.microsoft.com> wrote in message
news:252D3B7D-7473-453F-AEE6-D17CB5C94FF4@microsoft.com...
> 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: Security
    ... > owner and administrator, then took the Admin account and assigned it ... > Can anybody now access my database without the workgroupfile that was ... It sounds OK, but if you want to test, rejoin your system.mdw workgroup ...
    (microsoft.public.access.security)
  • RE: Creating a My Site Template for all sites
    ... simply stored in the personalization database. ... Changes to the site definition will not appear for that user. ... To make changes for all users, the administrator can change the My Site site ... So if a user has unghosted his My Site before the admin changes the site ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Makeing at least one record required! Re-post
    ... checked it pulls up the msgbox that show you must have at least 1 admin. ... Uhmmm, how does the administrator get in there, then? ... The database is started with an employee record called admin ...
    (microsoft.public.access.formscoding)
  • Makeing at least one record required! Re-post
    ... I have an employee information form that has a yes/no checkbox for the ... administrator or they will not be able to login to the options section(which ... happens to be the only currently assigned Admin, ...
    (microsoft.public.access.formscoding)
  • 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)