(Msg. 1) Posted: Thu Oct 02, 2008 3:55 am
Post subject: Double Booking Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
Hi
I am trying to avoid being able to do double bookings in a form. I have a
combo box holding 3 options eg AM PM All Day. Based on the date of the
booking if it is ALL Day then I would like the combo box to be blank if PM is
booked on a particular date then I would like only AM to be available. I
hope this makes sense and that someone can give me Basic! instruction on how
to do this.
--
Regards Clair
(Msg. 2) Posted: Thu Oct 02, 2008 12:07 pm
Post subject: RE: Double Booking [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Chester,
if you really want to avoid double bookins I thing creating an unique index
on the combination of fields that should remain unique is the easiest way.
--
Kind regards
Noëlla
"Chester1" wrote:
> Hi
>
> I am trying to avoid being able to do double bookings in a form. I have a
> combo box holding 3 options eg AM PM All Day. Based on the date of the
> booking if it is ALL Day then I would like the combo box to be blank if PM is
> booked on a particular date then I would like only AM to be available. I
> hope this makes sense and that someone can give me Basic! instruction on how
> to do this.
> --
> Regards Clair
(Msg. 3) Posted: Thu Oct 02, 2008 5:28 pm
Post subject: Re: Double Booking [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Chester1" <Chester1.TakeThisOut@discussions.microsoft.com> wrote in message
news:D8F793DD-C1A7-4566-8FF1-0ECBD34DDF6E@microsoft.com...
> Hi
>
> I am trying to avoid being able to do double bookings in a form. I have a
> combo box holding 3 options eg AM PM All Day. Based on the date of the
> booking if it is ALL Day then I would like the combo box to be blank if PM
> is
> booked on a particular date then I would like only AM to be available. I
> hope this makes sense and that someone can give me Basic! instruction on
> how
> to do this.
> --
> Regards Clair
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other