access10000
Registered User.
- Local time
- Today, 09:22
- Joined
- May 31, 2007
- Messages
- 25
Hi
I am trying to find a way to build custom scrollbars into Access forms that are linked to say a textbox, and moving the scrollbar or slider, (where a min and max value could be set), updates the value in the textbox.
Excel has useful form controls such as scrollbars, spinners etc. that can be linked to a cell value and I'm trying to find a way to utilise this in Access.
I am developing a database where users can set parameters for a process that runs on a weekend update as per the current parameters. For instance, the total stock return qty a warehouse can handle in a week is 4000 lines, but a planner has the flexibility to set this between 0 and 4000.
I think this would be more interesting than just having a standard textbox for people to freetype into. Hopefully the attached Excel file shows where I'm coming from.
I am aware there is not standard functionality for this and I haven't been able to find anything on this so far, but hopefully someone will be able to help.
Many thanks
I am trying to find a way to build custom scrollbars into Access forms that are linked to say a textbox, and moving the scrollbar or slider, (where a min and max value could be set), updates the value in the textbox.
Excel has useful form controls such as scrollbars, spinners etc. that can be linked to a cell value and I'm trying to find a way to utilise this in Access.
I am developing a database where users can set parameters for a process that runs on a weekend update as per the current parameters. For instance, the total stock return qty a warehouse can handle in a week is 4000 lines, but a planner has the flexibility to set this between 0 and 4000.
I think this would be more interesting than just having a standard textbox for people to freetype into. Hopefully the attached Excel file shows where I'm coming from.
I am aware there is not standard functionality for this and I haven't been able to find anything on this so far, but hopefully someone will be able to help.
Many thanks