Search results

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.

I keep telling myself one of these days I'm going to remove all those spaces and all the references to them. Yes, I bound the combo to the primary key Recipe.ID, but in the format properties for the control, Column Count is 2, Column Widths is 0";2". So it displays the recipe names rather than...

Hm. You're right. This makes no sense to me, but it appears to be the search tool at the top causing the problem (but it should all be read only??) You can see the problem below, where breakfast tacos became "86". It didn't occur when I chose menu items for subsequent days down below. It...

I'm a little confused about the suggestion. I'm using all these booleans to help with searching for recipes (which is the major reason I created the database). A given recipe can fall into multiple of these categories, they are not mutually exclusive. A recipe may be flagged as both a salad and...

This is probably not obvious, since this database only makes sense to me, but those fields all describe the type of recipe, and I use them when searching recipes. For example, I don't want to see oatmeal when I'm searching for dinner recipes or fajitas when I'm searching breakfast recipes. Do...

ugh. It gives me the option to save as 2002-2003, but apparently I have some incompatible functionality.