Search results

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

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

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

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

Hello everyone, I have a small database application which is split in fe and be. Its running fine and i have been making changes to the front end regularly and replacing the file on server successfully with no problems, But today i edited some forms and reports and afterwards i ran it on a...

Hi everyone, I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is...

Hi all, I am using master/child form for data entry for packings and the details for this packings (i.e. the products inside a packing is entered in subform and packing master is entered in main form ). In the detail subform i use a productId field which has look up from 1000 products , so i...

Hello everyone, I have a form with subform (datasheet) . On my subform i have one field which shows the productId ( which is filtered from combo boxes on main form) . productId contains two columns 1 bound column(id) ( hidden with width 0 ) 2 column (desription) ( shown with width 2 ) Now...

Hello everyone, I have created a form with subform on it having one to many relation . I have created a save button on main form and edited the before update property of main form to require the click on save button to update the record. But when i enter the fields on form and click inside...

Hello everyone, I just want to know how to manage items in set and individual item. suppose my product list are individual items = A,B,C,D,E,F,G,H,I,J,K and 5 pc set = A,B,C,D,F and 3 pc set = G,H,K how should i design the table . previously i designed the table for individual items and...

hello everyone , i have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance . Kindly see the attached image thanksss

hello, i need to design a query in which order shortage is calculated with respect to fifo method for orders . attached is the logic . i need help to create it . and if i need to incorporate more than 10 orders , what is the best method for this ??? thankssssss

hello all, i have a production database in which i have different sections processing on the same product. i have a daily production entry form on which datewise entry is done for each section. i want to maintain the total stock of each section (sectionB) with productName, input from sectionA...

Hello everyone , i want to update a field of the table from a field of query . this is the syntax : UPDATE tbl_PresentStockAll INNER JOIN qry_BroachStock ON tbl_PresentStockAll.ProductId = qry_BroachStock.ProductId SET tbl_PresentStockAll.Broach = [qry_BroachStock].[BalanceQuantity]; and...

Hello everyone , i have made a production database application in which table structure looks like this .... (see attachment) every section stock is maintained with a query and i need to sum the total stock from each section which is not possible with that number of queries . do i need to...

hello everyone, i have a production database application in which there are many sections. every section's product stock is generated by running a complex query. now when i want to add the result from different sections into a one combined stock , i could not design the query as it become too...

hello everyone, i want to create a summary report from multiple queries. what are the best possible methods for this ???? should i need to use subreport function or anything else?? thanksssss

hello everyone, i have a production application in which i have a table named daily_production with fields as ( prod_id, date, productname, qty ). now i want a daily production query as date : xx-xx-xxxx productname | qty | monthlysum(for thsi product) | daily average | i want this on a...

hello everyone , i have created an access application for production system . i have a final stock query and 2 to 3 orders based on priority and i want to create a shortage list based on priority ... here is detail : ItemName....|Stock qty....|ORDER1....|ORDER2....|ORDER3....|...

Hello everyone, i have a report in which a column is there which contains numeric as well text data .. i just want to add only numeric data from that column .... what expression do i need for this ??? i want to define a function in data field of a control which shows the sum .... thankssssss