Discussion Locked

MS Access 97

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Im new to Access and Im setting up our inventory using the "Inventory template". I would like to view "Stock on Hand" but in datasheet view not in a report. Can someone explain to me how I do this?
Thanks

4 replies

by zot

I must assume that you are using one of the "canned" databases creatible by Access which has a switchboard, pre-built tables, queries, and so on, and you basically give it your name and address and it builds a bug-free db for you to start entering info; Access 2000 has one called "Inventory Control." I remember doing this with Access' "Address Book" db, and getting a little lost in the process; reason being, the wizard creates so much stuff for you it is a bit overwhelming, and definately not as user-friendly as a rookie might like. Anyway, when you open the database, the switchboard will probably pop up trying to force a selection; ignor that for the moment, and look in the lower left corner at the minimized window which has a name like"database: inventory control" or something similar, which is the normal first window you would get if the switchboard didn't jump out first, and click the double box sizer. The window that will open will have some bars on the left for tables, queries, forms, reports, etc. Click on tables, and then look throuh the list. Chances are, there will be one called "products," and if you click it, you might see what you're looking for. It sounds like you just want to back-check your entires quickly,and this will give you a start.

by zharia

I am using the template for the inventory but try as I might I cannot view stock on hand in any datasheet view. I have to keep going to "reports" to do this.

This discussion is closed to new replies.