lodmark's latest activity

  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Hi Now I have solved the problem with searching for my records based on the artist and managed to sort them correctly. Almost in any...
    • Skärmbild 2025-10-26 093720.png
    • Skärmbild 2025-10-26 094115.png
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Cascading combo boxes would solve my problem. But as it works today when I only select the artists from the artist table and with a...
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Fix this by changing the order of the tables in design mode. But now the artists first record doesn't come first, so there still things...
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Your code works @arnelgp. I've managed to fix the missing punctuation. But now I've only have the result from the first field in the...
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Thanks @Pat Hartman I will look into that. But it's a bit to change then...hm.
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    • Skärmbild 2025-10-03 161901.jpg
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    I have a drop down combo at the top of my form for my vinyl records where I can list the artists. This has worked for a while, it was...
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    YES!
    • Skärmbild 2025-10-03 155447.jpg
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Yes that would do it. But I need the Record_ID as a result in the combo box as it's the record of the artist that i'm looking for. And...
  • lodmark
    lodmark replied to the thread Solved Sorting with DISTINCT.
    Hey! That was almost embarrassingly easy. Thanks. But when I try your SQL statement as a row source in my combo box, I get the...
    • Skärmbild 2025-10-03 153727.jpg
  • lodmark
    Hi! I have a question regarding the appearance of the dropdown list for a search function. I have collected the fields I need for the...
    • Skärmbild 2025-10-03 100049.jpg
  • lodmark
    lodmark replied to the thread Solved Funny sorting.
    I'm totally with you there @isladogs . As you already understood it's only the image that's on OneDrive. Have a nice day. Leif
  • lodmark
    lodmark replied to the thread Solved Funny sorting.
    It was not a space but a TAB character in front of the text in the posts. So it's solved. Thanks for the code arnelgp! Leif
  • lodmark
    lodmark replied to the thread Solved Funny sorting.
    A funny thing is that I can't just delete the spaces from behind. Then the last carachter disapears. I'll have to copy the post to a...
  • lodmark
    lodmark replied to the thread Solved Funny sorting.
    I Think I've solved it. There was some spaces at the end of the post. I will no try to rewrite the rest and se if it's solves everyone...
Back
Top Bottom