Shopmobility Database

[fredfox]

I am tasked with trying to build a database up and am still having problems fine tuning it. I have minimised the amount of info in the attached zip for obvious reasons.

In the Usage Form there is a Time Out and a Time Back area to put the relevant times the mobility vehicles are used.

I would like to be able to place scroll buttons on both so as to scroll up and down to get to the relevant times between 09:00 and 17:00 rather than having to type them each entry.

Can anyone help me by completing the attached file and zipping it back to me, this would be very much appreciated.

Foxy

 

[John.Woody]

Try That tab on to the time and use the + and - to go up and down. Occasionally you have to press twice for it to move (I don't thinlk I've got the numbers quite right but press and hold and it wizzes through the minutes

 

[rahulgty]

rahulgty

You can prepare seperate table with time bewtween 9:00 to 17:00 and put a listbox on form instead of textbox. In list box you can scrol through the time what ever you required you can select.

 

[rahulgty]

rahulgty

I am sending back your charity database after putting list box for time out and time in. Hope it will help you.

 

[ScottGem]

Fred,

Attached is a demo app with a popup calendar and time selector. The time selector does, what I think you want. If you have trouble integrating that into your app let me know.

 

[fredfox]

Yes it could help, especially the time bit but do not know how to incorporate it in the database.

 

[ScottGem]

Yes it could help, especially the time bit but do not know how to incorporate it in the database.

Fred,
Look at the forms. There is code attached to the On Click event of the buttons or the On Doubleclick event of the controls. You need to import the module into your database and use the code attached to the controls for your controls.

Its really not that difficult. After looking at it morer closely, let me know if you have any specific questions.