Discussion:
long integers
(too old to reply)
dennist685
2007-04-22 10:10:01 UTC
Permalink
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.

Can somebody help?

dennist
Ken Snell (MVP)
2007-04-22 11:57:07 UTC
Permalink
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.
Can somebody help?
dennist
dennist685
2007-04-22 12:34:03 UTC
Permalink
thanks, but I can't find the field size property anywhere

dennist
Post by Ken Snell (MVP)
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.
Can somebody help?
dennist
tina
2007-04-22 14:31:51 UTC
Permalink
open the table in Design view. click on the field that has a Number data
type. look at the bottom half of the window where the Field Properties are
listed. the first property on the General tab is Field Size.

hth
Post by dennist685
thanks, but I can't find the field size property anywhere
dennist
Post by Ken Snell (MVP)
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.
Can somebody help?
dennist
dennist685
2007-04-24 06:12:01 UTC
Permalink
I find no diagram view when reating a table. Where is it?

dennist
Post by tina
open the table in Design view. click on the field that has a Number data
type. look at the bottom half of the window where the Field Properties are
listed. the first property on the General tab is Field Size.
hth
Post by dennist685
thanks, but I can't find the field size property anywhere
dennist
Post by Ken Snell (MVP)
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.
Can somebody help?
dennist
tina
2007-04-24 06:34:55 UTC
Permalink
i didn't say "diagram", hon, i said Design view. i don't have Acess 2007,
but i'd guess it's similar enough to prior versions that, if you open the
table in Datasheet view, you'll find a toolbar button or menu option to take
you to Design view.

hth
Post by dennist685
I find no diagram view when reating a table. Where is it?
dennist
Post by tina
open the table in Design view. click on the field that has a Number data
type. look at the bottom half of the window where the Field Properties are
listed. the first property on the General tab is Field Size.
hth
Post by dennist685
thanks, but I can't find the field size property anywhere
dennist
Post by Ken Snell (MVP)
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a
field, a
Post by dennist685
Post by tina
Post by dennist685
Post by Ken Snell (MVP)
Post by dennist685
foreign
key for example. Just number.
Can somebody help?
dennist
tina
2007-04-22 14:32:56 UTC
Permalink
oops, sorry, i didn't notice that you're working in A2007. its' Design view
may very well be different than in previous versions of Access.
Post by dennist685
thanks, but I can't find the field size property anywhere
dennist
Post by Ken Snell (MVP)
It's in the Field Size property.
--
Ken Snell
<MS ACCESS MVP>
Post by dennist685
In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.
Can somebody help?
dennist
Ken Snell (MVP)
2007-04-22 17:33:40 UTC
Permalink
Post by tina
oops, sorry, i didn't notice that you're working in A2007. its' Design view
may very well be different than in previous versions of Access.
Not to my knowledge -- it should be same as in previous versions.
--
Ken Snell
<MS ACCESS MVP>
tina
2007-04-22 23:28:52 UTC
Permalink
whew...skated on that one! <g>
Post by Ken Snell (MVP)
Post by tina
oops, sorry, i didn't notice that you're working in A2007. its' Design view
may very well be different than in previous versions of Access.
Not to my knowledge -- it should be same as in previous versions.
--
Ken Snell
<MS ACCESS MVP>
Loading...