Search results

  1. K

    To link a record in a form with another form

    Hey Pat That's a neat way to do referencing on records. Maybe I can try that in my next database project. :) Thanks. BTW, I've used tabs on my form. Looks nice and more organized. :D
  2. K

    To link a record in a form with another form

    Hayley I can see in your code there's a link field to link both forms. Does this code automatically sets the Passport_No of Spouse to have the same value of Passport_No of Student as well. Argh, VB..... The user will click the 'add spouse' button when he adds a new students record. Col I've...
  3. K

    To link a record in a form with another form

    Wow... that was fast Col. :D Hmmm...I've never use Tab before in a form. And I'm not sure if I put a subform in a tab, can i then relate the spouse record with the student? is it the same as using a subform in a form? At first, i wanted to put the spouse subform in the student's form as...
  4. K

    To link a record in a form with another form

    Hello guys Hope you can help me with this. Here's the situation.... I have a form with all the student's details. I've added a command button in the form to open another form to let user to add details of spouse/children if the student is married. From Student form -> click 'Add Spouse' ->...
  5. K

    To display an error message when there's no data found

    Hey Rich Your code works. Thanks :D
  6. K

    To display an error message when there's no data found

    thanks bjackson and Rich :) At first, i wanted to use a combo box for the student's name to avoid user's typing error, but it seems inappropriate because there's hundreds of students records. I'll try the codes this evening. Gotta run to class. :rolleyes:
  7. K

    To display an error message when there's no data found

    Hi guys I need some help here. It may be a simple problem to some of u but I don't have much experience in Access :cool: I have a dialog box that ask user to enter the full name of student so that it can display a form that have the details of the student. I would like an error message to...
  8. K

    To insert a bound object frame(picture) for each record to be stored in table

    I didn't realise what I was looking for is right there staring in front of me. Thanks Col... :p What I had in mind is actually a command button that the user can click to insert the picture instead of right-clicking in the OLE object box (like what is shown in the Northwind database). I...
  9. K

    To insert a bound object frame(picture) for each record to be stored in table

    Hello guys... I hope some of you guys can help me with this problem. (My first language is not ENglish, so here goes....) I'm trying to insert a picture for each employee to be stored in an Employees table from a form. What I want to do is for the user of this database to insert a picture...
Back
Top Bottom