Recent content by ELiedeker

That fixed me up!! Thanks so much! I'm so much more comfortable with SQL than Access... that never occurred to me. I appreciate your help.

Also, there's no syntax error in the second query if I substitute "Update Supplies SET InStock =" with "select". I get the calculated value back no problem.

Thanks so much for the sql. The first query gives me the "updateable query" error, and the second one gives me "Syntax error (missing operator)". I've been getting these errors over and over with every iteration of this query I try (which has been every way of writing it I can think of). At...

Holy cow, you're right. I didn't constrain the outer query.🤦‍♀️ Regarding your other comment, I plan to perform this update upon closing an Order Form. I don't want to update inventory until I'm sure they're done ordering. So, I'm keeping track of whether orders are pending or complete, and...

Hi, I have a relatively simple query I'm trying to run to update inventory with the sum of existing inventory, plus new items ordered. But I'm getting an error that my query isn't updateable, and I'm not sure what's wrong with it. In Oracle, you can update a column with the results of a...

Honestly, too, that form alone has done so much for me. It used to take me hours to come up with the week's menu. Now I have a place to keep track of dishes I want to try, and it's just a memory jog for stuff everyone likes that we didn't just eat last week. I tend to get in a rut.

Yes, so this form is just where I choose the menu for the week. Once I have the menu, I go to the first form "*Take Inventory for Meals" and it shows me what ingredients I need to make sure I have, with a way to add them to my shopping list (kludgy - again, my Access skills... I'd like a better...

I just realized you're not seeing what I'm seeing, because the meals are also filtered using the date at the top of the form. So if you put in today's date, you'll see what I had entered for this week (if I entered before zipping). Or you could use an earlier date. To clarify, the search...

I'm an experienced programmer, but not terribly experienced with Access forms, so I'm not surprised if I'm doing things in an unorthodox way! And this is where I really appreciate help from you all not to shoot myself in the foot. The subform at the top is actually a search tool, so choosing...

Appreciate all your other thoughts and tips as well, Mike. Have a good one!

Geez. I'm embarrassed. The Recipes combobox on the subform of the search control at the top was bound to Recipes.ID. Thanks so much for all of your help. I really feel like an idiot. Learning... I greatly appreciate everyone's time and feedback.

So, in fact I've now figured out the moment when the Recipes.[Recipe Name] is getting overwritten. It's when I select a recipe from the Recipes list inside the subform SF_RecipeSearch embedded at the top of the form. The primary key of the recipe I select overwrites the [recipe name] of the...

I think I set it up as a multipick originally, and had to go in and define the field that way. Then when I redefined the form to only allow single pick, I forgot to redefine the table.

Yes, it looks like it's still designed to accept multiple values. I'm not sure if I like that feature or not. It's very bizarre database design, for me. But hey, getting to know the Access world. What do you think?

I started out using a multipick combo box somewhere, and ended up removing it because I didn't like the way it worked.. I thought I had removed all the data associated with that, but it sounds like that's what's happening in veganSub. Oof. Don't look at SupplyOrder. That's still a playground.