Search results

Yes, and thats the name of the fields inst_name1,2 & 3. I would like the data to be stored on these fields respectively.

Contro source I run the query and I never saw the new fields either Please find a copy of the database, thanks

Thats the problem, I have created a text box whereby it will be updated with the field selected at the combo box, e.g Liverpool University when clicked will be populated on another field. This works fine!!! But next time when I open the record it is not there. This is mainly because it is not...

I have added it on the query design, inst_name. However, it is not showing on the control source neither... Am i doing anything wrong????

Hallo, I have a post code field on my form. What I want to do is, if a user enters a wrong code ... i,.e., not Post code format it alerts the user of post-code not in use. Please if there is any example of a database of this functionality usage or a way of doing it will be much appreciated...

Hallo, I am working with access 2003, I have a table called qual_hist. I have added a new field called inst_name(to store the name of the institution). However, when I go to the respective text box on the form (design view) on the control source inst_name is not shown. Though, it is in the...

Hallo, Simple question, is their a way of showing the value on the combo box without saving it in a table. Therefore, when you open the form again next time the value last selected is viewed again. Thanks

One last thing, when I have selected the institution for example Birmingham. The code is populated on the field successfully. What I want to do is also, retain the Birmingham on the combo box when I view it next time. Is it possible... Thanks

Thank you very much for your quickest response. I have sorted it out.. Much appreciated Regards

Thank you guys, it has worked perfectly well.

Thanks you for the code, I have updated the code and followed the procedure, however, whenever I select the School such as Liverpool university it is populated on the field, instead of the code... The code looks something like so... Private Sub cboSchoolName_AfterUpdate() Dim strSQL As...

Hallo, I have downloaded a calendar mdb from the link below from this site. http://allenbrowne.com/ser-51.html I managed to import it successfully into my database. However, the title bar still says " Set the start date" I would like to change this to " Date Obtained".. Any help.... Thanks

Thanks for your response, but how do u bind the school_code to the field. An example will do.. Regards

Hallo, I have a form (Qual_hist) with a field named Institution. Also, I have a table with all the institutions around 490 universities/colleges with their respective codes. The table has two field names 1) school_code 2) school What I want to do is create a look-up table for the field...

Hallo, I am working with access 2003, I have form1 which is populated with student_Id (primary key) with other details. Then when a button is clicked it moves you to another form2. Now, the relationship is between the student_id from form1 and form2. The problem is that the student_Id was...

hallo, I have two forms, from one form I can navigate to the other form. What I want to do is that when I populate the Student_ID field on the 1st form, and navigate to the 2nd form it automatically populates the Student_ID field on the 2nd form and saves it to the respective table. Now...

Ok, I have entered data on the first form, but still it does not happen. The way round it is go to the respective table i.e., qual_hist and enter the Student_ID in the table. This works perfectly. However, for example a user is entering a new record of a student. He populates all the...

Sorry Ken, When I entered a new student details and went to the Qualification history and entered details when I click save it says "Index or primary key cannot contain a Null Value" Secondly, why does it jump to institution rather than qual_type1.... This is a problem I also face in the...

Thank you very much Ken. It works perfectly....

Ken, please review the database attached. What I want to do is that when a record of a student is brought forward, and a user clicks the Qualification History it brings forward the second form and the qualifications based on the Student_ID. The Primary key for the inter-link is the Student_ID...