Recent content by jpskiller

Thanks guys, Yes the column names are question based. I have found only 4 columns with names that are too long and the 64 character limit is causing duplicates, so as suggested I have renamed those columns before doing the import and now works fine.

Hi, I have been given a large CSV file extract where the column headers go upto Range DX. I have tried the following but it seems to truncate the headers which is causing it to think there is a duplication due to some headers being very similar. These are example headers Exit Survey - Survey...

Thanks everyone great advice and example code

Got It Working Form_Main.JobStatus.Requery

Think I will use the a table and link listbox to that and then just update table. If I do it this way how do I get the listbox to refresh to show the changes in the table I was hoping it was going to be easy using just plain code to create and update listbox like it is in excel, vb...

Yes the form is open, I have a button on a form that calls a function and as part of that function called I want to fill the listbox on the form then while processing the rest of code I can update the list box to show completed at each step. I found this code, again works called directly from...

Hi, I am very new to VBA and having issue with listbox. for example Formname = Main shows in VB as Form_MAin Listbox = JobStatus Multi Column I have a function in a module Public Function FillStatusList() With Form_Main.JobStatus .ColumnCount = 2 .RowSourceType = "Value List"...

Hi, Im a beginner in VBA and VB Net been doing bits and bobs here and ther, mostly just learning.