Search results

OK In retrospect I can see how this was naive of me. I wanted the user to select a school within my university, then be able to select multiple time frames. I went into the query and tried to add [forms]![QS Report 5: Proposal Details]![Rep5SelectSchool] in the criteria and it didn't work...

Snueberg, Thank you so very much! I so appreciate this. This works. I've never wanted to hug a stranger so much as I do now. Question: If I were to add another button to run a report based off this query how would the code change? That's the eventual goal.

I just dummed the database down. It still seems to be too big so i put it in google drive here

the db is huge and is work related. I am going to copy, paste and delete all proprietary information. one sec. thank you for your help!

Go to the VBA Code Window Open the Immediate Window Ctrl + G Erase anything in the window Go back to the Object Window Shift F7 Run the code, don't worry about the error just click end program Switch to the VBA Code Window Copy the results of the Immediate Window and post them so we can see them...

thank you very much to the people helping me!

my favorite color is purple

I am using Windows 7

Access 2013

For step 7 there was nothing in the immediate window: I can't even post a pic here because the site won't let me.

I'm afraid I do not know what this means.

OK I apologize if I seem like an idiot but I'm just not understanding this. I used the code as listed above and YAY didn't get the error but got all the fields i needed in my query but the parameters (as listed in the form) weren't met. I put back qdf.SQL = strSQL and the error returned.

I: -Added the brackets as suggested -edited the code per the suggestions and it is now: Private Sub Command56_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String Set db = CurrentDb() Set qdf =...

Thank you! but I still get the 3075 Error Syntax error (missing operator) in query expression '[z_Basis_QSReport5_Proposal Details].FY WHERE z_Basis_QSReport4_Proposal Details.CriteriaFY IN('FY15-Q1','FY15-Q2','FY15-Q3')'.

I have a search form in Access 2010 that filters FYs and Quarters based on certain criteria and opens them in a query. One of the criteria is an unbound multi-select list box, SelectTime (Where a person selects "FY15-Q1 and FY15 Q2, for example. The data are stored in a query...