Search results

Yea i noticed that, thanks again!

:eek: Ok so you created a query from Physical Properties, then used the Query as the source for the crosstab, instead of the table. The txtbox provides the search criteria for the regular query, which provides the results which are then put in crosstab format. freakin genious. Thanks...

Wait...how...hmmm...er....Ok im lost. You created a regular query... qryPhysProperties4CrossTab But i see no reference to this query anywhere in the form And when i click the button on the form to run the search, it is running the query i created which magically works now... So what is...

Copy of the dummy DB in exactly the same setup as i have it is located here http://josephknight.net/access/dummyDB.mdb

So after getting more into it, even though it is a solution it's simply not an acceptable one. I realized after typing in all the column headings, i also have to type in all the column headings that show up in the crosstab portion of the query (not just the ones in the query design view) and...

Evidentally it is one of those "It only needs to be done in this one specific case" type of things... All my other queries run perfect without declaring parameters or column headings. Thanks for all insight by both posters!

No actually if i remove the parameters i simply get the jet database engine error. I don't have to declare parameters in standard queries, but for some reason crosstab queries require it. Found a solution, it's annoying but it works. As found in that article: Specify column headings Since...

From what i gather it is not a subform, im using the wrong terminology. I have 5 forms, i use one form to open up the other forms. But they are all at top level.. I guess a subform is a whole diff type of form altogether in access. Like i said this is first time ive created a form menu etc

This is the query the first button on the form "Ticket Number" and the parameter filled in This one works perfectly as does every other query setup the same way...its only crosstab that fails. You may wish to read this. http://allenbrowne.com/bug-13.html

ok...i remove the parameter and i get this.... Not that im trying to tell you your wrong, but the other 3 queries are setup the same way, and none of them prompt me for input when run from the form. Only the crosstab query does...

Ok here goes! Here is the queries and forms The query is setup like this With or without the second "[form]" appears to be irrelevant as your stated. This is copy and paste what is written in the criteria minus the like "*" & parts This is my menu When i click any of the 3 buttons...

When im in my query design view. I right click on the box where you type in the criteria and you get a bunch of options. The last 3 i have are "Build, Zoom, Properties". Build takes me into an expression builder. I navigate to forms, where i have frmMain, frmLookupStrNumber, frmOthers, i click...

Ok that makes sense, i will try to add the main form in the criteria and parameter box under query. I was building the expressions using the access build function and it never put the main form in the criteria box...so i never thought to use it. This is my first attempt at making this whole...

I want to run it from the open form without the parameter box popping up before the form opens. I want to include screenshots but my company is ridiculously worried about corporate espionage and all the image hosting sites are blocked. This works perfect on standard queries (non crosstab...

None of my queries work if i take the parameters out....Unless im doing something totally wrong. If i take out the parameter, and leave in your criteria i get this error. "The Microsoft Jet Database Engine does not recognize "[Forms]![frmLookupStrNumber].[form]![txtLookupStrNumber]" as a...

CORRECTION, it does the same thing mine did. For some reason it added an extra column at the end of my query which was a duplicate of the first column and had one of the criteria statements in it. I corrected it I added your criteria, i added your criteria as a parameter under the query...

If i remove the parameter entry and put in what you said Like "*" & [Forms]![frmLookupStrNumber].form![txtLookupStrNumber] & "*" I get the same error "microsoft jet database engine does not recognize etc etc" If i add what you typed as the parameter like i did with the criteria the...

I made the sub form unbound, no record source. I added this: Private Sub Form_Open(Cancel As Integer) [frmLookupStrNumber].SourceObject = "[qryPhysicalPropertiesCrosstabByStrNumber]" End Sub It broke...with error: Standard Queries can't find the field '|' referred to in your expression...

Before i try your solution i wanted to paste the code currently in there that access created. This is on the main form when i created a button to open the sub form. All access created code un modified Private Sub btnOpenLookupstrNumberFrm_Click() On Error GoTo...

Ill create a brand new form right now and give you an account of how it goes and record my steps, ill edit this post when im done. :Steps: I create a new blank form in design view (a subform to the main) I right click the form and set the form source to the crosstab query I create a textbox...