Hi,
I am working on a single form. I have two combo box named as-
1) CAST and 2) CATEGORY
Combo box CAST has options like - Brahmin, Jat, Gurjar, Bunkar etc.
And Combo box CATEGORY has option like - GEN, OBC, ST, SC etc.
I want to write a vba code in after update event for combo box CAST, so if I choose option like Jat or Gurjar, the Combo box CATEGORY should be enabled. And, if I choose option like Bunkar or Brahmin,...
Jugnu
Last Activity: Aug 12 '18, 11:48 AM
Joined: May 12 '18
Location:
-
Enabling and disabling fields based on value of combo box.
-
2nd part of pics is here..
if you need any other information related to our form or database kindly suggest.
thanks :)... -
NeoPa
thanks for your kind suggestions.
here we attached some pics of our form properties. through attach files in advanced option.
[imgnothumb]https://bytes.com/attachments/attachment/9468d1527596414/dtbs-pic-1.jpg[/imgnothumb]
[imgnothumb]https://bytes.com/attachments/attachment/9469d1527596414/dtbs-pic-2.jpg[/imgnothumb]
[imgnothumb]https://bytes.com/attachments/attachment/9470d1527596414/dtbs-pic-3.jpg[/imgnothumb]...Leave a comment:
-
Hi NeoPa,
thanks a lot for your support.
here are the pics of form data properties.
please check them and inform us if you need any other information regarding to our database.
we don't know all the technical details necessary to upload pictures. if they do not appear to you then please guide us how to create an URL for images which are save in desktop.
...Leave a comment:
-
Hi NeoPa,
We really appreciate your efforts and want to thank you.
But some how this expression is not working for us.
We have a different designed form then yours. After filling all the details related to a student and clicking save button, it shows an empty form to fill next student details.
We already added three unbounded text boxes in footer of our form. Two out of 3 uses "SumIIf" formula to count total numbers...Leave a comment:
-
Hi NeoPa and twinnyfo,
Here is our database table, which looks a like-
...Code:STUDENT NAME | GENDER | DOB | COUNTRY | COURSE | HOME ADDRESS -------------|--------|---------|---------|--------|------------- ALEX NASH | MALE |2/3/1999 | LONDON | PGDCA |......... SIANA JOSH | FEMALE |3/1/1998 | LONDON | B.Sc |......... RITA | FEMALE |8/2/2000 | GERMANY | B.Sc. |......... BHARAT PATEL | MALE
Last edited by NeoPa; May 26 '18, 01:51 PM. Reason: After saving it do not looks like a table. {Use the [CODE] tags for that -NeoPa.}Leave a comment:
-
Hi NeoPa,
We changed the name according to your suggestions. But still we are gating error. Some times we get wrong number of arguments when we change "AND" with "&" or "+" signs.
Really don't know what to do. ��Leave a comment:
-
Hi NeoPa,
Thanks for your precious reply.
The expression code is still not working for us. Our combo boxes for gender and country are named as "GENDER" and "COUNTRY". They do not have a cbo-prefix.
We tried the code without cbo-prefix but it didn't work.
In contry field we have three options
London, Germany and France. But in all records (we have total 50 records) we use only London and Germany....Leave a comment:
-
Hi twinnyfo,
sorry for incomplete information,we are just learning it.
we are using a continuous form for a database table which is not a split type.
the gender and country fields have combo box like male & female and London & Germany.
we want to put some unbounded text boxes in the footer of a continuous form like txtEngMal and txtEngFem to count total number of males and females which belongs to England and Germany....Leave a comment:
-
Hi NeoPa.
Thanks for your reply. We tried those expressions but they didn't work for us. When we put that code into control source it shows error. we just copy and paste that code to avoid any typing error. our text boxes are as yours like txtEngMal and fields are also like Country and Gender. these fields are having combo box for LONDON & GERMANY and MALE & FEMALE respectively.
We are working on a continuous form and our database...Leave a comment:
-
Hi twinnyfo,
Thanks for your kind reply.
I have a table in database where these are columns-
1) Student name
2) Gender
3) DOB
4) Country
5) Course
6) Home Address, in home address we only put country name like London or Germany.
We record for each Student name, indicating in each record whether the person is Male/Female and where they are from.
Now we want to count -
1) how many females...Leave a comment:
-
Thanks NeoPa.
It completely works for me.
You really such a genius ��Leave a comment:
-
Multi field value cross sum
Hi, i have a problem in ms access form.
I have two fields
1) Gender = male or female values
and
2) Country = London or Germany
Now i want to add few boxes in form which can display
1) Total number of female from London
2) Total number of female from Germany and
3) Total number of male from London
4) Total number of male from Germany
I am a teacher of sociology and don't know how to write... -
Thanks NeoPa,
But i am completely new to VBA and don't know what to write in after update event.
Will you please guide how to do this.
I have a field in database table named as
Home address and i have two unbound boxes in my form1 named as city and pin number.
I want enter data of city and pin number boxes in to home address field. Please guide me with a VBA code how to do this.
Thanks for your kind reply. ��Leave a comment:
-
Enabling and disabling fields
I have two field.
1) Angel
2) Devil
I want that if i fill ANGEL field with any text the DEVIL field should become disable or grey out. But if i left ANGEL field blank the DEVIL field should be enable to fill text.
Please healp. -
Add text of two unbound text boxes into one field.
i want to add text from two unbound text box into one field, when i write an expression for this, the result appear in the form but the field table remain empty.
Please suggest a solution.
No activity results to display
Leave a comment: