Search results

I tried everything and the sub report doesn't filter like the main report. the sub report shows all records

oh thats ok...one more quick question. How would I add the sub report to also filter in the same code...rptComparisionSheetSubReport DoCmd.OpenReport "rptComparisionSheettest", acViewPreview, , "pkDisciplineID=" & Me.Combo20, acNormal

that makes sense and that did it! thanks so much !!

the immediate window says : NULL

Ok i changed the quote and I still got the syntax error (missing operator).... Private Sub Combo20_AfterUpdate() DoCmd.OpenReport "rptComparisionSheet", acViewPreview, , "pkDisciplineID=" & Me.cboDiscipline, acNormal End Sub

thanks so much. I got all the way to the code part and it is telling me that there is a snytax error (misisng operator). I put the code in the after update event. Not sure what is happening, should the code go somewhere else?. Thank you for your help Private Sub Combo20_AfterUpdate()...

you are the most helpful & knowledgeable person I have come across on this forum. You helped me a few months back with a db. I am wondering if you can help with vba code that will change criteria in a query qryComparisionSheet by discipline then open rptComparisionSheet when it is selected from...

:confused: I am wondering if you can get help with vba code that will change criteria in a query qryComparisionSheet by discipline then open rptComparisionSheet when it is selected from a drop down menu...let me know if i make sense.. thank u in advance a sample db is attached password LOCK

This is what I inputted but I'm not sure what my SQL string would be...?? I highlighted that part in red below Private Sub cboDiscipline_AfterUpdate() Dim mySQLWork As String Dim mySQLSub As String 'create a query based on the discipline combo box to filter the required work list mySQLWork...

yes you are correct the data won't show unless the data is in all the tables. Do you have a link for the where condition I am not following you. I am an amaeter access user. Thanks

My query works fine it just didnt have any quotes in the db. I have added some numbers for your review. Also i cannot use the report filter for two reason one because I have a sub report in the rptComparisionSheet so it does not read correctly unless the criteria is changed for each discpline...

my fault its "LOCK" all caps

I have attached a sample db. What I am trying to do is create code that will change the criteria in the qrycomparisionsheet for each of the 121 disciples in the tblDisciplines. The reason this needs to happen is that I need to have reports for each discipline rptComparisionSheet. A drop down...

Thank you!

Is there a way to create a query that will put the winning bid next to the competition bid for side by side comparision? I have attached a sample db for reference. the qry with the information that i need to compare is qryWinningBidReport

In the query design view, I would put that in the field row?

Im using the shortcut option to export in 2007. thank you

When I export a query into excel the yes/no fields that I have read as true /false instead of yes/no. Is it possible to get to read yes/no after being exported into excel? Also when I export currency into excel it goes out to two decimals places even tho the default setting in acces is at 0...

i don't know what you did but you are genius! thanks so much

I was able to get an unique index as you recommended but when I try to go back into the form it stops me. Thank you so much for your help. I will try to figure out a code to stop this from happening.