VB6 and MS Access Problem

Reply

Join Date: Jul 2007
Posts: 1
Reputation: xwings is an unknown quantity at this point 
Solved Threads: 0
xwings xwings is offline Offline
Newbie Poster

VB6 and MS Access Problem

 
0
  #1
Jul 9th, 2007
I just learn how to do a programming with vb6, and i have few problem that i need to get some advise and idea from experts here.

Ok I successfully captured a data from a notepad text, and my access database data filed is look like this;

Schedule sku size inseam total
112206 92221 32 32 40
112206 92221 32 32 12
112205 92221 40 32 8

I decided to make an output to the text format (Notepad) also; I already made the layout of my output suppose to look like this;

Schedule# SKU Inseam/Size 32 33 34 35 36 37 38 40 42 44 Total
112206 92221 30
112206 92221 32 52
112206 92221 32

Schedule# SKU Inseam/Size 32 33 34 35 36 37 38 40 42 44 Total
112205 92221 30
112205 92221 32 8
112205 92221 32

my question is how can I add the “total” if the “schedule”, “sku” , “size” and Inseam” are same? Thanks
Reply With Quote Quick reply to this message  
Join Date: Jul 2007
Posts: 42
Reputation: guru511 is an unknown quantity at this point 
Solved Threads: 3
guru511's Avatar
guru511 guru511 is offline Offline
Light Poster

How can i access data from MS Access using VB6 (I need the connection code)

 
0
  #2
Jul 10th, 2007
[How can i access data from MS Access using VB6 (I need the connection code) can u plz tell me the code for accessing tables in MS Access using Visual Basic 6. my access tables are in a server not in my local computer..... plz let me know the code
Reply With Quote Quick reply to this message  
Join Date: Nov 2006
Posts: 848
Reputation: QVeen72 is on a distinguished road 
Solved Threads: 120
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Practically a Posting Shark

Re: VB6 and MS Access Problem

 
0
  #3
Jul 10th, 2007
Hi,

In ur original Text file, if all the parameters are "Sequential", then u can keep a Running Total and print the Total If Parameters of Next line Changes, and then Re-Set the Total

REgards
Veena
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC