Recent content by jimmy1981

Hi, Sorry what I meant was to add the total to the report. I created a query which seems to do the trick. Thanks again for your help.

It's basically just a home-use database to be able to log all recipes and see what it costs to make them. I have replicated your database and added some recipes, I have also created a report that shows all the recipes but i'd like to be able to add how much it costs to make, how would I go...

OK, this is harder than I expected, I'll have a try out with what you've told me and see what I can do. Looks like maybe Excel would be an easier option though.

Ah OK, I think I see how that's working. Is there any way then of in the RecipeProducts table, there is the ProdID field, can this show the name of the product rather than the ID? And on the form, you have the total at the bottom, can this value be written to a table or is this back to the...

That's exactly it, that's great. I've tried looking at your forms and I can't figure how you do it? How does it populate the text box with the price, and why does it update the information if I change the cost of an ingredient whereas mine never would?

So would this mean I wouldn't hold the Unit_Price on the form either, instead I'd pull this in to a query somehow?

how would you suggest I do it properly then? i.e not storing calculated values. complete access newbie so stupidly thought it would work like excel.

Hi, Sorry. My combobox has the following values and is bound to Column1. SELECT Ingredients.IngredientID, Ingredients.Ingredient, Ingredients.Unit_Price FROM Ingredients; The user selects the ComboBox and is presented with a dropdown of all the Ingredients from the Ingredients table. When...

Hi, I have a table of Ingredients and a table of Recipes. When I add a recipe I select an ingredient from a ComboBox which then populates a textbox using: [Text19] = [Combo10].[Column](2) This then returns the unitprice of the ingredient. The problem I'm having is if the Ingredient's price...

Thanks Guus, works a treat.

I have the following code to try and calculate a total amount from a table: Dim LTotal As Currency LTotal = DSum("Total_Price", "Recipe_Ingredients", RecipeId) Forms![Recipes1]![Text45] = LTotal Yet when it runs it appears to be calculating the total of all the table rather than for a...

I imagine this is because the changes are happening in the subform and then just writing it to the unbound textbox

still nothing happens.

I have the Text29 control source as =[RecipesSubform].[Form]![txttotalsub] I then went in to my Text29 beforeupdate and put the following: Text39 = Text29 (Text29 is my total textbox and Text39 is my empty textbox that I wish to show the same as Text39). Nothing happens, it's as though the...

Hi, I imagine this is unbelievably simple but I just can't find a solution from searching dozens of posts. I have a subform which has a textbox in the footer which calculates a total amount. On my main form I have a textbox with the control source set to the textbox on my subform. What i want...