A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Beginner with ComboBox



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 01:26 PM posted to microsoft.public.access.gettingstarted
Mort
external usenet poster
 
Posts: 14
Default Beginner with ComboBox

I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table tblStats.
I can not figure out how to accomplish this. Please help

Mortimer
  #2  
Old April 23rd, 2010, 02:02 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Beginner with ComboBox

Mort,
A combo control (like a text control) can be "bound"
to a field in the table/query behind the form. Which means that any
value entered into that control, when updated, will be written to that
field in the table. Fields that are bound to the control are indicated in
the control's ControlSource property.
From what you've desciribed, you should be able to
"bind" the combo control to the Status field in tblStats.
Make sure Status is included in the query behind the form, and enter
Status
in the ControlSource for your combo.

Set your combo's RowSourceType to Value List
Enter "Complete"; "Incomplete"; "Pending" into the combo's RowSource
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Mort" wrote in message
news
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer



  #3  
Old April 23rd, 2010, 02:06 PM posted to microsoft.public.access.gettingstarted
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Beginner with ComboBox

Is the form bound to tblStats? If so, bind the combo box to the Status field.


On the combo box Property Sheet you could make the combo box Row Source a
Value List, then for the Row Source enter:
Complete;Incomplete;Pending

The combo box Bound Column and Column Count are both 1.

Not sure why you specify typing a value into a combo box. You can do that,
but typically the idea with a combo box is that you select a value. If Auto
Expand is set to Yes you should be able to start typing, and a word will
appear when what you have typed matches an entry on the list. In this case,
typing "C" should display the word "Complete", after which you can press Tab
or Enter, or click elsewhere on the form.

I don't have Access 2007 in front of me, but I believe the procedure is at
least similar to what I have written here.

Mort wrote:
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table tblStats.
I can not figure out how to accomplish this. Please help

Mortimer


--
Message posted via http://www.accessmonster.com

  #4  
Old April 23rd, 2010, 06:46 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Beginner with ComboBox

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer



  #5  
Old April 23rd, 2010, 07:46 PM posted to microsoft.public.access.gettingstarted
Mort
external usenet poster
 
Posts: 14
Default Beginner with ComboBox

Thank you. I can attest to that fact and am proceding very cautiously.

The first was rather simple, four tables and I was given enough time so that
I could understand what was being written about on the 1NF,2NF, and 3NF.
Customers, Products, Orders, and Shipments tables (no partial shipments so
Primary Keys and Joins were not to hard to figure out).
This one is much more difficult - I am being approached to do it after my
initial success. I have registered for Access training at a Microsoft
certified training company for a three day instructor led class, but it is 7
weeks into the future.

"Jeff Boyce" wrote:

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer



.

  #6  
Old April 23rd, 2010, 08:20 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Beginner with ComboBox

Depending on who you're trained by, you will probably get (only) intense
focus on #2, and some focus on #1. I'll be curious (here) to hear about it
afterwards...

Good luck!

Jeff

"Mort" wrote in message
...
Thank you. I can attest to that fact and am proceding very cautiously.

The first was rather simple, four tables and I was given enough time so
that
I could understand what was being written about on the 1NF,2NF, and 3NF.
Customers, Products, Orders, and Shipments tables (no partial shipments so
Primary Keys and Joins were not to hard to figure out).
This one is much more difficult - I am being approached to do it after my
initial success. I have registered for Access training at a Microsoft
certified training company for a three day instructor led class, but it
is 7
weeks into the future.

"Jeff Boyce" wrote:

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for
the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer



.



  #7  
Old April 23rd, 2010, 09:04 PM posted to microsoft.public.access.gettingstarted
Mort
external usenet poster
 
Posts: 14
Default Beginner with ComboBox

I will post back on this thread after the training is concluded, late June.

"Jeff Boyce" wrote:

Depending on who you're trained by, you will probably get (only) intense
focus on #2, and some focus on #1. I'll be curious (here) to hear about it
afterwards...

Good luck!

Jeff

"Mort" wrote in message
...
Thank you. I can attest to that fact and am proceding very cautiously.

The first was rather simple, four tables and I was given enough time so
that
I could understand what was being written about on the 1NF,2NF, and 3NF.
Customers, Products, Orders, and Shipments tables (no partial shipments so
Primary Keys and Joins were not to hard to figure out).
This one is much more difficult - I am being approached to do it after my
initial success. I have registered for Access training at a Microsoft
certified training company for a three day instructor led class, but it
is 7
weeks into the future.

"Jeff Boyce" wrote:

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for
the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer


.



.

  #8  
Old April 23rd, 2010, 11:22 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Beginner with ComboBox

My apologies, I had also posted a response today that listed 4 learning
curves most folks need to surmount to build Access apps that get used.

My previous comment would have made more sense if I had listed the 4 curves!

1) relational database design - Access looks for data organized this way
2) Access tricks -- classes tend to focus here, not so much on #1
3) Graphical User Interface design -- if it isn't easy to understand and
use, folks won't
4) Application development -- hey! would you try to build a house without
knowing how the process goes?!

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
...
I will post back on this thread after the training is concluded, late June.

"Jeff Boyce" wrote:

Depending on who you're trained by, you will probably get (only) intense
focus on #2, and some focus on #1. I'll be curious (here) to hear about
it
afterwards...

Good luck!

Jeff

"Mort" wrote in message
...
Thank you. I can attest to that fact and am proceding very cautiously.

The first was rather simple, four tables and I was given enough time so
that
I could understand what was being written about on the 1NF,2NF, and
3NF.
Customers, Products, Orders, and Shipments tables (no partial shipments
so
Primary Keys and Joins were not to hard to figure out).
This one is much more difficult - I am being approached to do it after
my
initial success. I have registered for Access training at a Microsoft
certified training company for a three day instructor led class, but
it
is 7
weeks into the future.

"Jeff Boyce" wrote:

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service
herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected
for
the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer


.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.