Search results

Our database is split, and my shortcut has been working just fine for years (going through the program to the .mde and on through the workgroup). But since installing a new hard drive this weekend, the shortcut is broken. The names of all of the files and the drives and etc. are identical to...

Our db is ready for use, replacing the former dBase system. There are only two of us in the office - I am the db developer and the GM will use it to update records and print reports. This is easily accomplished from the Switchboard (so he doesn't ever need to see anything else). The db...

I can bring in the ingredient weight from the main form and add it to the container weight inside the subreport. But I get a #Name? error when I try to use the calculated cost of raw materials from my main form to add to the container cost within my subreport (which brings in the three or four...

I have a report showing the ingredients in each finished product with associated costs, weight, etc. Now I need to bring in the containers -each finished product has from one to four container possibilities. Everything I've tried (subreports, queries, etc.) lists every single container, either...

My database contains a table of many recipes, each recipe belongs to one specific category. I also have a table of many different containers, all (but one) of which is specific to a recipe category (which links the two tables). My query is currently designed to show containers based on each...

Our recipes are entered in terms of what percent each ingredient contributes to the finished product. This percentage is part of the data entry of individual ingredients which takes place on the subform. The total percent is being calculated on the footer, and is visible on the main form...

I'm sure this is going to be obvious, but right now I am stumped. I am also very new to Access and learning as I go. I am calculating a field on the subform, then using 'sum=' to adding them together on the subform footer. But the result ends up being the total of all of the subforms, not just...

I am working on a db for a chemical manufacturing business. We primarily want to be able to determine the cost of each recipe, and determine which finished products contain any given raw material (so that when there is a price increase, we can determine which products will be affected). We...