• ** 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/

Search results

  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?
  16. K

    Listbox value

    > if you get -1 for listindex then nothing is selected. OK. But there is a value in the list box. That's what I want to use in my botton event.
  17. K

    Listbox value

    > perhaps your talking about the scrollbar. > you are selecting an item in the list first right? Yes and yes. The items change as you scroll. That list stays on one item, as opposed to a dropdown list.
  18. K

    Listbox value

    The row source For List4 is in Msg# and in Form Load, not a property entry. That ok ? Column count (on all 3) is 1. Rowsource type for List4 is Table/Query and the others are Value/List
  19. K

    Listbox value

    The multi select property shows "None" for all 3. Really weird I can't find this via Google. The value I want is what's showing. I've looked at ListIndex but that says -1.
  20. K

    Listbox value

    > list boxes dont have arrows. Are you talking about combo boxes? No, they're definitely list boxes. Maybe they're not called arrows.. the things you click on to move through the items.
Top Bottom