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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating a Form



 
 
Thread Tools Display Modes
  #1  
Old July 31st, 2009, 08:55 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Creating a Form

Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I make the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a form I
dont want to see 1 or 5 I would like to see the type/text behind it like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not text.

How can I go around that?
Thank You.
  #2  
Old July 31st, 2009, 09:12 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Creating a Form

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a form
I
dont want to see 1 or 5 I would like to see the type/text behind it like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.



  #3  
Old August 3rd, 2009, 02:20 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Creating a Form

Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a form
I
dont want to see 1 or 5 I would like to see the type/text behind it like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.




  #4  
Old August 3rd, 2009, 04:31 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Creating a Form

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to 1. The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a
form
I
dont want to see 1 or 5 I would like to see the type/text behind it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.






  #5  
Old August 3rd, 2009, 05:25 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Creating a Form

The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType] "
Which gives me the list in combo box BUT I cant chose any, its wont let me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to 1. The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a
form
I
dont want to see 1 or 5 I would like to see the type/text behind it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.






  #6  
Old August 3rd, 2009, 05:56 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Creating a Form

Doing it they way you did will not allow you to make and changes to the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee. Please
set it up the way I said in my first reply with the 2 columns...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType] "
Which gives me the list in combo box BUT I cant chose any, its wont let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to 1.
The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on
a
form
I
dont want to see 1 or 5 I would like to see the type/text behind it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I select
it
nothing happens since cCrewTypeID is set to accept only numbers and
not
text.

How can I go around that?
Thank You.








  #7  
Old August 3rd, 2009, 06:34 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Creating a Form

Still cant get it to work,

here come the screen shot...
http://img262.imageshack.us/img262/470/form1.png

Gina: Going back to my original post about the design of tables and the
relationship. I posted a screen shot of the corrections I made. If you dont
mind taking a last look at it, its on 2nd page of this forum.
Thank you,

"Gina Whipp" wrote:

Doing it they way you did will not allow you to make and changes to the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee. Please
set it up the way I said in my first reply with the 2 columns...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType] "
Which gives me the list in combo box BUT I cant chose any, its wont let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to 1.
The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on
a
form
I
dont want to see 1 or 5 I would like to see the type/text behind it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I select
it
nothing happens since cCrewTypeID is set to accept only numbers and
not
text.

How can I go around that?
Thank You.









  #8  
Old August 3rd, 2009, 06:59 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Creating a Form

1. Where it says Row Source just put tblCrewType
2. Return the Control Source fo your Combo Box to ctCrewTypeID

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Still cant get it to work,

here come the screen shot...
http://img262.imageshack.us/img262/470/form1.png

Gina: Going back to my original post about the design of tables and the
relationship. I posted a screen shot of the corrections I made. If you
dont
mind taking a last look at it, its on 2nd page of this forum.
Thank you,

"Gina Whipp" wrote:

Doing it they way you did will not allow you to make and changes to the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee. Please
set it up the way I said in my first reply with the 2 columns...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType] "
Which gives me the list in combo box BUT I cant chose any, its wont let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to
1.
The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can
I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT
on
a
form
I
dont want to see 1 or 5 I would like to see the type/text behind
it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I
select
it
nothing happens since cCrewTypeID is set to accept only numbers
and
not
text.

How can I go around that?
Thank You.











  #9  
Old August 4th, 2009, 02:57 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Creating a Form

Thank you Gina.

Is there a way to have a box next to it that would display the actual name?
First box would be the autoNumber assigned for the specific name and next to
it would be a box that would display the name.

Thanks

"Gina Whipp" wrote:

1. Where it says Row Source just put tblCrewType
2. Return the Control Source fo your Combo Box to ctCrewTypeID

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Still cant get it to work,

here come the screen shot...
http://img262.imageshack.us/img262/470/form1.png

Gina: Going back to my original post about the design of tables and the
relationship. I posted a screen shot of the corrections I made. If you
dont
mind taking a last look at it, its on 2nd page of this forum.
Thank you,

"Gina Whipp" wrote:

Doing it they way you did will not allow you to make and changes to the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee. Please
set it up the way I said in my first reply with the 2 columns...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType] "
Which gives me the list in combo box BUT I cant chose any, its wont let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box to
1.
The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can
I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT
on
a
form
I
dont want to see 1 or 5 I would like to see the type/text behind
it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I
select
it
nothing happens since cCrewTypeID is set to accept only numbers
and
not
text.

How can I go around that?
Thank You.












  #10  
Old August 4th, 2009, 04:37 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Creating a Form

Damian,

You CAN do it like that but it begs the question why you would WANT to do it
like that? Normally, showing the PK in a table is not needed or neccessary.
The End-User should never even see it, nor should they care what the
Autonumber is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Thank you Gina.

Is there a way to have a box next to it that would display the actual
name?
First box would be the autoNumber assigned for the specific name and next
to
it would be a box that would display the name.

Thanks

"Gina Whipp" wrote:

1. Where it says Row Source just put tblCrewType
2. Return the Control Source fo your Combo Box to ctCrewTypeID

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Still cant get it to work,

here come the screen shot...
http://img262.imageshack.us/img262/470/form1.png

Gina: Going back to my original post about the design of tables and the
relationship. I posted a screen shot of the corrections I made. If you
dont
mind taking a last look at it, its on 2nd page of this forum.
Thank you,

"Gina Whipp" wrote:

Doing it they way you did will not allow you to make and changes to
the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee.
Please
set it up the way I said in my first reply with the 2 columns...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
The control Source was cCrewTypeID.
I played around with it and changed it to "= [TblCrewType]![ctType]
"
Which gives me the list in combo box BUT I cant chose any, its wont
let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb Box
to
1.
The
second thing is what is the Control Source of the Combo Box?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW
can
I
make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType
BUT
on
a
form
I
dont want to see 1 or 5 I would like to see the type/text
behind
it
like
Carpenter.

I tried look up combo box and I can see the ctType but when I
select
it
nothing happens since cCrewTypeID is set to accept only
numbers
and
not
text.

How can I go around that?
Thank You.














 




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 02:07 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.