Recent content by leedub

  1. L

    Summing Columns to populate a form

    Thnaks for you help i was able to figure is out
  2. L

    Summing Columns to populate a form

    Sorry i dont think i was clear enough. I have the subform on my main form with the correct data. But when I view the main form in form view. The subform display the data in a table. I was wondering if there is way so that the subform displays the data in a form.
  3. L

    Summing Columns to populate a form

    Thanks! I figured if out. Ok so now i have this table that displays all my associated records to each Entity ID. It displays it in a table. Is there any way to display in form view?
  4. L

    Summing Columns to populate a form

    Sum Data im a Columns to populate a textbox on a form Hello Im working in Access 2007. So i have query based on 1 table that populates a Form. The primary key for that table is Entity ID. Therefore once the query has been run I have multiple records that i can scroll through in my form...
  5. L

    Query Criteria Help

    Sorry but yes the other post is the same problem that i am trying to fix. It might be easy to talk in the other post because it supplies more information about my problem. But to answer your questions. The check boxes are on a form, and if both are check i want it to filter so that it shows...
  6. L

    Query Criteria Help

    Im working in MS access 2007. What im trying to do is fairly simple i just dont have the ability to correctly code what i want to do. I want to filter my query based on some criteria in multiple columns. But i only want the query to filter based on the specific criteria if a checkbox has...
  7. L

    If statements to set parameters in a QUERY

    Thanks so much that works great! Unfortunately my goal has changed slightly. I need multiple check boxes to filter the query. So ill have Check0 - if selected filter query so that "Tranche" = 1 Check2 - if selected filter query so that "Tranche" = 2 Check3 - if selected filter query so that...
  8. L

    If statements to set parameters in a QUERY

    Im open to doing this in the query as well if that's easier than the VBA.
  9. L

    If statements to set parameters in a QUERY

    If and ELSE statements in a QUERY Hello im working in MS Access 2007. Ok so what im trying to do is have a query run specific parameters if a check box is selected. So if the check box is selected than the query filters the "Tranche" column so that the only records that shown are records that...
  10. L

    Locking Comboboxes using VBA

    thanks for your help. Works great
  11. L

    Locking Comboboxes using VBA

    Alright i have changed that now but it Still allows me to select from combobox 2 and 3 before i have selected from combobox 1. This is what my code looks like now Private Sub Form_Current() If IsNull(Me!areabox2) Then Me!devbox2.Locked = True Me!entitybox2.Locked = True Else...
  12. L

    Locking Comboboxes using VBA

    Hello Im working in MS Access 2007. I have 3 combo boxes on a form. My goal is simple I would like the 2nd and 3rd comboboxes to be locked unless the user has already chosen selected an item from the 1rst combo box. The code im trying to get working now is in a On_Current event so that when...
  13. L

    Triple cascading combo boxes

    thanks that works perfect
  14. L

    Triple cascading combo boxes

    I dont know what that looks like or what concatenate means?? Could write that line to show me what that looks like?
  15. L

    Triple cascading combo boxes

    Both text are fields. So i have change the WHERE line slightly but now nothing is populating the entitybox2 is my punctuation correct? Private Sub areabox2_AfterUpdate() devbox2.RowSource = "Select DISTINCT [Budget Info].Development " & _ "FROM [Budget Info] " & _ "WHERE [Budget...
Back
Top Bottom