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 11:37:25 -0800

James

Try creating a Totals query, counting the rows WHERE Admin = True (or how
ever you've set that up). You can then press the Design button to look at
the SQL statement. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"James" <James@discussions.microsoft.com> wrote in message
news:09253B10-B7DA-48D5-9DBB-65B22EB20766@microsoft.com...
> First, thank you for all of your help!
> So how would you count the rows?
>
> I tried this code but it doesn't work correctly.  No matter how many are
> checked it pulls up the msgbox that show you must have at least 1 admin.
I
> think it's in the DSum.
>
> "Jeff Boyce" wrote:
>
> > 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.
> > >
> > >
> > >
> >
> >
Loading