Recent content by JonoB

So, if I understand you correctly, I use a collection to hold the data, and I then loop through the collection and insert one record at a time into the database?

Hi all, I am parsing a relatively large text file, and I need to split the information into various fields, and then insert the parsed data into a database. At the moment, I have the parsing bit working fine, and I create an array to temporarily hold all the information - this is a 2-dimension...

Winner! Thank you.

Just started with Visual Basic Express 2008, after coming from an Access and VBA background. I am trying to do is loop through a multi-select listbox and retrieve all the selected items, but it doesnt want to play nice. What I have tried: *********************** For Each varItem...

I have also tried, with same result If Me.ListBox1.SelectedItems.Count <> 0 Then ' If so, loop through all checked items and print results. Dim x As Integer Dim s As String = "" For x = 0 To ListBox1.SelectedItems.Count - 1...

Wow, this is driving me crazy. Just started with Visual Basic Express 2008, after coming from an Access and VBA background. All I am trying to do is loop through a multi-select listbox and retrieve all the selected items, but it doesnt want to play nice. What I have tried: For...

Perfect! Sometimes the most simple answers are the right ones.

The reason why I cannot select both FullString and MergeString is that *every* FullString is unique. i.e. if I do SELECT DISTINCT FullString, MergeString from qryMergeTime; or if I do SELECT DISTINCT FullString from qryMergeTime; then I will return every single record. Which is not what I...

I have a select distinct query as follows: SELECT DISTINCT [MergeString] FROM qryMergeTime Whilst this does return the right records (i,e. only shows unique records in the [MergeString] field, it doesnt show all the fields that I need to see, i.e. the SELECT DISTINCT function needs to run on...

Hi all, Need some tips to help me approach this problem. I would consider myself advanced in Access and VBA, so just looking for conceptual pointers. In essence, I have a number of text files, each of which contains data that is parsed into various database tables. The data thus stored in the...

Did you import the GetFileInformation() module into your new database? Did you compile your code? You may have to set references to Microsoft Excel and Microsoft Office in vba editor.

Thanks for that Roy. No problem on the mixup, but I use primary keys on every table as well. Cheers

Yeah, I saw the string variable name issue, and also wondered about the unique index issue. As mentioned, I could sort this our using table definitions, but this would present some user-friendly issues. So, back to my original code or using dcount....which do you reckon is faster? Intuitively...

I am awarw that this could be done with dcount, but have ben steered clear of using domain functions....not sure if this may be an exception

Hi, I have written the following procedure which prevents duplicate records from being inserted into a table. This works 100%, but was wondering if there were any other (more efficient?) ways of doing this. I am aware that this could be done with table definitions, but not quite sure of the...