Community discussion forum

GENERATING INVOICE USING VB6.0 AND MS-ACCESS

• • Reply

  4 months ago

  by bodeness

  Olabode Agboola

  Port Harcourt, Nigeria

  Joined 4 months ago

  Hello,

  I have three tables in my MS-Access database, in the tables are these columns; customerreference, flightcost, hotelcost and tourcost. I want to achieve the following; 1. To reflect the details of all the flight booking for a specific customer on the invoice 2. To reflect the details of all the Hotel booking for a specific customer on the invoice 3. To reflect the details of all the Tour booking for a specific customer on the invoice 4. Total cost (flightcost + hotelcost + tourcost) of the specific customer on the invoice.

  I am not sure if crystal report can do these and even if it could, I have zero knowledge of crystal report.

  Can someone help to do a VB code that will rpoduce this invoce such that it will contain the option of viewing it or printing it.

  Thanks

  Post was edited on 23/07/2009 05:04:20 Report abuse
• • Reply

  3 months ago

  by AGEDE

  WILLIAMS AGEDE

  lagos, Nigeria

  Joined 3 months ago

  oga , what u want to do is possible , use crystal report9 for it instal crystal report9 , then link it to your ms access database if you need more explanation call me up on 07036921489 cos i have to know where u need help afterwards . thanks

  Report abuse