Recent content by jua_kali

Sorry for the late reply you sure are correct about the time difference not helping. I will try to explain what I am doing by giving examples hopefully that helps :) I have a list of finished products with fields as follows: No. Desc Form Dia Length 1 abc F1 2 5 2...

In short what I am trying to do is that when I run the query using the code using DoCmd OpenQuery I get the key violation error message. I understand this would be because query attempts to append or update records that contain primary key values that already exist in the destination table. But...

I understand what you are saying in terms of the keys but my database setup is slightly different. I will explain below: I do not have a lookup list for raw materials because what I have is that each raw material has an excel file. What I mean by that is that the data from the query of each raw...

Yes you are right cogent1. One raw material is present in many finished products and adding one finished product entails updating many raw material queries. So how can you update all the queries from the form? Please explain cause I dont understand how. Thanks.

Hi I am trying to run append queries that update tables. How can I code this in the simplest way possible. To briefly explain my problem, I am working on a Bill Of Materials: 1) I have a table where I have a list of items for eg FinishedItem. 2) I have created queries for raw materials and...

I have a query in SQL which works fine ie. lists the query results (just the way I want it) without any pop up dialog box when I run it without saving it. After I save and close it and run the query, it brings up a dialog box that prompts you for the parameter value (criteria). Why is this...