Search results

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...

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...

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.

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...

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...

Hi, I have a question; If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup The next time I open the application how can I get them back? Any help will be very appreciated, Thanks, CS.

Hi I need a button code in the OnClick event. I want when clicking on the button, to close the currently opened form and open another one. Any help will be very much appreciated! Thanks guys! C.

Hi, I have a report that contains names, (each name in a row), I want to create a serial number for each name (i.e. 1, 2 , 3 , 4 ...) Please note that these names are grouped in sections, I want in each section the serial starts from 1 Regards, CS.

OK here is what I have: Table Name: Student Fields: Auto (Primary Key) MOI (number) Name (Text) I have 2 forms: 1) Student ,which contains student info I have created a combo box in this form for MOI, so whenever I type an MOI ID that have been previously entered I get the...

Hi All! I'm working on a Personal Information Database. I want my system to do the following whenever I enter a person's ID: If the ID is already entered before, I want all the personal info fields to be populated with the person's details. If the ID is not entered, then I will enter...

Hi Guys! I'm working on this database in which I have 2 forms: one form has personal information (PersonalInfo) and the other one is a search form (Search) In the search form I have a field in which I want to type any part of the Name field in PersonalInfo form and I want to retrieve all the...

Dear All. I have a visual basic function, placed in a module. I need to call it from a form field, and pass a value to it and the function has to return a value. I tried it but it doesn't work the value I get on the field is " #Name? " any help will be very appreciated. Thanks! CS.

Good day everyone! I'm designing a system in which I have two fields Amount in Numbers and Amount in Words I want to be able to type in the amount in numbers and the amount in words should appear automatically. I need the code and in wich event should I put it. This is an urgent request. any...

Hi, I'm facing this problem whenever I try to click on any button on my access system. I get the following error message: "" The expression on Click you entered as the event property setting producedthe following error: A problem occurred while Microsoft Office Access was communicating with...

Hi, this is me again and I need your help! How can I add a password to a button, i.e. whenever someone clicked on this button he has to enter a password in order to proceed to the form which the button opens? any help will be very much appreciated! Thanks and Regards! CS.