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