Hi "any book that is already borrowed. Is that what you want to do?" YES
Here is My DB if you want to check it. it's hard to me to explain it. http://www.geocities.com/vip2442_access/library11.zip Use ID "106" Thank You for Helping me --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > You are not answering all my questions: > > 1) What is the design of your table? Please include important information > about any other related tables. > > 2) What is the Row Source of the CopyC combo box? (The SQL) > > 3) What code runs when the user picks something in CopyC? > > If CopyC lists all books and the Row Source contains the Borrowed flag, you > can check in the BeforeUpdate event of the combo box to disallow selecting > any book that is already borrowed. Is that what you want to do? > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > > From: vip2442_access [mailto:[EMAIL PROTECTED] > > Sent: Friday, March 25, 2005 4:54 PM > > To: [email protected] > > Subject: [ms_access] Re: Help me M.r. John Viescas > > > > > > > > > > OK Let's Start again. > > > > Forget Every thing about Male & Female!: > > > > The answers is. > > > > 1 - CopyC List All books. > > 2 -That code set to Borrowed. > > > > After selection the CopyC i got the Staus of the "BORROWED" CheckBOX > > if it True OR False. > > > > True = Borrowed book. > > False = Not Borrowed. > > > > And > > > > Borrowed Books Can't Borrowed Again. > > > > > > (The Same Thing for Resering CheckBox) > > > > I hope you understand me > > > > Thanks > > > > > > > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > > I see nothing to do with "Male" (Man) or "Female" (Woman). > > > > > > What is the design of your table? Does CopyC list all books or > > only > > > available ones? Is there code that runs when you select a value > > in CopyC? > > > Does that code set Borrowed or Reserved? What is the business > > logic you are > > > trying to enforce? > > > > > > I know that English is not your first language -- but I am > > struggling to > > > understand you. > > > > > > John Viescas, author > > > "Building Microsoft Access Applications" > > > "Microsoft Office Access 2003 Inside Out" > > > "Running Microsoft Access 2000" > > > "SQL Queries for Mere Mortals" > > > http://www.viescas.com/ > > > > > > > -----Original Message----- > > > > From: vip2442_access [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, March 25, 2005 2:16 AM > > > > To: [email protected] > > > > Subject: [ms_access] Re: Help me M.r. John Viescas > > > > > > > > > > > > > > > > > > > > This is my real problem (lock to this Picture) > > > > http://lonelymoon2442.jeeran.com/borr.JPG > > > > > > > > > > > > This is my borrowing form there is Two CheckBox's The first one > > for > > > > BORROWING that get that status of the copy if it allready > > belonge to > > > > this member or not (if it brlonge to him i got messege that this > > > > copy allready belonge to him) > > > > > > > > note: the checkbox appear directly when i type the CopyC. > > > > > > > > > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> > > wrote: > > > > > It's not working because you're not being clear about what you > > > > want to do. > > > > > In your previous message, you said you don't want to allow > > changes > > > > if the > > > > > checkbox is checked, so I provided code to make that happen. > > Now > > > > you tell > > > > > me the CheckBox is True for men and False for Women. That > > doesn't > > > > make > > > > > sense. > > > > > > > > > > What is it you really want to do? > > > > > > > > > > John Viescas, author > > > > > "Building Microsoft Access Applications" > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > "Running Microsoft Access 2000" > > > > > "SQL Queries for Mere Mortals" > > > > > http://www.viescas.com/ > > > > > > > > > > > -----Original Message----- > > > > > > From: vip2442_access [mailto:[EMAIL PROTECTED] > > > > > > Sent: Thursday, March 24, 2005 6:19 PM > > > > > > To: [email protected] > > > > > > Subject: [ms_access] Re: Help me M.r. John Viescas > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > it's not working! > > > > > > > > > > > > it's work when i change it and that not what i want > > > > > > > > > > > > > > > > > > Take this Example: > > > > > > > > > > > > If i have records for Men and Women when i type the ID i got > > the > > > > > > other information for that record Include CheckBox (True for > > > > Men) > > > > > > (False for Women) > > > > > > > > > > > > if i change the name and the record is Related for Men i got > > > > ERROR > > > > > > MESSEGE. > > > > > > > > > > > > > > > > > > > > > > > > --- In [email protected], "John Viescas" > > <[EMAIL PROTECTED]> > > > > wrote: > > > > > > > Open the form in Design view. Open the Properties > > window. > > > > Find > > > > > > the Before > > > > > > > Update property for the form. Change it to [Event > > Procedure] > > > > and > > > > > > click the > > > > > > > Build (...) button next to the property. That will put > > you in > > > > the > > > > > > VB > > > > > > > Editor. If the control containing the CheckBox is named > > > > CheckBox, > > > > > > your code > > > > > > > might look like: > > > > > > > > > > > > > > Private Sub Form_BeforeUpdate(Cancel As Integer) > > > > > > > If Me.CheckBox = True Then > > > > > > > MsgBox "You can't change a checked record." > > > > > > > Cancel = True > > > > > > > Me.Undo > > > > > > > End If > > > > > > > End Sub > > > > > > > > > > > > > > John Viescas, author > > > > > > > "Building Microsoft Access Applications" > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > "Running Microsoft Access 2000" > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: vip2442_access [mailto:[EMAIL PROTECTED] > > > > > > > > Sent: Thursday, March 24, 2005 5:30 PM > > > > > > > > To: [email protected] > > > > > > > > Subject: [ms_access] Re: Help me M.r. John Viescas > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > yew that what i want > > > > > > > > how can i do that? > > > > > > > > i don't know how can i write it in VB code! > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- In [email protected], "John Viescas" > > > > <[EMAIL PROTECTED]> > > > > > > wrote: > > > > > > > > > I'm not sure I understand your questions. You might > > be > > > > able > > > > > > to > > > > > > > > put code in > > > > > > > > > the BeforeUpdate event of the form to look at the > > CheckBox > > > > and > > > > > > > > cancel any > > > > > > > > > updates. > > > > > > > > > > > > > > > > > > John Viescas, author > > > > > > > > > "Building Microsoft Access Applications" > > > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > > > "Running Microsoft Access 2000" > > > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > > From: vip2442_access [mailto:[EMAIL PROTECTED] > > > > > > > > > > Sent: Thursday, March 24, 2005 4:05 PM > > > > > > > > > > To: [email protected] > > > > > > > > > > Subject: [ms_access] Help me M.r. John Viescas > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 1- when i type the ID i will get the other data > > related > > > > to > > > > > > that > > > > > > > > ID. > > > > > > > > > > > > > > > > > > > > 2- Befor updating the record i want to check if the > > > > > > CheckBox is > > > > > > > > > > True so i can't update the record and get Messege. > > > > > > > > > > > > > > > > > > > > such as if i change name but the CheckBox is true i > > get > > > > > > messege > > > > > > > > for > > > > > > > > > > that and can't update > > > > > > > > > > > > > > > > > > > > else if that checkBox is false i can update. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
