Search results for query: *

Replace the code you have posted above with this code Dim sArtistKey As String Dim sAlbumKey As String Dim sTrackKey As String Dim rst1, rst2, rst3 As Recordset ' Open a recordset and loop through it to fill tvwMusic ' Fill Level 1 using ArtistID as Key property If rst1.State =...

...and you are welcome, have you stepped through the code to check where the "Out of bounds" error actually occurs? Which key is not unique? Artist or Album? The Treeview control's Key property requires some non-numeric value, so using only the Autonumber field will not work. You will have...

Hi kimtp, I think I see your problem. BUG-FIX: In your code for Level 2 change the line, frmSSTab.tvwMusic.Nodes.Add rst.Fields("ArtistID").Value, tvwChild, sOrderKey, rst.Fields("Album").Value to this, frmSSTab.tvwMusic.Nodes.Add "a" & rst.Fields("ArtistID").Value, tvwChild, sOrderKey...

Hi Devilboy916, When importing from a CSV data source file, DTS assigns a varchar/nvarchar datatype for each column in the CSV file. You could use a "staging" table in MSSQL to import all the Source CSV data, and then use a Transform Data Task to load data into the Destination table. In the...

gmctrek, In case you have not yet been answered on this one. You will need to assign the "HireDate" Global Variable using the Dynamic Properties Task before you run this ActiveX code. The "DTSTask_DTSDataPumpTask_1" Task is created as a CustomTask when you "Set oDataPump = ...". HTH...

Hi madhav23, I am using a font file named "C39HALF.TTF" for my bar-codes on a set of logistics reports. You can make most text data appear in a bar-code as long as you have the "start-bit" and "stop-bit", which crystalreporting has refered to above as termination...