Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Iron Speed
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
  #1  
Old April 19th, 2008, 04:36 AM
jasonoram jasonoram is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Apr 2008
Posts: 2 jasonoram User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 5 sec
Reputation Power: 0
Help required for work project!!!

Basiclly i have been given a small task (according to the boss) but it seem a bit beyond me i dont know where to start or how.
I have a number of different spreadsheet(Excel) which have different companies price lists on.
I need to create something(not sure what) so that from a start screen i can select which supplier/s (could require a number of different suppliers spreadsheets) i want to use and have the details of the spreadsheet displayed on the screen.
Once on the screen i will need to manually add in amounts of the materials etc.
When i have done this i will need to move information onto another screen (Finance) to change the make ups etc.
This all needs to be bullet proof as we have a lot of idiots who seem to save the wrong thing to the wrong place and make all the spreadsheets a mess........
I dont know if anyone has any idea how to help but any info would be good
Thanks

Jason

Reply With Quote
  #2  
Old April 21st, 2008, 09:28 AM
Shadow Wizard's Avatar
Shadow Wizard Shadow Wizard is offline
Moderator From Beyond
Click here for more information.
 
Join Date: Sep 2004
Location: Israel
Posts: 26,397 Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)Shadow Wizard User rank is General 5th Grade (Above 100000 Reputation Level)  Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1Folding Points: 313769 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Months 1 Week 3 Days 22 h 32 m 47 sec
Reputation Power: 1311
do you mean VB application (with GUI and all) or web application?

Reply With Quote
  #3  
Old April 21st, 2008, 11:26 AM
jasonoram jasonoram is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Apr 2008
Posts: 2 jasonoram User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 5 sec
Reputation Power: 0
Quote:
Originally Posted by Shadow Wizard
do you mean VB application (with GUI and all) or web application?


I think VB application?? What i need to do is open a file/application and have a screen appear on the screen then be able to select the relevent supplier/s from a list and load the spreadsheet with the suppliers sheet.

This should stop all the sheets being visable and various user editing them, copying them or moving them

Reply With Quote
  #4  
Old April 22nd, 2008, 09:34 AM
Phoenix_riser Phoenix_riser is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2005
Posts: 223 Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 2 Days 2 h 7 m 21 sec
Reputation Power: 14
Good day, excuse the slight hijacking as I think we might be looking for the same thing.

I want code to import CSV to an Access table - the table should take the first line as the field names if possible. If this is not relavant the I will of course start a new thread.

My thinking is that if you want a VB program for your comparision then this might help. Personally we just use Excel and lock out the formula cells and just an 'input' sheet at the front. It might not be as pretty but everyone can use it easily.

Reply With Quote
  #5  
Old April 24th, 2008, 06:10 AM
Phoenix_riser Phoenix_riser is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2005
Posts: 223 Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level)Phoenix_riser User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 2 Days 2 h 7 m 21 sec
Reputation Power: 14
To grab the database add in the columns you need to the code below. Do you need a flex grid too?

Code:
Private Sub PrcImportBatch()

Dim db As Database
Dim rs As Recordset
'
'Strings
Dim strOrder_id As String
'
Dim strSQL As String
Dim strFileToOpen As String
Dim TestNum As String
Dim lngField As Long
Dim strTest1 As String

Dim Vfile
Dim X$
'
' The Database
Set db = DBEngine.OpenDatabase("C:\Documents and Settings\AddressLabels.mdb")
'
' Empty Data Source
strSQL = "DELETE * FROM 79;"
db.Execute (strSQL)
strSQL = ""
'

' The Text File
Vfile = "C:\batch " & txtBatchNumber.Text & ".csv"
strFileToOpen = CStr(Vfile)
'
' The Data Table within the Database
Set rs = db.OpenRecordset("Batch79")
'
' Open the Text File
Open strFileToOpen For Binary Access Read As #1
'
Do While Not EOF(1)
    X$ = Input$(1, #1)
    '
    If X$ = "" Then
        ' move on
    Else
        TestNum = Asc(X$)
        '
        Select Case TestNum
                  '
            Case 9 ' its a tab
                Select Case lngField
                
                    Case 0
                        strOrder_id = "" & strTest1
                        strTest1 = ""
"
 
                        '
                        With rs
                            .AddNew
                            '#####################################
                        .Fields("order_id") = strOrder_id
                            '#####################################
                            .Update
                        End With
                        '
                        strTest1 = ""
                        lngField = -1
                        '############################################

                        End Select
                        lngField = lngField + 1
                        Case Else
                        strTest1 = strTest1 & X$
        End Select
    End If
Loop
'
Close #1
rs.Close
db.Close
'
cmdImportBatch.BackColor = &H80FFFF
'
End Sub
Comments on this post
Shadow Wizard agrees: looks very good, thanks for sharing

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Help required for work project!!!


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.

 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.

 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.

 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five "checkpoints" for any implementation plan that will help make IP communications a successful proposition.

 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway