Search results

No. both combo boxes (Nationality, PlaceOfBirth) have the same values (which is country names). What I want is: when in Nationality the user choose a country (for example USA) in the PlaceOfBirth USA will appear, which the user can change if the employee was not born in USA. its just a way to...

I did. the results I got on how to control the values of one combo box depending on the value choose in another combo box. in my case the values are not changing, I just want to default one combo box depending on the value used in another combo box

Hi, In my form I have 2 combo boxes. one for Nationality, and the other is for PlaceOfBirth. I want the PlaceOfBirth to be defaulted with whatever nationality the user choose. How can I do that? any help is very appreciated. Thanks, CS.

Hi, I have a SearchResult Form, it only display search results. one of the field in this form is a LookUp field (Nationality). and LookUp fields, as you know has this arrow next to them. and since this form display only the results, i don't need this arrow. how can I remove it? i tried...

IT WORKED!!!! THANK YOU KEMPES !! YOU ARE GENIUS !! Thanks alot man!

Kempes which field name do you mean in: FieldName.Requery and please note that my 2 comboboxes are in a subform not a masterform.

Hi, I have a problem and I need any help I can get! I have a master form (MasterForm) and a subform (SubForm). in the SubForm I have 2 comboboxes (Institution) and (Office). Each Institution has a number of Offices. What I want is: Based of the Institution the user choose, the offices that...

Hi, In my search form I have 5 creterias and in the query behind it I joined them by AND. the problem is if the user entered only 2 or 3 of those creterias, the query will not return anything. how can I slove that? your responses are very appreciated. Regards, CS.

Hi, I have 2 forms, a master and a subform. In the subform form there are some required fields. In the table behind the subform I choose the property of these fields to be required. but in the master form, when I start enter the information I can go to the next record without even touching the...

That solved the problem in the case of me searching on AreaOFStrength. But in case I was searching by name, i.e. I typed in the name Mark in the SearchForm to get all the employees whose names are Mark. and Mark has English and Math in his AreaOfStrength. I would be getting 2 records for the...

Ok here is the situation. I have a Search form, in which the user will choose an AreaOfStrength (for example English). and I have a SearchResult Form, in which the result of the search will appear. (it contains only Employee Names who have the AreaOfStrength I choose in the SearchForm, the...

Hi, I'm designing this system in which each employee has different area of strength (i.e. Math, Languages,..) if an employee has 2 or 3 area of strength his name appears in the query more than once. I want his name to appear once. I tried "group by" but it gave me an error. I think I'm doing...

in my form I created an unbound field with a requested combination, now how can I put those in a table field. in other words, how can I send the content of a form's unbound field to a field in the table? your help is very appreciated. Regards, CS.

I completely understand what you are saying, but my manager is asking for this!!! I tried to explain what you are saying 100s of itmes to him but that what he wants! in my form I created an unbound field with the requested combination, now how can I put those in a table field. in other words...

What is the code?

I did that. I want to store the field with the combined characters in the table.

Hi, I'm designing a database in which the primary key is a combination of the first letter of first name, the first letter of last name and the date of birth. How can I do that? Regards, CS

Hi All, It's me again!! I have another question. I'm designing this system in which each end user should has a password, and each user has different rights, some can just read, some can add, some can update and some can delete. how can I achieve that? I also want to know how can I disable...

That's what I did. I want to carry the Primary Key of the main form to the subform by clicking on a button.

Hi all, I'm designing a db in which I have a list of teacher names, and for each record (each teacher), there is a list of subject that this teacher teaches. what i did is the following: I have designed a form with teacher name, and a form for subjects. I have added a button in the teacher...