Concatenate Related Help

[DerekDaNoob]

Im using Alllen Browne Concatenate related module.

I have had it working previous i and just a little stuck on this one

Here is my code i am trying to use
Code:
Me.IngredientList = "INGEDIENT LIST:" & ConcatRelated("[Meal - SumOfIngredientsQ]![IngredientName]", " [Meal - SumOfIngredientsQ]", " [Meal - SumOfIngredientsQ]![MealID] = """ & [MealID] & """")
Any ideas

 

[JHB]

You don't tell what problem you've:
If MealID is text:

 "[Meal - SumOfIngredientsQ]![MealID] = [B][COLOR=Red]'[/COLOR][/B]" & [MealID] & [B][COLOR=Red]"'"[/COLOR][/B])

If Number:

 "[Meal - SumOfIngredientsQ]![MealID] = [B][COLOR=Red][/COLOR][/B]" & [MealID][B][COLOR=Red][/COLOR][/B])

 

[DerekDaNoob]

Thanks for the reply

Sorry about that, the error i am getting is
"Error 3062: Too few parameters Expected 2."

MealID is a number

 

[JHB]

Could you post your database with some sample data?
Else show the code in "ConcatRelated" + some data.
When number then you need to use:

 "[Meal - SumOfIngredientsQ]![MealID] = " & [MealID])

 

[DerekDaNoob]

Yeah i can do that. So i am self taught and it is a bit messy atm the layout isn't done yet. If you have any advice ill take it.

https://drive.google.com/open?id=0B8u34fdGgNH_dHJydXdhUTlVUFU

 

[JHB]

Can you post the database here, I don't have an account at Google.
Scroll a little down when you do a replay, then you'll see a button, "Manage Attachment".

 

[Gasman]

Yeah i can do that. So i am self taught and it is a bit messy atm the layout isn't done yet. If you have any advice ill take it.

https://drive.google.com/open?id=0B8u34fdGgNH_dHJydXdhUTlVUFU

I tried to have a look as I have used the function in one of my databases, but get the attached error.

Also your DB is way to large to post as it is.

JHB has also given you the syntax for a number criteria

 

[JHB]

..
Also your DB is way to large to post as it is.

Maybe if you zip it.

 

[DerekDaNoob]

I cannot compress the file under the 2 Mb limit for the forum attachment

I have compressed it and place it on File dropper

http://www.filedropper.com/freshflavoursdatabase

I am using Access 2007 - 2016

 

[Gasman]

I cannot compress the file under the 2 Mb limit for the forum attachment

I have compressed it and place it on File dropper

http://www.filedropper.com/freshflavoursdatabase

I am using Access 2007 - 2016

Wow I'm impressed. 23Mb down to 2.2 by zipping.
I still get the same error though.
Have you tried JHB's solution?

 

[JHB]

You've wrong reference to the form in your queries, some is [form]![mealf]![Mealid], but correct is: [Forms]![mealf]![Mealid]
Then you don't follow the advices you get, (maybe you know better as we do)
You've "[Meal - SumOfIngredientsQ]![MealID] = "" & [MealID] & """ that is wrong.
Correct is still: "[Meal - SumOfIngredientsQ]![MealID] = " & [MealID]
But all in all it doesn't help you, then the overall problem is that you've querie(s) with references to a form and you try to use it together with a recordset, you can't do that.
I've made a workaround for you that works.

Only for information, if you do a "Compact & Repair" to the database, it reduce size, so you could have posted direct in the forum as I've done.

 

[DerekDaNoob]

Thank you JHB for your help. i had sent you an older copy, i did try

"[Meal - SumOfIngredientsQ]![MealID] = " & [MealID]

and many other ways

I will take all the advice i can get. (it was also after 2am sorry if i didnt make any sense )

Thank for for letting me know about

Only for information, if you do a "Compact & Repair" to the database, it reduce size, so you could have posted direct in the forum as I've done.

I had no idea

I am very grateful i have been stuck on this issue for a while.