kirschey
Last Activity: Jul 21 '09, 09:49 PM
Joined: Apr 8 '09
Location:
-
I now get, "Invalid use of New keyword" -
Multi-select list box query
I have read the other posts on this subject, but I am still having issues.
I have a few combo, and one multiselect list box for States delimiting. I am trying to feed a query based on this info. I have it working as a combo box, but now I am getting "type mismatch" and "object variable or with block variable not set" errors.
Help would be much appreciated in the "listbox" commented section... -
I commented out
and am now getting a type mismatch. Any ideas why?Code:'Query Parameters qdf.Parameters("Region") = Me.Territory qdf.Parameters("State") = Me.State qdf.Parameters("Brand") = Me.BrandLeave a comment:
-
It is ugly. I am sorry.
This is the query "output."
...Code:SELECT [zz Profit and Loss Flow Final].[Year-Month], Sum([zz Profit and Loss Flow Final].[Cases Shipped]) AS [Cases Shipped], Sum([zz Profit and Loss Flow Final].[Cases Depl]) AS [Cases Depl], Sum([zz Profit and Loss Flow Final].[Cases Depl Budget]) AS [Cases Depl Budget], Sum([zz Profit and Loss Flow Final].[Gross Profit]) AS [Gross Profit], Sum([zz Profit
Leave a comment:
-
I am still getting the error. Maybe it is from another part?Leave a comment:
-
[QUOTE=ADezii;34 79511]
Thanks for the help. I still don't get how I would adapt my form inputs into the For loop. Would I use an array?Code:'Resolve the Parameters For Each prm In qdf.Parameters prm.Value = Eval(prm.Name) Next
Leave a comment:
-
Create RecordSet from Form Parameters
I am trying to use a form data to modify a query and store it as a recordset.
I have it working properly just opening the query, but I cannot seem to get the QueryDef parameters working the way I would like. (The Me.Territory,Me .State, and Me.Brand is the form data).
I get the error "Item not found in this collection." Currently.
The code that doesn't work:
...Code:'create the recordset
No activity results to display
Leave a comment: