Need some ideas, brainstorming...

[imtheodore]

I have to create a form that will quickly allow a user to check off certain items on large list. The amount of items is very large so I will have to use multiple forms. My question is; is there a way to populate the value of a field in a form by clicking it, once or many times, and keep count?
The users have touch screens so typing in the value in difficult, plus the value is most often 1 but could be as high as 20. I was thinking if they could just tap item it could count the number of times tapped and list it next to the item.
Is this possible?
Is there a better way?

Thanks...

 

[agehoops]

You could create a command button that just adds 1 to either a variable or a field, or you could set the OnClick event or OnDoubleClick event of the field to add 1 to it, so it could be used easily on a touch screen

 

[imtheodore]

You could create a command button that just adds 1 to either a variable or a field, or you could set the OnClick event or OnDoubleClick event of the field to add 1 to it, so it could be used easily on a touch screen

That is what I came up with, but it there a way to do that for 250 fields without making 250 commands? Can a button look at the field its right or left to operate as opposed to typing all of them?

 

[agehoops]

Have you got a copy of your database i could possibly look at and see if i could come up with a solution. I find it easier being able to see what i'm working with

 

[imtheodore]

Have you got a copy of your database i could possibly look at and see if i could come up with a solution. I find it easier being able to see what i'm working with

I can email you a copy

 

[agehoops]

alright, send it to agehoops at fastmail.fm

I'll take a look at it, see if i can come up with a solution

 

[imtheodore]

alright, send it to agehoops at fastmail.fm

I'll take a look at it, see if i can come up with a solution

Email sent...

Thanks!

 

[agehoops]

what about a drop down box which lists all the drug names you can choose from, and next to this combo box is the + and - signs. Then when the user selects the drug from the list, the buttons then apply to that field???

 

[Bat17]

you could do it using one button, have the user click into the field they want to change and on the button have

Dim ctlPrevious As Control
Set ctlPrevious = Screen.PreviousControl
ctlPrevious = ctlPrevious + 1
ctlPrevious.SetFocus
Set ctlPrevious = Nothing

Though you will probably want to add some error trapping to make sure that they are in a valid field!

Peter

 

[imtheodore]

you could do it using one button, have the user click into the field they want to change and on the button have

Dim ctlPrevious As Control
Set ctlPrevious = Screen.PreviousControl
ctlPrevious = ctlPrevious + 1
ctlPrevious.SetFocus
Set ctlPrevious = Nothing

Though you will probably want to add some error trapping to make sure that they are in a valid field!

Peter

Thanks, that works great! Can it be modified to take so I can click on a list box item and populate the field the cursor was previously in? It would be all text. Drag and drop doesn't work very well and this is the next best thing.
Different scenerio, same idea. I need to populate a list of 10 items with a list of a possible 30 selections.

Item1...................................Hat
Item2...................................Coat
Item3...................................Sock
etc...______________________Shoe
...........................................Pants
...........................................etc..

I need to click on a value on the right and place it in the left

Thanks
Dave

 

[imtheodore]

Help

 

[Bat17]

Part 1

Private Sub List0_AfterUpdate()
Dim ctlPrevious As Control
Set ctlPrevious = Screen.PreviousControl
ctlPrevious = Me.List0
ctlPrevious.SetFocus
Set ctlPrevious = Nothing
End Sub

Peter

 

[Bat17]

for the second part you will need to add the items to the underlying table for the listbox then requery the listbox to show the added item.

Peter

 

[imtheodore]

for the second part you will need to add the items to the underlying table for the listbox then requery the listbox to show the added item.

Peter

Thank You, I will try it right away

Dave

 

[imtheodore]

Ok, I didn't explain myself well enough. I need to move the element from a listbox (or a list I type in whatever is easier) on the right into one of many fields on the left.
So I have a listbox and 20 possible fields for each item in the listbox. I would have one big listbox and 20 text boxes, one for each item.

 

[Bat17]

OK this rather assumes that you have named your text boxes consecutively

  Dim j As Integer
Dim bolDone As Boolean
For j = 1 To 8
    If Nz(Me.Controls("text" & j), "") = "" Then
        Me.Controls("text" & j) = Me.List0
        bolDone = True
        Exit For
    End If
Next j
If bolDone = False Then
    MsgBox "No available lots", vbCritical
End If

I would also add code to each text box to clear them if clicked on so that errors can be corrected.

Private Sub Text2_Click()
Me.Text2 = ""
End Sub

Peter

 

[imtheodore]

This will work!
Is there any to clear my list box as I choose from it? Or do I have to use a query and keep requerying it?

I can rename all of my text boxes consecutively to make this work.

 

[Bat17]

another possibilty would be to use a multi select list box, let them pick all the ones they want then hit a button to transfer them.

Peter

 

[imtheodore]

another possibilty would be to use a multi select list box, let them pick all the ones they want then hit a button to transfer them.

Peter

What I am doing is scheduling.

I have a list of 30 doctors on the right, I need to put them into 20 rooms on the left. The rooms are numbered so I cannot move them in batches. The first doctor I choose may be in the 15th room etc...
Drag an drop would be perfect but in Access if I drag up or down the cursor follows, it only allows for straight across dragging to keep order.