Stuck at MS Access

[richardplr]

Hi, I am a very new MS Access learner and I am writing some Purchasing and Inventory Program and I was stuck somewhere.

I actually wanted to attached here for your opinion but I don't know why cannot and keep on saying that my file is too big. I have checked the size, it is only 45 KB.

Nevertheless, let me tell you my problem.

A) I have prepare 3 main form and 2 report.
1) Purchase Contract Form and with sub form
2) Stock Requisition Form and with sub form
3) Delivery Details with Sub form.
4) Print Purchase Contract
5) Print Stock Requsition Form

B) I need to program all the 3 form that it can find record. Example when I type product code 123 and if the system have the record, then it will show all record otherwise, the system will pop msg saying record not found.

I think so far that all. I hope all of you can help me.

Thank you.

Regards,
Richard Tan

 

[richardplr]

Purchase Cum Inventory Program

Hi, I have mangement to zip into small bytes.

Pls see attached my program. Pls guide me.

Tks

 

[neileg]

It's not clear exactly what you want. If you want to get user input for the product code, either use a parameter query, or use a combo box. A combo box will not allow a code that doesn't exist in the data, so that would be my choice.

I notice that not all items have a product code, and that you appear to be using suppliers code for this. This means that not all products will be included in a search, and you cannot be certain that these codes are unique. Bear this in mind.

Many, many people want to build a purchasing and inventory program as their first database. This is actually a difficult application to program. You should be aware that Access has a wizard to build an inventory application. Also, this topic is a regular on this forum, and you should do a search for posts on this.

Looking at your database, you are falling into the classic trap of holding stock in hand as a field in your product table. You need to calculate the stock you have, not store it in a table. See the numerous posts on this.

I also don't see why you have supplier name in twice in your product table.