Search results

  1. ELiedeker

    Solved Update as select not updateable

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

    Solved first description repeatedly replaced with primary key

    Hi, I have a continuous form, Menu Planner, where you can plan weekly meals. It contains MealDate, MealName, Recipe, and Other Supply. Other than MealDate, which is simply a date field, the other fields are comboboxes referencing primary key-description pairs from various tables. The form stores...
  3. ELiedeker

    Solved Subform Parameters not found from Main Form

    Hi all, I have a subform containing a text field (SearchTerm), a checkbox (IsVegan), and an option box (Breakfast/Lunch/Dinner). I reference these controls in the query source of a combobox on the same subform to filter a list of Recipes. It works great as a stand-alone form. However, I pasted...
  4. ELiedeker

    Selecting unbound checkbox in detail section modifies all checkboxes

    Hello! My first question. I haven't found the answer elsewhere. I have a form with an unbound checkbox in the detail section of the form. Its purpose is to check off a supply on an order form as fulfilled. There is no corresponding field in the database. When selected, I update the database to...
  5. ELiedeker

    Finally joining the forum

    Hello! I'm a retired programmer with background mostly in client/server PC/Unix, Oracle programming. I had some experience with Access as a programmer in a limited fashion when I used it to create a front end reporting tool with some canned reports to show emergency room data imported from...
Top Bottom