Search results

Hi, List is bounded to a query which list names that match the search. I tried the searchid to Long type mismatch is prompted. I reckon string is the correct syntax. The problem is sorted for the searchid mismatch, the only problem faced currently is that when a name is selected it is not...

Thanks Paul, The error has disappeared, however, when I click another record with the same forename it is not popualated on the database. The previous record is always there. the code am using is Private Sub List0_Click() SearchID = List0 DoCmd.OpenForm "stud_details" DoCmd.GoToControl...

Hi there, I have a sample database from this forum which has a module named Variable and contains Public SearchID As Integer this works well for the sample database where the onclick event on the form with the search details coded as below, SearchID = List0 DoCmd.OpenForm...

I made a query and joint two tables payer_det and payer_lkup, with the payer_code and created the join. To bring forward the HESA, fin_code and fees_remitted When I run the query the results are fine. Now, how will I make the above fields (HESA, fin_code and fees_remitted) be recorded on...

Hi there, Consider 2 simple tables Name ID Pet A 00 dog B 11 cat C 22 hamster Name ID hasJob A 00 no B 11 yes D 33 yes how do I make a join to get this table? Name ID Pet hasJob A 00 dog no B...

Hi, I have a table called payer_det which will record the details of the payers. This is a subform. I have other fields on the table which are not shown on the form. However, when a field such as payer_code is selected in the subform I want the other three fields i.e., fin_code, HESA, and...

Hi, I have the code below which makes every initial of the surname_forename field start with a capital letter. Thats fine!!! So for example john, smith will be John, Smith Me.surname_forename = StrConv(Me.surname_forename, vbProperCase) However, this works ok if the user keeps a space after...

Hi, Any help!!!! much appreciated...... I have a main form which is build up with a subform. The form and subform are in a relationship with enforce intergrity and cascading deletes enforced. The delete button when clicked deletes the data in the fields in both the main form and subform...

Thanks well spotted!!!!

I have two tables which I have created a relationship from (payer_det and stud_details). However, when I am in the Edit Relationship and trying to Enforce Referential intergrity the following error is prompted "Data in the table 'payer_det' violates the referential intergrity rules" What...

Hi, I have a very simple question.. My main form is build up with a subform. When I click delete button it deletes the fields on the main form but not on the subform. It can be done, however, by set the cascading deletes in the table join, however, am not sure how to find the Edit tables...

Sorry, on the relationship window it shows the tables in a relationship. Where will I be able to see the join so that I can double click it to set the properties. Thanks

Hi, I have a main form and within it I have a subform. When I click the delete command it deletes the fields on the main form but not on the subform. This is confirmed by going to the subform table the data is still available. However, on the main form the data is deleted from its respective...

Thanks Boblarson

Hi, I have this code (shown below) which selects a value from the combo box which is stored in another textbox field. The code works well, however, what I want to do is, when I have selected the value from the combo box I want it to disappear rather than remembered. This is because when I...

Thanks for the forward which I reviewed. I understand the method there is I will have a combo box, when selected will update another text box/text boxes. Also, have a combo box with both the fields then used to update only one field and populate the rests on the text box. Am familiar with...

Hi, I have a table on my db called nationality which is built up of two fields; 1) nation_code 2) nation On my main form, called stud_details I have a field called cbonation which has a combo box with only the nation displayed not the nation_code. What I want to do is when I scroll on the...

Hi, I have a table on my db called nationality which is built up of two fields; 1) nation_code 2) nation on My main form, called stud_details I have a field called cbonation which has a combo box. What I want to do is when I scroll on the combo box and find a nation such as UK with the code...

Hi, This is the problem am facing know. When I navigate to the subform it moves to the third field (Session) instead of the first field (payer code). I went to the tab order in the subform and placed payer code, then payer name then Session and said OK. However, when I visit the main page it...

Managed to sort it !!!