Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by aaabuhalime

  1. aaabuhalime

    Double Click Error

    Hi every one , I have created two forms , form1 and form 2, form 1 consist of two fields to enter FName, and LName, and ok button, the ok button when clicked open the form2, form two consist of alist of records, and two button one to add contact and an other button to stop/cancel, the code I am...
  2. aaabuhalime

    double click error.

    Any Feedback on this please??
  3. aaabuhalime

    double click error.

    Hi every one , I have created two forms , form1 and form 2, form 1 consist of two fields to enter FName, and LName, and ok button, the ok button when clicked open the form2, form two consist of alist of records, and two button one to add contact and an other button to stop/cancel, the code I...
  4. aaabuhalime

    Viewing duplicate entry .

    I am getting Compiler Syntax Error, I think this is enough, I am might add city in thier as well, plz help on why I am geeting the syntax Error. it highlights the Select Statment.
  5. aaabuhalime

    Viewing duplicate entry .

    Dear PHV, Thanks for your reply, I tried this code below , I can get the system msg , but I can not view the the existing matching record, what I want to do is to have an other option "view" beside the yes and No, so the user can click on it to view the existing matching record, then decide...
  6. aaabuhalime

    Viewing duplicate entry .

    Hi I have the following code that enables me to prevent any duplicate entry,I would like to add an other button beside the yes and No, I want to add the option to view the existing record, how can I do this , so the user can determine wether to add or to cancel, I tried the second code for some...
  7. aaabuhalime

    Prevent Data Entry Duplicates

    Thank you Andy for your reply, I tried the following code I added Me.Undo in Casevbno, I noticed when I added the code when I go to form view the form doesn't open , I have to close the db then reopen it then the form opens, I tried to go to go to the design view, then back to the form viw the...
  8. aaabuhalime

    Prevent Data Entry Duplicates

    Dear PHV, Thank you very much for help, I am using the follwing code it is working perfectly, I am trying to change few things, now once I enter a name that alrady exists I get the duplication message, and does not let me add the name, what I need to change or add is to be able to add the name...
  9. aaabuhalime

    Prevent Data Entry Duplicates

    Thank you worked :)
  10. aaabuhalime

    Prevent Data Entry Duplicates

    Hi, I have a data entry form to add new customers, I have two filds in the form First Name, and Last name field, I am rying to prevent any duplicate entries, I am using the code below to prevent any duplicate entries for both names, it seems I am missing somthing , I have placed the code in the...
  11. aaabuhalime

    How can I reset a field in access form

    When you "reopen it again", aren't you looking at an existing record in your form's record source? No Apparently this record has a value in the field that you are seeing.Yes the value I selected. What is the control source of the combo box? contro source of that combobox is "Who" filed in...
  12. aaabuhalime

    How can I reset a field in access form

    Dear dhookm, Thanks for asking, here is the scenario, when I open a blank form, if I select Student, then close the form and reopen it again I still see "Student in that field, what I want is every time when I open the form for new entry I want the field "Who" to be blank . I hope it is clear...
  13. aaabuhalime

    How can I reset a field in access form

    I agree with dhookom, the control has to be bound, because if I unbound the control I get an error.
  14. aaabuhalime

    How can I reset a field in access form

    I want the user when ever they open the form to see it blank, because what happens if they forget to change the selection, the selection from a previous entry will remain there it will mess the record.
  15. aaabuhalime

    How can I reset a field in access form

    Dear Duane, Thank you for your reply, I am sorry for not being more detailed, I have created abound form, I have a field called "Who"in the form, the Who field (combo box)holds the following values "Teacher, Student, Principle", when I open the form and selects "Student " for example, when I...
See more

Part and Inventory Search

Back
Top