User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 426,478 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,197 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 876 | Replies: 2
Reply
Join Date: Jul 2007
Posts: 1
Reputation: xwings is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
xwings xwings is offline Offline
Newbie Poster

VB6 and MS Access Problem

  #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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2007
Location: bangalore
Posts: 42
Reputation: guru511 is an unknown quantity at this point 
Rep Power: 2
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)

  #2  
Jul 9th, 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  
Join Date: Nov 2006
Posts: 712
Reputation: QVeen72 is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 97
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Master Poster

Re: VB6 and MS Access Problem

  #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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 4:11 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC