Search results

  1. P

    Why Combo box default value returns 0 in form

    Thanks for file. Unfortunately, did not work. When u open a form for new record through another form, default values are still 0 and -1
  2. P

    Why Combo box default value returns 0 in form

    Can you please send me your modified file. I would like to learn from you what you did to make it work. Thanks
  3. P

    Why Combo box default value returns 0 in form

    The problem is there not only for yes/no, when options are normal,abnormal and not known, default value is shown as 0. When I directly open form, there is no problem, default values are displyed exactly like what I put in table design. But when I open the form through another form, default...
  4. P

    Why Combo box default value returns 0 in form

    Did not work. I am still new in programming. I will be grateful if you could try and see if it works. Thanks
  5. P

    Why Combo box default value returns 0 in form

    Thanks. The problem happens while data entry. If I directly open this form and go to new record, that (your screenshot) is what I see. But I need to start entering data from first form "demography" form, because this form has the identifier information for the clients. Once log in successful, it...
  6. P

    Why Combo box default value returns 0 in form

    I am posting the db. I have a log in form. On log in, it opens demography form. I click "add record" button, and enter new cleint ID and name etc. I save it and click "enter data for this client". It opens another form (History-frm) for this client, where default values are 0 and -1. The default...
  7. P

    Why Combo box default value returns 0 in form

    I tried and it did not work.
  8. P

    Why Combo box default value returns 0 in form

    I have a Database design in which there are 4 forms linked to and updating a single table. In table I have set many fields as combo box with value list, and default value (Text), for example Yes and No with defalut value as Yes, Normal and Abnormal with default value as Normal etc. When I try...
  9. P

    Can not update table

    In that case, Can I still use all those forms separately to update the single table? Can I use multiple forms to update the same table, without making subforms?
  10. P

    Can not update table

    My form is for data collection and I need to update as well as add new data from time to time. Therefore, I have a main form where there is client information and subforms with the different details of the same client. Subforms are linked with the main form (parent child). I have a serch form as...
  11. P

    Can not update table

    My form is for data collection and I need to update as well as add new data from time to time. Therefore, I have a main form where there is client information and subforms with the different details of the same client. Subforms are linked with the main form (parent child). I have a serch form as...
  12. P

    Can not update table

    I have a main form and 5 subforms all based on single table. When I enter a new record in the main form, it says locked by another user. I am the only user. I can not add a new record to the table using main form or subform. I am new to access.please help. My form is for data collection and I...
  13. P

    code for finding record in a form

    Thanks for code. I have a form (Sform) in which there are Searchbox (Sbox) and Searchlist (Slist). When I search for a name it shows list of matching names. Until this step I was able to accomplish. Now I want a code by which if I click (or double click) a name of my interest listed in the...
  14. P

    code for finding record in a form

    Hello, I am novice to access. I have a form and few subforms as tabbed pages in the main form. I have a separate page as search page that consists of searchbox and searchlist. When I type a name in searchbox, there is listing of matched names in listbox. Now I want to click one of the names in...
  15. P

    problem in tabbed pages

    I tried that and it did not work
  16. P

    problem in tabbed pages

    I am still novice to access. I have a form and few subforms as tabbed pages. In form view, when I move through the tabbed pages, the tab headings disappear behind the header of main form, and I have to move the page up to see the headings so as to click next tab. I want the tab headings to...
  17. P

    Not able to find records using search box

    Hello, I am novice to Acess. I have many forms linked to single table. SInce dataset fields are many, I created one form and kept rest of the forms as subforms in tabbed pages of the main form. Data in all forms are linked to the same single table. I have thousands of data in the table. I am...
  18. P

    Making a field invisible after checkbox

    I have a form with check box (Chk1) and a subsequent field (txtbox1). Field should be visible only if check box is checked. I put a code at afterupdate event of chkbox. Now on form load the checkbox is unchecked but the field is still visible. It becomes invisible only when I check it and again...
  19. P

    Solved Disabling subsequent fields and keeping default values depending upon combo selection

    Thanks Pat. It worked. I was able to write code for second situation as well. Thanks again. Can we change row source of second combo box depending upon value chosen in first combo box using this "select case" or "If, Else IF" codes? For example if first combo selects option A, second combo...
  20. P

    Solved Disabling subsequent fields and keeping default values depending upon combo selection

    Can you please write after update codes for me please?
Top Bottom