Search results

  1. D

    Difficulty in Table Design.

    Dear, I am trying to build database for Module Information. Each Module shall be protected by one or more protective devices. protective devices are BMr, EMPR, FUSE. Some protective device may require CT. For this purpose I have made tables of below: Module Info BMR CT EMPR FUSE...
  2. D

    Difficulty in Table Design.

    Dear All, New to Access. I have 6 tables and I am trying to build database. Main target is Module Info Table. My basic Idea is when user inputs data in module information form, which I would create later. A combo box to select device type. Depending on the device type for example: If...
  3. D

    Requery not working in a form with combo boxes

    Yes...It worked after pasting the code...Thank You very much...Can you please explain why we require this code and why afterupdate code alone is not sufficient??
  4. D

    Requery not working in a form with combo boxes

    Private Sub cbo_Area_ID_AfterUpdate() Me.cbo_Main_Area_ID.Requery Me.cbo_SWGR_ID.Requery End Sub Private Sub cbo_Main_Area_ID_AfterUpdate() Me.cbo_Area_ID.Requery Me.cbo_SWGR_ID.Requery End Sub Private Sub cbo_SWGR_ID_AfterUpdate() Me.cbo_Area_ID.Requery Me.cbo_Main_Area_ID.Requery End Sub...
  5. D

    Requery not working in a form with combo boxes

    Dear All, New to access...just build a form, in which there are combo boxes....cascading of boxes was done with your help. Now the problem is I want afterupdate function to get activated when user changes the value of one combo....for which I have created a code in code builder...please see...
  6. D

    Parameter not getting passed from combo box to a query

    Yes, I have made change in query to look for ID....It worked. I am thankful to all of you.
  7. D

    Parameter not getting passed from combo box to a query

    If I open the query and give criterion as "ADPH" the query is giving output...I have tested the query. Even though I have given name of the area not ID, it is not getting passed into query. My question/doubt may be very basic in nature...please help me and guide me to accomplish this task.
  8. D

    Parameter not getting passed from combo box to a query

    Dear All, I am new to access. I have created a form in which I used a combo to show Main Area Name. this value is passed into a query to show only area under main area only. Created another combo to activate the query to show the area. Somehow it is not working...I am unable to find...
  9. D

    Introducing Self

    Name : drspanda INDIA. beginner for access.
Back
Top Bottom