How to use data on MS-Access for generating INVOICE

wANT TO FETCH DATA FROM DIFFERENT TABLES TO GENERATE A REPORT (INVOICE

Page 1 of 1

5 Replies - 2764 Views - Last Post: 25 July 2009 - 01:11 PM Rate Topic: -----

#1 bodeVBcode  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 23-July 09

How to use data on MS-Access for generating INVOICE

Post icon  Posted 23 July 2009 - 02:19 PM

Hello, I have four tables in my MS-Access database, in the tables are these columns; table1.customerreference, table2.flightcost, table3.hotelcost and table4.tourcost. (However, column customerreference is also available in table2, table3 and table4)I want to achieve the following; 1. To use the customerReference number and search for the customer flight booking cost and reflect such on the invoice 2. To To use the customerReference number and search for the customer fHotel booking cost and reflect such on the invoice 3. To use the customerReference number and search for the customer tour booking cost and reflect such 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

Is This A Good Question/Topic? 0
  • +

Replies To: How to use data on MS-Access for generating INVOICE

#2 vb5prgrmr  Icon User is offline

  • D.I.C Lover

Reputation: 109
  • View blog
  • Posts: 1,016
  • Joined: 21-March 09

Re: How to use data on MS-Access for generating INVOICE

Posted 23 July 2009 - 04:21 PM

You need to do an inner join. See Access's query builder to help you with the syntax that you need to pass to CR.



Good Luck
Was This Post Helpful? 0
  • +
  • -

#3 raziel_  Icon User is offline

  • Like a lollipop
  • member icon

Reputation: 463
  • View blog
  • Posts: 4,255
  • Joined: 25-March 09

Re: How to use data on MS-Access for generating INVOICE

Posted 24 July 2009 - 12:36 AM

sending the records to excel can help you see or print it

good luck
Was This Post Helpful? 0
  • +
  • -

#4 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 179
  • Posts: 1,599
  • Joined: 17-April 07

Re: How to use data on MS-Access for generating INVOICE

Posted 24 July 2009 - 06:00 AM

add a dataenvironment in your project add a command object
and choose the main table
now add the child commands you want and specify the child table with relationship now use it in the reports

hope you understand!

for further search google DataEnvironment in vb6
Was This Post Helpful? 0
  • +
  • -

#5 bodeVBcode  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 23-July 09

Re: How to use data on MS-Access for generating INVOICE

Posted 24 July 2009 - 07:11 AM

View PostNoBrain, on 23 Jul, 2009 - 11:36 PM, said:

sending the records to excel can help you see or print it

good luck

Please what are the steps to out data from VB6 to excel?
Was This Post Helpful? 0
  • +
  • -

#6 raziel_  Icon User is offline

  • Like a lollipop
  • member icon

Reputation: 463
  • View blog
  • Posts: 4,255
  • Joined: 25-March 09

Re: How to use data on MS-Access for generating INVOICE

Posted 25 July 2009 - 01:11 PM

see this it is start try it and if you have questions ask them here again :)

http://www.ultimaserial.com/exd2.html
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1