Form to maintain only Inventory

[manoj9849967222]

Hi

I hope you could help me out.

I was actually trying to maintain my inventory in access.
i want to maintain material in & out so that at month end i can generate a report & also see what are the stocks left out with me. This would be better if there is a userfriendly form so that i can enter in the form & the materail gets added in the Table.

I dont know from where to start & how to start please suggest.

hopping your early response..

Regards
Manoj

[abolos]

Hi

I hope you could help me out.

I was actually trying to maintain my inventory in access.
i want to maintain material in & out so that at month end i can generate a report & also see what are the stocks left out with me. This would be better if there is a userfriendly form so that i can enter in the form & the materail gets added in the Table.

I dont know from where to start & how to start please suggest.

hopping your early response..

Regards
Manoj

Hi Manoj,

It is fine to use Access for this purpose. First you have to create a table and put fields in it.

1- Open your database
2- Under Objects go to tables
3- Click on New button
4- Choose Design view
5- In the Field Name put the fields you want to be in your database. For example: ProductName, ProductCode, ProductPrice. Try not to put spaces in the name of the fileds. You may start each word with capital letter.
6- In the Data Type assign the type of the field
7- Then go to forms and create a new form based on that table

For any other help, don't hesitate to ask,
Abolos

[manoj9849967222]

Hi Abolos

Thanks for your response

I have created a Table with Name "Inventory Master"
and the fields are Itemcode --- Number
Itemname--- Text
Rate-----------currency

Now i want to design a form in such a way that when ever there is a Stock inward my table gets updated, when i enter in the form.

Regards
Manoj

[missinglinq]

Abolos has been kind enough to get you started by pointing you in the right direction, but please understand that this forum is designed to help out programmers who run into difficulty with their projects. The members who answer questions here are volunteers. Please do not ask them to design your database for you as they get paid to do that as professionals.

If you wish to have a database designed please post in the jobs forum and our experts will be happy to submit bids on the project.

Jobs Forum: http://www.thescripts.com/forum/forum214.html

Linq ;0)>

Moderator

[abolos]

Hi Abolos

Thanks for your response

I have created a Table with Name "Inventory Master"
and the fields are Itemcode --- Number
Itemname--- Text
Rate-----------currency

Now i want to design a form in such a way that when ever there is a Stock inward my table gets updated, when i enter in the form.

Regards
Manoj

Just one other hint for Manoj missinglinq.... ......... thanks.

Go now to Forms and create a form for this table using a wizard, this is the easiest way for you now.

Abolos

[missinglinq]

Absolutely, Abolos!

Linq ;0)>