Search results

Thanks but we cannot use logic based on productId's because the product ids might be any text based or numeric based. It was just filled for understanding purpose. Moreover the Raw Products and final products are mapped in many to many manner. Means there might be 2 or more rawproducts which...

Its Order1RawStock and Order1FinalShortage.

As the total order quantity is 20 for A13 the shortage will be 20 coz we have 0 pcs left in stock. A12 shortage will be 15 . It wouldn't add up coz we need to make 15 for A12 and 20 for A13.

Yes. Please guide me.

Its one to one . Its not actual raw material its raw product i.e. semi-finished product . For example . In a manufacturing process which consists of many processes until final product is made. In that early processed parts can be used in 2 or more final products . But mapping will be one on...

Its not as simple as that. How would you map the raw products with final products and fetch the stock accordingly????

The Shortage is calculated in two levels. Actually the Raw product can be used to create 2 or more different final products. So we need to calculate the use of raw product based on priority i.e. if the raw product A1 once used in A11 , the quantity available for A12 will be less . In this...

Please find attached file for relations.

I have created this imaginary data to show my point. As the existing structure is too big to display everything. Tell me what structure you need i will send that. Do you need relationships between product tables & stock tables?

Hello Everyone, I have a production database in which orders are checked for shortages at different levels of production in which : 1 raw product can be fetched in 2 or more final products, Shortages are checked as per priority. Please see attached image for illustration. In this database i...

that was great . I forgot a week ago i changed the language settings thats why it happened. Many Thanks :)

Hello Everyone, I have a data entry form which have a date field. This field retains the existing date after the record is saved with vba after update event. Private Sub Form_AfterUpdate() Me.ProductionDate.DefaultValue = Chr(35) & Me.ProductionDate.Value & Chr(35) End Sub Almost after a...

Can anyone help me to achieve the required query mentioned above ???? Thanks

Thanks for reply. Actually I need to prioritize the orders . I can calculate easily by totaling the orders and getting the total order shortage. And there is no such issue of seeing all the information at one screen. I need to issue the required quantity order-wise (priority-wise) . single...

Thanks . But can you take a look at attachment and suggest me how should i go for it??? thanks.....

Hello everyone, Till now i just know some query designing and some amount of VBA for making small event procedures. I want to know how we can use VBA when our queries becomes complex to replace the queries and to extend the functionality. I don't know what ado,dao, or how to use recordsets in a...

Thanks Brother. Yes i can see as my query takes more values and added that up the quantity becomes 34800 which is more than 32767. thats why it gives #NUM! error and so "overflow". I changed it to long int and its working like a charms. Thanks guys.

Thanks a lot it worked . But could you please tell me the reason. I have checked the table design and there is a field size (long integer) . Was this the reason ???? And why this error didn't occur before???? Thanks a lot.

Hello everyone, I have a query in which i use Nz function to convert null to 0 . But further i need this value in another query as a number so I use it as CInt(Nz(Sum([QtyReceived]),0)) group by expression Is it correct.???? Upto some point it worked well and still working in many queries...

Yes I do want to use error handling, But i feel it too complicated and as i am very basic at programming i find it difficult. Actually i will try your link i need to learn it . Now i have done some modifications for this time untill the solution is found. I have used existing application and...