MS Access and VB.NET creating forms
So i need a little direction to create a form with in VB.net to access a ms access database. Could someone point me in a simple way to doing this? What about making it so that it calculates inventory? If someone already has something in mind in creating a database with inventory items and to take it out with a account number and the qty used, that would be great. Would also like to create reports!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is there a program with source code already done around? Would Microsoft have it in Vb .net express 2005?
ASKER
Here is more information that maybe needed to keep this simple:
Thursday, July 6, 2006
10:45 AM
Project Name: Inventory Control
Presenter: Steve Payne
Description
The purpose of this Inventory Control is to keep track of the inventory for Cesar A. Caceres, MD PC.
Project Goals
The Project goals are as follows:
Medical Supplies Form
Enter item
Set order level
View inventory levels
Ability to manually adjust inventory levels
Usage Log Sub Form
Track When Items taken with Account number
Qty and by whom
Inventory reorder report
Shows all items at or below reorder level
Generate a report for items that need to be ordered
Requirements/Resources
Visual Basic .Net
Ms Access DB or SQL
Current Status
working
Related Documents
Documentation will be included in the code
Little documentation for how it works will be done afterwards.
Copyright © 2006 Steve Payne
Thursday, July 6, 2006
10:45 AM
Project Name: Inventory Control
Presenter: Steve Payne
Description
The purpose of this Inventory Control is to keep track of the inventory for Cesar A. Caceres, MD PC.
Project Goals
The Project goals are as follows:
Medical Supplies Form
Enter item
Set order level
View inventory levels
Ability to manually adjust inventory levels
Usage Log Sub Form
Track When Items taken with Account number
Qty and by whom
Inventory reorder report
Shows all items at or below reorder level
Generate a report for items that need to be ordered
Requirements/Resources
Visual Basic .Net
Ms Access DB or SQL
Current Status
working
Related Documents
Documentation will be included in the code
Little documentation for how it works will be done afterwards.
Copyright © 2006 Steve Payne
check this site out
http://www.devarticles.com/c/b/ADO.NET/
creating reports however is a little different. you need software to do that, like crystal reports (and if you have visual studio professional it comes with it) the only other option ive found is when i used to have to create reports in excel. that way however is a huge pain.
any other questions let me know.
~b