By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Need guidence in invoice project in vb 6.0 with sql

P: 31
Dear all,

i,m doing a Invoice project in vb 6.0 and i,v no idea about it , can anyone tell me the solution
how to start the project

i created few forms like supplier,customer,product, and i created the add,update,delete, for the all forms , but i need to complete the sales invoice,purchase order,and Reports of 1.sales,2.purchase,3.Total to all and particular customer (or)supplier(or) itemno

these are some table i made
1.Supplier - supid int, primarykey ,supname varchar(20),phone int

2.Customer-cusid int primarykey , cusname varchar(20),phone int

2.Product - itemno int primarykey,descrption varchar(20),supid int,Rate float,qty int

3.Pinvoice - invoiceno int primarykey,date datetime,supid int,supname varchar(20)

5.sinvoice - invoiceno int,date datetime,cusid int,cusname varchar(20)

and they like the result should be like this

sales invoice(The purchase invoice also similer the same instead of custmer we make supplier)

invoice no (textbox) date(textbox)

cusid(combobox)- here all the id to come which we cusname-(textbox)
given in the customer table and when we give the id the cuname will come
automatically in a textbox

(in datagrid) --------------------------------------------------------------------------------------------------------------
itemno description qty price gross(qty*price for each itemno)

Total (Textbox sum(gross))

so this is invoice both the sales and purchase

can anyone tell me how to do this and how to create report , and this is deadline project which i already spent some days

plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz guide me to do this project
Apr 10 '08 #1
Share this Question
Share on Google+
2 Replies

P: 188
Pllllllllllllllllllllllllllllllllllllllllllllllzzz zzzzzzzzzzzzzzzzzzzzzzzz
Cannot write your project for you however much pressing the deadline is. Ask a specific question and then you can expect help. Or get some good vb book and do some digging -which you should have done before agreeing to a deadline.

Apr 10 '08 #2

P: 3
create a report? wow it's a big deal project ..
Jan 18 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.