Shifter
Last Activity: Sep 6 '06, 12:36 AM
Joined: Sep 1 '06
Location: Melbourne, Australia
-
I seem to have solved this problem by creating a public function in a module that simply returns the value of the combobox, and using this function in the query instead of directly referencing the combo box itself. Thanks for your help PEB. -
Oh wait! i forgot to mention that queryB also references the combo box. In fact queryB IS the first half of queryA (as in, if you remove the union and the bit after that in queryA, that's queryB).
And i personally don't think that regenerating the query every time the combobox value is changed to hard code the value of the combo box into it is very good. Firstly that defeats the purpose of that part of the query being a dynamic parameter....Leave a comment:
-
Never said you weren't disagreeing with me, in fact more the opposite. I was happy that you backed me up actually. and presented it in a different way....Leave a comment:
-
I think that's what I said, just in a more coded fashion. Yay!Leave a comment:
-
If anyone wants to correct me on the above idea, add to it, or tell me that it won't work for whatever reason please do.Leave a comment:
-
Yes query A, when run by itself, runs perfectly. As does query B. query C (the cross tab query) works perfectly when it references a table that has the same stuff as queryA.
query A was originally used to make the table the query C originally referred to, but i wanted to turn it into a query, instead of a table that constantly needed updating.
Thanks for the quick response by the way :)Leave a comment:
-
I have an alternative idea (it might sound complex, but really it doesn't seem that hard inm y mind. mind you I haven't tried this myself, but it might be worth a shot to try out):
Make the combo-boxes multi value combo's. As in for the Region combobox have 2 columns, one for a number and the other for the text that the user sees in the combo (in the properties for the combo set the width for the value column to 0 so the user doesnt...Leave a comment:
-
Invalid field or expression problem
I'm having issues with Access. I've not used it much before now so don't really know much about it, but i have used SQL and VB before.
I have a union query (which ill call qryA) that references a combo box on a form in one of the where clauses. It also references another query (which i'll call qryB) that also references the same combo box. These both work fine.
However my problem is that I have a third crosstab query...
No activity results to display
Leave a comment: