• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by kirkm

  1. K

    Shell not displaying

    The Access window remains, the thunderbird window doesn't appear (whch is what's wanted). Is this what Sendkeys is intended to do?
  2. K

    Shell not displaying

    After first testing and seemingly okay this is now failing to show the Thunderbird Window until clicked in the taskbar, thund = "D:\Program Files (x86)\Mozilla Thunderbird\thunderbird.exe " & _ "-compose " & """" & _ "to='" & email & "'," & _...
  3. K

    Listbox value

    When designing the form I had a textbox, a label and listbox in a row, showing e.g "1944" to "1955". The 1944 is passed in OpenArgs and the listbox held years from that to 2000 (max). I simply made the listbox the same height as text box for aesthetics, then noticed the scrollbars worked like...
  4. K

    Listbox value

    Right I'll try it and see. I had changed height to show 3 items and that made it obvious one should be clicked. This also turned the "arrows" into a scrollbar. The listbox height showing only one item, then changing them (yes like a spinner) but still having to click was not good.
  5. K

    Listbox value

    Yes, there was no need to click 100 times, just hold it down. But am I using an activeX control? It was just the Listbox tool from Access's Create menu.
  6. K

    Listbox value

    There isn't a rowsource query. That would mean having a table holdeing 1 to 100 ? Isn't additem in a loop far better ?
  7. K

    Listbox value

    As far as I can tell, none. But you're only showing one item... then that's the one you want.
  8. K

    Listbox value

    I follow that, but it shouldn't be necessary as you've already just moved the item into view with the up/down things. However it ain't a perfect world...
  9. K

    Listbox value

    Hi Arne as per Msg 1 ListPosto/From hold items 1 to 100. List4 contains 4 digit years from SQL. There's also a text box holding a start year (setup in another Form). The idea is the user selects a Year range, then a range anywhere between 1 and 100. I think the problem was no dropdown. Without...
  10. K

    Listbox value

    OK. Thanks for everyone's help. I've redesigned the Form to use a 3 line Dropdown and pre-slected default values to avoid Null. I still think there should be a way to get the value showing in the Listbox (when there's no dropdown) without clicking it but I'll have to give up on that even though...
  11. K

    Listbox value

    ? i there is no Highlight on the listbox, then nothing is selected therefore the its Value is Null (nothing). Actually, no that is not true. In Form Load I have listPosTo = 10 after the 100 additems. This is so it initially shows 10. ? listPosto shows 10. even though nothing is selected.
  12. K

    Listbox value

    So, although a value is showing, you can never read what it is ? Please let me know so I can try something else. Thanks!
  13. K

    Listbox value

    Ah, on thinking more I have set a listbox height to 0.6cm to match some other controls. Is this preventing a drop down ?
  14. K

    Listbox value

    Hmmmm. The item is not highlighted as there's no dropdown list to choose from . The value appears in the control (looking like it's just a textbox) but there are scrollbars, well they're not really scrollbars in the traditional sense. They're an up/down arrow and as you click it the values...
  15. K

    Listbox value

    > If you are getting null for the value and -1 for the listindex you have not selected an item in the list. I've move the scrollbars so they show an item. Do I need to click on the item as well ? If so, thats an extrsa step that isn't obvious. Can it be avoided?
Top Bottom