Search results

Hello mates. As subject says I have a very detailed and complex access 2007 application with full of codes, queries etc. Normal convert fails for such an application and if I start to do it again in 2003 it will take a lot of time. So is there a way which I can convert my 2007 database to 2003...

I know this is very simple for most of you but it came to a nightmare for me! I have a query gets the total ordered quantity from "Orders" Table and another query gets the total received quantity from "Incoming" table. I just want to make a pie chart which shows what have been received and what...

As subject says, I have a vba code including 2 recordsets getting information from different tables and compare with each other. When I dont split the database it works perfect but when I run the code after splitting, values don't come up correctly. What can be the reason for this and how to fix it?

What I am trying to do is material allocation. There are structures.Each structure needs different types of material to be fabricated. This info is in a table as below. Structure ID--Material Code--Required Qty--Status ST1 -------------MAT2---------- 3----...

This can be quite simple for you guys but I am confused and cant find how to do this. I have 1 table and 1 query as below Table has 2 fields, category elements and status column. Status can be "FULL" or "NONE" Query is a select query to GROUP BY table 1 category elements and has second field as...

I have 1 table and 1 query. Table shows required materials to fabricate structures. Query shows the material quantity in inventory. Table: Structure ID --Required Material Code--Required Quantity ---Status str1 ------------------Mat1----------------------3 str1...

If I use special effects on each text-box (I have plenty of them in plenty of forms) will it affect speed?

OK this will really drive me crazy. I have a main form with a 4 combo box 2 text box and a sub form which is from a select query.Select query should bring info based on any of these combo or text boxes.I write in the criteria of the query [Forms]![SearchF]![RecHeat] and similar to this to the...

Hello guys. I need some professional help. I have a material stock program and I am trying to improve it. In my database there are line id's and each line id has required materials.Lets say Line No 5210D consist of 3 pieces of x,7 pieces of y and 2 pieces of z materials.If I have all these in...

Hello mates.I have a material management database.In one table there are received materials with their quantities and locations. And I have a form which should filled for a material request to be deducted from stock. On this form there is a little sweet listbox on the top. When user select the...

Hi fellows, I am working on a material management system. There is a table which only includes material codes and descriptions as a primary key and there is another table for data entries connected to the material list table with one-to-many relation ship. On data entry table users are importing...

What is the best way to save data from one temporary table to the main table? An append query? An sql statement in vba code? by recordset? saverecord macro? or anything else I forgot to mention here. By "best way" I mean performance and timing considering you have thousands of data to save at...

I am trying to make a material management system. Basically It consists of -Material Receipt (Material Code,Received Quantity, Stored Location) and -Material Issued( Material Code, Issued Quantity, Issued Location) . I have a form for the user to enter receipt material and another form to...