Search results for query: *

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...

Any Feedback on this please??

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...

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.

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...

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...

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...

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...

Thank you worked :)

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...

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...

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...

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

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.

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...

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...

Thank you All.

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...

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...

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 -->...