473,326 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Difficulty with combo box selection

Hi

I have developed an application for data enty for daily production in
my factory.

I have one combo box for shits and second combo box for the "machine
names".
the third field on the form is the "production reading of the
machine".

My problem is that I want to enter data in the text field without
selecting the value for subsequent machines from the Machine name
combo box. When I select first machine on the start of data entry I go
to text field and enter the value. For subsequent entries I dont want
to select machines but want them to sequentially get selected and I
only enter data in text field for next machine.

I have only four fields in my Production table
Slno. number
shiftname text
machinename text
productionreading number
I have a separate table for machine name from where I populate the
combo box.

Please help..

Thanks

Mike
Nov 13 '05 #1
2 1291
Mike wrote:
Hi

I have developed an application for data enty for daily production in
my factory.

I have one combo box for shits and second combo box for the "machine
names".
the third field on the form is the "production reading of the
machine".

My problem is that I want to enter data in the text field without
selecting the value for subsequent machines from the Machine name
combo box. When I select first machine on the start of data entry I go
to text field and enter the value. For subsequent entries I dont want
to select machines but want them to sequentially get selected and I
only enter data in text field for next machine.

I have only four fields in my Production table
Slno. number
shiftname text
machinename text
productionreading number
I have a separate table for machine name from where I populate the
combo box.

Please help..

Thanks

Mike


After the user selects the first machine in the combo box, and has
entered the production reading for it in the text box, you might try
something like the following in the AfterUpdate event for the text box:

START OF CODE

Dim varItem as Variant

For each varItem in cboMachine.ItemsSelected
If cboMachine.ColumnCount - 1 > varItem then
cboMachine.Value = cboMachine.ItemData(varItem+1)
End If
End If

END OF CODE

This will select the next machine listed in the combo box.

If you look up ItemsSelected, ItemData, ColumnCount, and Value in Help
that willl give you a better idea of what's happening.

Good luck. If you have problems getting this to work, post your code.

(warning - I did not test the code above).

Nov 13 '05 #2
Briuce,

Thanks for the suggestions.
I was able to solve the problem by changing the combo box to List box
and use the same code that you had provided.
I need to know How I can keep the focus on the machine name
automatically selected. Right now I don't know which machine is
currently selected as the cursor always remains in the production entry
(Text box).
Is there some work around on this...

Thanks

Mike

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mike | last post by:
My original problem was solved by Bruce Dodds (Thanks!!) ORIGINAL PROBLEM I have developed an application for data enty for daily production in my factory. I have one combo box for shifts...
1
by: BigJay | last post by:
I am 1. trying to have a combobox used as a selector to display records in a subform. and not sure on how to get selected info into subform.the combo is populated but can not get subform updated...
4
by: meganrobertson22 | last post by:
Hi Everyone- I have a question about how to add and then use the "All" selection in a combo box. I am trying to figure out how to: (1) add "All" as a selection to a combo box and then (2)...
7
by: Doug | last post by:
Hi I have a combo box (A) that populates a following combo box (B) based on a selection. The selection from the first combo box (A) initiates an OleDbDataAdapter routine that extracts the...
3
by: hmiller | last post by:
Hey everyone, I am having a hell of a time trying to set this menu system up. Here's what I'm trying to do. Combo Box One; is populated by names under properties "row source" "Phase 1"...
5
by: Ant | last post by:
Hi, (Winform VS2003) I have a combo box bound to a typed data set. When the form loads, the combo box is popluated using a method containing the simple code below: ------------------------...
6
by: Dave | last post by:
I want to put the information that the user selects in my combo boxes into a subform that lies on the same form as the combo boxes. Thanks for your help already, Dave
1
by: didihynes | last post by:
Hi Guys, I'm in desparate need of help. I am producing a database for my dissertation and have got majorly stuck. I am currently creating a form in which the user will select a student from a...
0
by: dudeja.rajat | last post by:
On Sat, Aug 30, 2008 at 2:32 PM, Fredrik Lundh <fredrik@pythonware.comwrote: Fredrik, Thanks so much. That worked. Following this, I can now see that my combo2 has no previous elements and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.