HELP HELP HELP HELP! 
Author Message
 HELP HELP HELP HELP!

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.



Sat, 01 Apr 2000 03:00:00 GMT
 HELP HELP HELP HELP!


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

Repair the table. It's probably corrupt. A corrupt index is the most
likely reason.
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.



Sun, 02 Apr 2000 03:00:00 GMT
 HELP HELP HELP HELP!

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

> 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've had something like this happen to me, but it was because a table
got corrupted when a user shut the machine off mid-action.

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



Wed, 05 Apr 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. help help help help help help help help help

3. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

4. SQL To ORACLE Help Help Help Help Help

5. query:HELP! HELP HELP HELP HELP

6. Help help help help

7. HELP HELP HELP HELP

8. HELP HELP HELP HELP ... VB4(16) -> VB4(32)

9. HELP HELP HELP

10. Refresh Test Environment help help help

11. backup HELP HELP HELP

12. HELP HELP HELP!!!!


 
Powered by phpBB® Forum Software