allenpramod
Last Activity: Feb 5 '07, 07:04 AM
Joined: Nov 25 '06
Location:
-
hi i solved date problem.now 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_nam e,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... -
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,s chool_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.Leave a comment:
-
how to select different check boxes
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_nam e,dob,dob1) with chkbox. how can i write code for that to select database fields using checkbox. tell... -
In queries(Query3)
--------------
select sno,name_teache r,division from " & me.cmbdist.text & " where name_school = "[forms]![Form6]![cmbschool].column(0)";
dim strsql as string
strsql="Query3"
docmd.OpenQuery "Query3",acView Normal,, acEdit
it didnt open query. i tried another one like this but wont create a query.how
...Leave a comment:
-
Forms Running Queries
i have a form which will display district_names in combo box(cmbdist), when i select this it will display name_school in combo box(cmbschool), when i select this it will run a query how? i used to do like this but error occuring syntax error in FROM clause.
select sno,name_teache r,division from " & me.cmbdist.text & " where name_school = "[forms]![Form6]![cmbschool].column(0)"; in Query3
... -
thank you for giving reply to me. I am new to this group. i am using tables
DISTRICT
------------
DIST_CODE(101,1 02...107)
DIST_NAME(BOKAR O1,EASTSING1,GA RHWA1,HAZARIBAG H1,LOHARDAGA1,R ANCHI1,SARAI1)
what ever the fields in dist_name is again tables
BOKARO1(NAME_OF _SCHOOL,NAME_OF _TEACHER,DIST_C ODE,DOB,DOJ)
EASTSING1(NAME_ OF_SCHOOL,NAME_ OF_TEACHER,DIST _CODE,DOB,DOJ)
GARHWA1(NAME_OF _SCHOOL,NAME_OF _TEACHER,DIST_C ODE,DOB,DOJ)...Leave a comment:
-
many to many relationships in subforms
i prepared a form having district,bokaro 1,eastsng1,garh wa,hazar,lohard ag and its fields are district(dist_c ode,dist_name) dist_name are bokaro1,eastsng 1 etc.. as above bokaro1 fields(name_of_ teacher,name_of _school,dob,dis t_code etc.. r there) eastsng1(name_o f_teacher,name_ of_school,dob) etcc.. r there with this in my form i create a combo boxes for dist_code,dist_ name,name_of_sc hool.when i double click dist_code it will display dist_name and when...
No activity results to display
Leave a comment: