Recent content by dz2k7

I see Thanks guys

Yes i copied and paisted results in Excel. But if i already did what i wanted, why it asks? How i can make it No by default?

I'm dealing with large Access tables. So every time I close queries Access asks stupid questions if I want to put results in clipboard. If I hit yes by mistake Access gets frozen and it takes forever to be able to do something with it or use clipboard for copying with other programs. Sometimes...

Lots of good stuff. But still no HD50

yes, because it's popular product and all branches stock it.

Each branch deal with items only. If they want to stock it - they mark it StockYes. They might not know about PGSG at all. Purchasing is using PGSG do determine how to buy different groups of items.

Regarding normalization. Each branch have different set of products. That happened because i picked only items that branches decided to stock. Each branch desides that independantly. But they take data from the same productfile. Product file determins item and PGSG just once. So to that...

Yes that's correct

you're right. Our system never been normalized. But we can't change that. We just download what is there and crunch numbers as good as we can. Ok WXP is a branch name (I picked 3 branches only WXP, WXQ and WXY WX part is a division name The system is partually normalizad within each division...

I Uploaded the DB. Temp.mdb Product group HD50 is missing and i tried to make parameter 10 for this PGSG in all branches.

Main Branch, PGSG, Product Parameters Branch, PGSG, Parameter Query SELECT Main.Branch, Main.PGSG, Main.Product, Parameters.Parameter FROM Main INNER JOIN [Parameters] ON (Main.PGSG = Parameters.PGSG) AND (Main.Branch = Parameters.Branch);

Does not work with table Join though. :(

I got the concept! I put Like (IIf([Forms]![form1]![Branch]="~*","*",[Forms]![form1]![Branch])) And it works when i put * in a form. Thanks a lot, I guess i'll figure out how to treet those tables in a beginning.

I'll give you another example. Let's say I have a form where I specify a branch I'm looking at. So I have a query where critreia for the branch is like [forms]![form1]![Branch] Now Let's say I want to see data for all branches not changing anything in queries. I only want to enter...

I can't do that as a criteria. I need it in adjustment table as data entered.