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: ms_access@yahoogroups.com > 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 ms_access@yahoogroups.com, "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: ms_access@yahoogroups.com > > > 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 ms_access@yahoogroups.com, "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: ms_access@yahoogroups.com > > > > > 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 ms_access@yahoogroups.com, "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: ms_access@yahoogroups.com > > > > > > > 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 <*> 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/
