Search results for query: *

I am straight but, I could kiss you! That is it! And opened up a lot of other options to me now. Thank you so much!

One problem I foresee. If I use multiple sub-reports it will keep asking the user to enter the same criteria 8 times for a total of 16 dialog boxes. Is there some way to have it ask just once and pass that info to all subreports?

Whoops! the code I posted in the previous post was not the correct code. Here it is: =Format([Enter the last day of the month],"mmmm yyyy") I used the same variable as in the queries so the user only had to enter it once.

Actually I just learned about subreports early this morning trying to look up some more information on my problem. I don't know anything about them much currently and don't have my DB on hand to look it up in the help file. I am guessing it is something like subforms so that there is some...

Agreed. I too have come to this conclusion but since I don't understand where I am going to post it and hope someone can see something I cannot. The record source for the report is one massive query that I was hoping would combine 9 queries into one. I will post the control source query...

Heh after reading what I posted again I realized how vague my subject is, unfortunately I cannot change it so I apologize for my ambiguity.

I have a monthly report that uses the data from several queries to calculate the data used on the report. Those several queries are all added into one query, which is the actual record source for the report. When the report runs it asks the users to enter the beginning date of the month and...

Thank you. I actually noticed that a little after I posted it along with the "WHERE" that should not have been there. Perhaps you might know if tblCases.CaseNum LIKE '*06-0002*' is an appropriate filter sytax because I think that is my problem. I don't get any errors now but it is not...

I am using Access 2002. I have an unbound main form and a bound subform in it. (I mean the main form contains multiple unbound controls, but the subform has a recordsource and has bound controls.) Main Form: frmSearchIt Sub-Form: sbfBrowse What I have been trying to do is take the values...

Thanks JerryKlmns, currently I have no numeric fields and I have formated the dates accordingly. Now I have a new problem it seems. When I hit the search button I get an error saying I cant assign a value to this object, which it shows as the line "Me.sbfBrowse.Form.Filter=Mid(strWhere,7)"...

Thank you for the extremely fast response. The problem is I am getting a Run-time error message, "You can't assign a value to this object." Below is the select query I use as the record source: SELECT tblCasesMain.*, IIf([CaseStatus]<>"OpenThis","") AS OpenThis FROM tblCasesMain ORDER BY...

I have been trying to do this for over a week and I just can't make it work. I have an unbound form that users enter searchable criteria into. Behind that form I have VB code to grab all that info and construct it into a query. I have another form which I want to display the results. I have...

Thank you, I am sorry for my naivety. I got an error, Can't reference a property or method for a control unless the control has the focus. Although it seemed to work fine before, the string it created didn't take information from any blank field, most of which are text, except 4 date controls...

Please bear with me I am new to this. As such, I think I didn't properly call the resulting fields, which crashed Access. I created a form for results prior to any of this, called sbfBrowse with the controls I would like to display for the user to click on. Having said that I was hoping you...

Wow that was incredibly fast response. Thank you. I forgot to say some things. The code I used to generate the SQL string is a button that I would also like to open and populate the subform using the string it created. From what I understand of the code you wrote I would have to open the...

I have a unbound form I am creating to do searches on multiple fields in multiple tables. I have the SQL string stored in a string variable called: strSQL Problem is I don't know how the steps to make that string actually open a form with the results of the query. I also have a record set...

No problem. Didn't do it the first time because I wasn't sure if it was appropriate. Private Sub btnSearch_Click() Dim dbf As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim strWhere As String strSQL = "SELECT tblCases.CaseNum, tblCases.OldCaseNum, tblNames.FirstName...

I am new to Access, VB, and SQL so bear with me a little. When I run the below code it keeps giving me a syntax error, saying I am missing an operator between tblNames.TIN Where Company="Somecompany" Before that error I had an error with having too many characters at the end of SQL statement...