Search results

But I am not trying to find only availability. After it checks the quantity, stock should be reduced visually to recalculate next same items availability in a correct way.

Well I tried removing WP.MoveFirst as well but when I remove it strangely nothing is working. But you are right. For sure this is related to cycling. Something I am doing wrong there.

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 is it.Thanks, appreciated.

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

Done perfectly by recordsets. It checks every row as per the quantity and fills status.

You are %100 right. This is far away complex than I manage to achieve at the moment. In your example; str1 needs 2 mat2 str2 needs 5 mat2 If I have 2 mat 2 in the stock, status should be full for str1 and none for str2 If I have 6 mat 2 in the stock, status should be full for str1 and partial...

Yess!!! Done!! Thanks alot!!

Well I removed the field from the table and put an unbound textbox on the form. I wrote =IIf([Forms]![StructureT]![BOMF].[Form]![SumOfRequired]<[Forms]![StructureT]![BOMF].[Form]![Stock_Qty],"full","none") to the control source. The problem is now, it only checks where the cursor is and apply...

I am trying to make an update query which compares the total required qty with stock qty but every time I am getting the "operation must use an updateable query" message

Ok. Can you explain more detailed? How I can do that?

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?

Thanks a lot for the advices. I am planning to migrate to a SQL server as it seems more reliable.Never tried before so no idea how hard it will be but as I read from many forums it will work far better under network.

Corruption can't be because of any network issue because database is still under development and I never used it under network.Probably there is something happening on the back ground which we can't know and access is trying to be smart and guess the location but comes up with a enter parameter...

It is not a split database. But once I finish I am planning to split it and put tables in the network for faster use by users. -What may cause this corruption?Is there a way to understand and fix it? -How can I guarantee that it will not appear again for users?

I import everything to a new access database and there everything works properly.This is getting more and more interesting. But this temporary solution does not quarantiee that an annoying "Enter a parameter" box will not appear after some time....

And again it happened.Now I will write you one by one to explain the problem clearly. 1)I made a blank form with 5 combobox and a tab control with 6 pages on it 2)I made 6 select queries. In each query there are 5 criteria in "or" sections based on these comboboxes...

I checked so many times. This is not about typing.I deleted my main form, sub form and query. I will do all from the beginning!

I am using 2007