Search results

Sorry it doesn't recognize Forms!FormName!Combobox

Tried all but didn't work. How come select query doesn't recognize Forms!FormName!FieldName ??

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

Gemma thanks for your reply. I don't have any problem with importing excel. It imports data to a temporary table and from table user can save data to the main table with query. Till this point every thing is okay. The problem is while importing the data from excel.If there is a new material...

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

Well making table was also a real headache for me. My table is more complicated than I explained here. There are too many columns to be in one table. I am working in a field engineering business so there are so many things to be entered both when receiving the materials and issuing them...

Well the transfer form will consist of 3 parameters that user should input. From_Store (Store for materials to be taken), To_Store (New location), Transfer quantity. As I have 2 tables for material receipt and issued,I will try an append query or an insert into statement in vba code to put...

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