Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JonoB
  • Order by date
  1. JonoB

    Insert into database from array

    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?
  2. JonoB

    Insert into database from array

    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...
  3. JonoB

    Multi select listbox

    Winner! Thank you.
  4. JonoB

    Multi select listbox

    ...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 In Me.ListBox1.SelectedItems MsgBox(Me.ListBox1.Items.Item(varItem))...
  5. JonoB

    Multi select listbox

    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...
  6. JonoB

    Multi select listbox

    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...
  7. JonoB

    Select Distinct query

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

    Select Distinct query

    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...
  9. JonoB

    Select Distinct query

    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...
  10. JonoB

    Parse and merge data

    ...usually around 3 hours. Basically, what I would like to do is to take these x number of records and compare them to eachother, with the following: *Where there are identical records, then I would like to delete all but one of the records. A record would be considered identical if 5 of the 7...
  11. JonoB

    Browsing

    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.
  12. JonoB

    Prevent duplicate records

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

    Prevent duplicate records

    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...
  14. JonoB

    Prevent duplicate records

    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
  15. JonoB

    Prevent duplicate records

    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...
  16. JonoB

    Child/Parent relationship

    Thanks for that..... I have since had someone run a test on 1,000,000 records and there was no performance change between going parent/child or query criteria
  17. JonoB

    Age on Unbound text box Not working

    Do this rather: On the 'On change' event of the Pat_DOB textbox, put the following code. NOte that this assumes that the Age of client textbox is called txtCurrentAge. txtCurrentAge==(Int((Date()-[Pat_DOB])/365)) That way, everytime you change the DOB, the age will update automatically. Hope...
  18. JonoB

    Child/Parent relationship

    As a general efficiency topic, I have the following question: Assuming two tables in a one to many relationship, fully normalised, and a main form and sub form based on these tables. The 'usual' way of linking these is to create a parent/child relationhip between the main and sub form, thereby...
  19. JonoB

    Format date in excel userform listbox

    So when your date needs to be DISPLAYED, you'll need to FORMAT when you load the listbox Format(MyDate, "mm/dd'yy") I had thought of that, but as I previously said, the listbox is populated using the .getrows method as shown in the following code 'Populate the combo if there are records...
  20. JonoB

    Format date in excel userform listbox

    Hi, I have a multi-column listbox in an excel userform that is populated from a recordset (using .getrows). The recordset is from an Access database. One of the columns in the listbox is a date field and although the date format in the Access database is DD/MM/YY (and I have verified that all...

Part and Inventory Search

Back
Top