By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

how to select different check boxes

P: 7
i am working with ms access. i got a problem with checkboxes. i create a checkbox in the form named chkbox with database fields.i am using continuous form so database fields are displayed with checkbox field. when i select one checkbox all checkboxes are selected. how can i select different checkboxes with database fields(teacher_name,school_name,dob,dob1) with chkbox. how can i write code for that to select database fields using checkbox. tell me i need it urgently.

thank you,
with regards,
Jan 9 '07 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,656
This is not usual behaviour.
I would guess that you have all the CheckBoxes bound to the same field in your table. Is that right?
If so, that is your fix too (Bind them to the correct fields only - or unbind if that's right for your usage).
Jan 9 '07 #2

P: 7
yes u r right, thank you i bound it to same field later that i used option group and bound it to all fields (teacher_name,school_name,dob,dob1) but when i click on the check box it wont check the box. try to help me please. one more thing i have date format dob field. for eg. 3.5.2000 i need last day of the month like 31.5.2000 how can i do for dob field tell me.
Jan 10 '07 #3

P: 7
hi i solved date i am getting last day of month, problem is checkbox, i used an unbound check that is not in database, i bound all fields(teacher_name,school_name,dob,dob1) with checkbox(chkbox),when i am selecting checkbox it wont select the checkbox,last one empty record with checkbox when i click this it will select all records checkboxes what is the problem.i didnt understand, is there any code needed i didnt get any thoughts to my brain to write,please tell me i am in urgent
Jan 10 '07 #4

Expert Mod 15k+
P: 31,656
To find the last date of the month for any given date ([GivenDate]) :
Expand|Select|Wrap|Line Numbers
  1. DateAdd("m",1,CDate(Format([GivenDate],"1 mmm yyyy")))-1
if in VBA or within SQL is :
Expand|Select|Wrap|Line Numbers
  1. DateAdd('m',1,CDate(Format([GivenDate],'1 mmm yyyy')))-1
I'm afraid I can't follow the rest of what you're saying. Perhaps you could rephrase the position you're currently at. Separate different items into different sentences.
Jan 10 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.