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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aaabuhalime

    Double Click Error

    ...Dim strSQL As String Page10.SetFocus strSQL = "select ContactID,LName, FName, City from qryContacts where LName like ""*" & Forms!form1!txtLName & "*"" and FName like ""*" & Forms!form1!txtFName & "*""" List13.RowSource = strSQL If List13.ListCount > 0 Then...
  2. aaabuhalime

    double click error.

    Any Feedback on this please??
  3. aaabuhalime

    double click error.

    ...Dim strSQL As String Page10.SetFocus strSQL = "select ContactID,LName, FName, City from qryContacts where LName like ""*" & Forms!form1!txtLName & "*"" and FName like ""*" & Forms!form1!txtFName & "*""" List13.RowSource = strSQL If List13.ListCount > 0 Then...
  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...
  16. aaabuhalime

    How can I reset a field in access form

    Hi All, I want to ask how can I reset a field in access form , I have created a bound form,I have afield that I want to reset every time I open the form , that form hold few values, when I close the form and reopen it I still see the value of the field as is (the value of my last selection),I...
  17. aaabuhalime

    YES/NO field appears as -1,0

    Thank you All.
  18. aaabuhalime

    YES/NO field appears as -1,0

    Hi All, I have a form that YES/NO field the field dispalyed as hold a checkbox on the form which really what I want , the problem is when I print the a report, the values displayed as 0,-1, is there a wy a validation rule that I use to be get rid of the 0,-1, I want the Yes and No to be...
  19. aaabuhalime

    Disable fields based on compound condition

    Thank you all for your helpful suggestions, here what I have been doing for some reason it is not working, here is the scenario that I am trying to achieve, I want to check if there is a value entered in Wt1 field for that student, WhoIsIt is a student, if yes then Wt1 field get disabledPrivate...
  20. aaabuhalime

    Disable control/field once if a value already exists

    Hi all, This question is based on my questions in the past threads, I want to see how can I do the following, I want to be able to disable the "Wt1" filed in my form once a value entered in this field/ value exists for that student, so I want to continue using the following criteria, CODE -->...

Part and Inventory Search

Back
Top