Search results

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...

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...

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...

Hi, I'm have a macro that creates a folder with the date as the name, then runs all my queries and places the results in this folder. What i'm trying to do is to check when the macro is run if the folder already exists, if it does then delete the folder and run the macro again. Problem i'm...