Recent content by Priyan

Great idea! But how can i fill a table with all these information efficiently? Do you mean with record set? How to handle it in multiuser environment? I thought of expanding the width of the body. And then user can do a vertical scroll.

Hi husky I tried to build a query too. Actually on my qryLayout I have all the record numbers that I need to place on the form. I only need to link the qryLayout with tblProdPlan_Woche. But the thing is the qryLayout has 18 fields with the record numbers. Only way I know to get the record...

Hi everyone I assume you are able to see the pictures. What I’m trying to do here is like MS outlook like grid. The grid shows 6 days per week vertically and the machines are on top. Per day for a machine you have three place holders consists of 12 textboxes. 12 textboxes x 3 Positions x 6...

Hi guys Thank you for your time I know I’m doing something wrong here, but I don’t know what. Form in design view: ://db.tt/hWFtmHKB Form in form view: ://db.tt/41qu6Tue copy of DB in ZIP: ://db.tt/XXy8gqP7 Since I don’t have 10 posts yet I cant post...

Hi Yonnel Thank you for the reply. Actually the query “qryWocheDetailBereich“ is not complex at all, I mean no calculations. I use it to filter records belonging to the period form the table “tblProdPlan_Woche”. The table is in the same db not remote. Each textboxes in the continuous form has a...

Dear experts I’m bit stuck here. hours and hours of research in web didn’t help me. The code I wrote to fill text boxes in an access form works but its very slow. It’s really nice if someone can advice me how to optimize the code. The frmWochenPaln_Main is a bound, continuous form to the...

Hello everyone I was able to find the solution on my own. I’ll post the VBA coding here. It might come in handy. Functions of the code: 1. It picks the value of Combo box in a form 2. With the SQL statement the records in tblAnlagen will be filtered by the value found in previous combo box...

Hi Guys Thank you for the quick responce. Ok i'll change the Labels to text boxes. And i also got this SQL filter the records by section. Could someone tell me how to writhe the records in the recordset one by one to the text boxes. regards Priyanga Sub FillWorkCenter() Dim...

Hello everyone * I got this situation and it would be nice if someone can advice me how to proceed. * In the tblMachines I’ve got 4 fields Section********** MachineNumber***** MachineName********* MachineCapacity G5****************** 1254A* * * * * * * * * * * * * *...