Very Computer

This maybe a simple problem but it has me stumped..!

Single user  ver 5.0

I noticed today that my inventory is lacking 18 part numbers. When I look for them in the Inventory form they all come up missing.
If I go to the stock table it shows 72 part numbers by count but only 54 are visible. When I do a query on the stock table all the
part numbers come up including the missing 18. If I run a filter in the inventory form they come up. But if I do normal "locate value"
lookups they will not come up and I have been going crazy trying to figure it out.  This will eventually cost me a bundle in sales
if I don't know what I have in stock..

I have tried checking all the possible filters, I thought about using the Priv Answer to the query and adding them back to the
stock table but I'm not sure what consequences will arise from doing that. I tried to post them back into the stock table but I
get the usual Key violation because they already exist.

Bottom line is the 18 part numbers are hidden from view in the stock table and inaccessible to view under normal circumstances
 in the form. They can not be reloaded and can only be accessed by round about means....This is not going to cut it.

What did I do wrong to make this happen?

How can it be fixed?

I would really appreciate it if some one could help me out with this one..

Thanks.

says...

Quote:> This maybe a simple problem but it has me stumped..!

> Single user  ver 5.0

> I noticed today that my inventory is lacking 18 part numbers. When I look for them in the Inventory form they all come up missing.
> If I go to the stock table it shows 72 part numbers by count but only 54 are visible. When I do a query on the stock table all the
> part numbers come up including the missing 18. If I run a filter in the inventory form they come up. But if I do normal "locate value"
> lookups they will not come up and I have been going crazy trying to figure it out.  This will eventually cost me a bundle in sales
> if I don't know what I have in stock..

Quote:

> I have tried checking all the possible filters, I thought about using the Priv Answer to the query and adding them back to the
> stock table but I'm not sure what consequences will arise from doing that. I tried to post them back into the stock table but I
> get the usual Key violation because they already exist.

> Bottom line is the 18 part numbers are hidden from view in the stock table and inaccessible to view under normal circumstances
>  in the form. They can not be reloaded and can only be accessed by round about means....This is not going to cut it.

> What did I do wrong to make this happen?

> How can it be fixed?

> I would really appreciate it if some one could help me out with this one..

> Thanks.

I would make a copy of the table, and then try dorking with it (deleting
indices, repairing, etc.) until it goes away.

good luck,

Scott
--

http://students.cs.byu.edu/~wiersdor
"For every complex problem, there is
a solution that is simple, neat, and
wrong." -- H. L. Mencken