Recent content by JoseO

  1. J

    Best approach to large data sets in Access

    **THANK YOU SO MUCH** everyone for all the great, great answers. I have not started developing my DB because I first wanted to get expert thoughts/opinions before I proceed. Once again, thank you so much for all of the great responses. I really appreciate it!
  2. J

    Best approach to large data sets in Access

    How many rows of data can I have in my Access database table before I have to seriously start worrying about awful performance? I know this topic/question has been floating in the Internet for a number of years. But it seems that the answer is always to walk away from Access into SQL and other...
  3. J

    When deleting item from Listbox don't re-sort

    Good nite! MajP you are a rock star!! Thank you so much! Worked like a charm!!! :)(y)
  4. J

    When deleting item from Listbox don't re-sort

    Giving this a whirl and reporting in a few. Thanks so much MajP!
  5. J

    When deleting item from Listbox don't re-sort

    Thanks Mike. Perhaps I should have been more specific. My title should stay the same. The problem is when I use the buttons to move the selected item up or down hence sorting my list in the listbox visibly and in the table. So, the sort is working (all the above code works just fine) when I...
  6. J

    When deleting item from Listbox don't re-sort

    Good afternoon, My dilemma has to do with getting a sort to “stick”. Here’s what I have: A table with 3 columns: ID/PK field – PRINTORDER – PART A form that displays the record for each part A Listbox control in the form with 3 columns (same as first bullet point) the ID field being hidden...
  7. J

    Inserting into a single column

    Nice. Thank you June7 :-)
  8. J

    Inserting into a single column

    Thank you, thank you June7, Dbguy, Micron, Galaxiom, and Doc-man Not only do I appreciate the SQL samples but, more so, the educating part of each of your posts. I want to learn good DB design and implementation and, having pros like each one of you guide me and instruct me, is a huge blessing...
  9. J

    Inserting into a single column

    Thank you Micron. Yes, I have tried UPDATE and INSERT. But when I try them with a WHERE clause it's essentially filling all Null fields in Field1 (first column). I've attached a picture.
  10. J

    Inserting into a single column

    Hi, Ever since I started using Access, I've been told to make use of Tables in order to populate my combo boxes. As such, rather than setting up, say, 4 tables to hold just one column of combo box choices each, I use one table and each column then supplies the combo box choices. This works...
  11. J

    Proper >= And < Where Condition in VBA

    The_Doc_Man, Galaxiom, and, CJ_London - Thank you all so much for your very thorough explanations/solutions. Much appreciate this forum.
  12. J

    Proper >= And < Where Condition in VBA

    Thank you Galaxiom for the explanation - much appreciated. For fun and giggles, could you show me where those operands need to be placed? Thanks again. :)
  13. J

    Proper >= And < Where Condition in VBA

    Thank you for the prompt reply Galaxiom. It is my understanding that If i don't specify a time, Access assumes midnight and will not search anything pass midnight unless properly queried. The BETWEEN function does not accomplish this. So if my users run a search from 6/1 - 6/30, if there is...
  14. J

    Proper >= And < Where Condition in VBA

    Hello folks, Perhaps I've been starring at this too much. What I am trying to do with the following WHERE condition is replace BETWEEN with >= And < operands for my date range. I've played around with the placement of them to no avail. Any help is appreciated. Thank you much...
  15. J

    Pictures side-by-side

    Thank you so much ridders. I honest to goodness don't recall the original post answer but I am super thankful for reposting it. Thank you so much! I will examine/explore and report back. :)
Top Bottom