Search results

Thanks Josef, I shall give that a try. Also thanks to everyone else who helpfully posted It seems amazing to me that something so basic should be so hard. Oh well, I guess that's in MS's DNA

Can anyone help? I have spent a lot of time trying to do this. I can use the Docmd.TransferSpreadsheet (my preferred choice) but 1. I do not know how to specify a named range rather than an Excel Worksheet 2. I do not know how to specify "IMX=0" to counter the "recent" change due to legal...

Thanks DBGuy, No, I have set up the ingredients to have 1 UoM each, and only 1. I'm guessing I make the Recipe Line table column Ingredient_ID a "Lookup" tyype column which references the Ingredients table where RecipeLine_Ingredient_ID = Ingredients.IngreientsID something like that?

I am trying to create a small database system that will produce a week's shopping list for food. I have a recipes table, then a Recipe_Lines table, then an Ingredients table and finally a Unit of Measurements table. I have a form to "Add a Recipe". The control source for this form is the...

Hi TheDBGuy, Thanks for your response;) Most odd..now that I check it again, the properties are there as you say. Oh dear, can't explain it. But thanks anyway!

I have a form that I use to allow users to Add/Amend/Delete accounts (Chart of Accounts). I have inserted a listbox on the right of the input fields so that as an account is added/updated the user can see the effect on the whole table. So far so good. However, as the user adds accounts, the...