|
|
|||||||||
|
|||||||||
|
|||||||||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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 ![]() |
|
#2
|
||||
|
||||
|
do you mean VB application (with GUI and all) or web application?
|
|
#3
|
|||
|
|||
|
Quote:
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 |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
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
|
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Help required for work project!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|
|