Search results

  1. N

    Matching values of fields with the data in the table

    Run-time error 3075 syntax error in string in query expression 'userName='peter' Peter is a user name already created
  2. N

    Matching values of fields with the data in the table

    thanks for reply i have corrected the code but still error, the code which is corrected is below If DLookup("UserName", "tblListOfUsers", "UserName = '" & Forms![loginpageForm]!User) & "'" And DLookup("Password", "tblListOfUsers", "Password = '" & Forms![loginpageForm]!passworduser) & "'" Then
  3. N

    Matching values of fields with the data in the table

    Dear colleagues hope you all are doing well, i have created a login form and create user page form, the tblListofUsers has two columns, UserName and Password, on the log in form when a user enters username and password, it should be matched with the tbllistofusers if true then msgbox"Welcome"...
  4. N

    Adding multiple check boxes in a form

    oh great tnx for your valuable answer it is resolved thank you
  5. N

    Adding multiple check boxes in a form

    Yes i have given all the fields same to same as i have seen your example, here is the error Private Sub Form_Current() CurrentDb.Execute "UPDATE tblVehicle SET CheckedVehicles = False " If Not Me.NewRecord Then CurrentDb.Execute "UPDATE tblVehicle INNER JOIN tblStudentVehicle ON...
  6. N

    Adding multiple check boxes in a form

    Really thanks for valuable response, but i have designed an example so that i do the same with my original database, it gives error i couldn't debug my error, please help me sort it out, attached please find the sample i designed and tell me my errors Regards
  7. N

    Adding multiple check boxes in a form

    i started to design my database as per the one you sent me but i came across some functions you used in that check boxes like after check box update, and on current event of the form, can you please elaborate those functions as i couldn't understand regards
  8. N

    Adding multiple check boxes in a form

    thanks for your great job, but when i started to use this method (the database you sent me) i found some vb coding that i couldn't understand, if it is possible please send me commented coding so that i could understand... Regards
  9. N

    adding a multi-valued field in a form

    thank you so much for your detailed explanation, one of the member of this forum sent me a database example showing how to add multiple check boxes in form, but there were to function i couldn't understand if it is possible help understand that database, attached please find the example
  10. N

    adding a multi-valued field in a form

    Great job thanks for the reply, but i want these hobbies to be in the form of check boxes, assume i have a user friendly form having these data studentName Student hobbies (a group of hobbies in form of check boxes) student training attended ( a group of trainings in form of check boxes the...
  11. N

    adding a multi-valued field in a form

    really thanks for your reply, i couldn't figure it out, can u plz give me a simple practical example, i mean plz send that db example regards
  12. N

    adding a multi-valued field in a form

    Dear friends, i really thank you all for your continous support, i have question, hope i receive a favorable answer how to add a multi valued fields in a form for example a student may have multipe hoppies, access can do this using using lookup option, but access stores multiple values in one...
  13. N

    i want each continous form instance to be independent

    i didn't understand this point ( Then rather than updating the checkboxes by referring to the control name, you update the value stored in the record and requery the form.) as i mentioned before all these three check boxes i am talking about are bound
  14. N

    i want each continous form instance to be independent

    Following is the code for NoCase check box, if it is chekced the two other checkboxes and combo boxes are disabled otherwise they are enabled, Private Sub NoCase_AfterUpdate() If Me.NoCase.Value = True Then Me.Followup.Enabled = False Me.TypeOfCase1.Enabled = False Me.NewCase.Enabled = False...
  15. N

    i want each continous form instance to be independent

    No my all check boxes are bound to different fields in the table, please see the snap shot
  16. N

    i want each continous form instance to be independent

    Dear colleagues, please help me out, i want continuous form so that i can know what my prvious record is, but this gives me trouble i have some check boxes that based on some conditions they disable some fields, but when i do this on the first record, the same happens in coming forms for data...
  17. N

    Coping a field values from form header to the form

    i have form named home page in this homepage form in the form header i have inserted some fields from some tables like province, district, community etc. these fields are unbound and are used for filtering purposes, when i select a province all districts related to that province displayed and...
  18. N

    Adding multiple check boxes in a form

    Oh... sorry for the inconveniance.... please find the attached
  19. N

    Adding multiple check boxes in a form

    thanks alot for responding my posts
  20. N

    Adding multiple check boxes in a form

    please see the snap shots attached in this post
Back
Top Bottom