Search results

Hi, I am working with access 2003. I have a form which is built up with a subform. What I want to do is be able to use the tab to move from one field from the main form to the field in the subform, when the tab is clicked. However, when I go to the tab order in the main form properties the...

Thank you very much!!!

Hi, The code below will convert john to John. However, I want any name entered to be converted not only john. How can I do that? Me.surname_forename = StrConv("john", vbProperCase) = John Thanks

Hi, I have this code which makes all the data displayed on the form in this respective field capital letters e.g John will be displayed as JOHN and saved as so. However, what i want to do is only make the first letter as John not JOHN. How can I change the code? Me.surname_forename =...

Please could you elaborate more, as it is not clear to me yet!!! Thanks

Hi, I have a main form (stud_details) also I have a subform called (pay_det_sub).The subform is displayed on the main form. I want to create a relationship between the stud_details and pay_det_sub, with the aid of a field on the stud_details called numhus (which is the primary key). So that...

Thank you very much Alisa, worked perfectly...

Hi, I have two forms, the main form called stud_details which contains a subform called pay_det_sub. The second form is called payr_lkup_name which has a combo box for the look up called cbopyrname. What i want to is when the payer name is selected it adds the payer name to the subform which...

Hi, My database when it loads it goes to a new record as programmed, then if you click any field on the form the following message is seen. And unless you leave the record / form it will always pop up. "Index or primary key can't contain a null value". Please not student_id was sent as the...

That would be easier yeah, but I dont have enough space on the main form. Thats why... What I want to do is when the payer code is selected, the payer code is populated on the subform. Please find the attached database, hope you dont mind helping... Secondly, I would like to create a...

Hi, I have two forms, main form is called stu_details and second form (look-up form) is called payr_lkup_name. On the second form I have a combo box which acts as look up for payer's names. What I want is that when the a payer name is selected it is populated on the main form (stu_details)...

Hi, I have a look-up table on a form, when the form opens it takes the whole page. What I want to do is fix this form to a smaller version (reduce the size of the form) to fit the details for the look-up only. Any help will be highly appreciated... Thanks

Thanks neileg sorted!!!

Sorry, am new to access how do u use StrConv after update event...... Thanks

What i want to do really is, even if the user is using small letters. The typed appears capital on the field and stored like so. So regardless, what the user uses small/capital letters. What will be shown and recorded on the form and table, respectively will be data in caps. Hope am clear...

Hi, How can I fix data populated in a field on a form to be capital letters always. Therefore, it is always displayed on Caps ... Thanks

I have sorted it finally, thank you guys

Thank you guys, I have sorted it...... Special thanks to Brianwarnock you pin pointed the problem. Many thanks to all

Sorry, where will I have to change it to full query...

I have one of the field's on the form. The idea was to do one first get it right then do the other two. So, presently, I want to have the inst_name1 working then will carry on doing inst_name2, inst_name3. The problem am facing is storing the result to the table. The control source is not...