i  created vb project named company. mainly includes employee details company management.
i created sales and purchase orders and all.
  now i wanted to do is to make sales invoice and to print. sales order includes the product detail (total price calculated in it) and customer code. i have no idea how to do it.

I know how to make report in MSaccess.


Please suggest me the better way to do it. Thanks in advance

Dear fatima,

your answer lies in my question that i have posted, just download this viru.zip and run the program go through it....propably you will face some problem in dataenvironment connection....if you face it mail me back and i will mail you step by step guidance for the same but for now refer to the sample code... its the master-detail program with one data report in it..hope this will help you.....bye

amit

____________________________
Attached:
viru.zip 32 KB (Downloads: 41)

do you know how this can be done using access reports.

i am new to vb. i can't understand how this dataenvoronment and report can be used.

Please help me

dear fatima,

tried to mail you a step by step tutorial for Datareport, but the administrator didnt allowed to upload a file as the size of the file exceeds the limit , give me any alternate mail id of yours so that i can mail the same to you....bye for now

amit

I know this post is in the graveyard but i also need to make a purchase order and sales invoice to print.

i tried running your code and it gave me this error.

Run-time error '-2147217900(80040e14)':

Data shape command text contains a syntax error at or near position 114 in the command. The text near the error is: "Command2 RELATE) AS Command2".

when i clicked debug, it pointed me to the line

DataEnvironment1.Command1 (Combo1.Text)
My project deadline is  in 2 days   , i really gotta make this work. hope you guys can help. thanks!