Search results

Thnaks for you help i was able to figure is out

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.

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?

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

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

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

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

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

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

thanks for your help. Works great

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

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

thanks that works perfect

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

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

Working in MS Access 2007. Hello, So Im creating a small database for a budget and Im trying to create 3 cascading combo boxes on a form (areabox2 , devbox2, entitybox2) . I have it right now so that that devbox2 is based on areabox2 and entitybox2 is based on devbox2 BUT!!!!!!! I want...

i just figured it out thanks anyone who was thinking about it

Ok so im working in MS Access 2007. I want to create a query based on 3 combo boxes but have it so that if the field in the second or third combo box is not populated the query still runs. Right now i have the Criteria set for the three columns that i wish to sort by as seen below. Column...