I have downloaded the book collection database but i would like to alter it a
little.

When i am entering the details of book on the second box down you can click
on the box and enter the books topic IE crime, romance, thriller and so onand
then when you enter the next book you have only to enter the first letter and
it is entered automaticly.

My question is how do i copy this feature as i would like to have another so
i can easley enter where i got the books from without having to type all the
infomation in.

Hope someone can help please

The feature is called Auto Expand and it is the default property of a
combobox. You find it on the Data tab of the property sheet for the
combobox.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"sam" <(E-Mail Removed)> wrote in message
news:68395FBB-2DA3-4472-B635-(E-Mail Removed)...
>I have downloaded the book collection database but i would like to alter it
>a
> little.
>
> When i am entering the details of book on the second box down you can
> click
> on the box and enter the books topic IE crime, romance, thriller and so
> onand
> then when you enter the next book you have only to enter the first letter
> and
> it is entered automaticly.
>
> My question is how do i copy this feature as i would like to have another
> so
> i can easley enter where i got the books from without having to type all
> the
> infomation in.
>
> Hope someone can help please

One of the uses of the templates is to download them and then become
familiar with them and then to bring up various objects of interest,
change to design mode and trace your way around the things of
interest.

If you have never read a book or taken a few tutorials on Access then
you're going to find the learning curve using that approach to be very
steep.

HTH
--
-Larry-
--

"sam" <(E-Mail Removed)> wrote in message
news:68395FBB-2DA3-4472-B635-(E-Mail Removed)...
> I have downloaded the book collection database but i would like to
alter it a
> little.
>
> When i am entering the details of book on the second box down you
can click
> on the box and enter the books topic IE crime, romance, thriller and
so onand
> then when you enter the next book you have only to enter the first
letter and
> it is entered automaticly.
>
> My question is how do i copy this feature as i would like to have
another so
> i can easley enter where i got the books from without having to type
all the
> infomation in.
>
> Hope someone can help please

Thanks guys i will have a look at the auto expand property

"sam" wrote:

> I have downloaded the book collection database but i would like to alter it a
> little.
>
> When i am entering the details of book on the second box down you can click
> on the box and enter the books topic IE crime, romance, thriller and so onand
> then when you enter the next book you have only to enter the first letter and
> it is entered automaticly.
>
> My question is how do i copy this feature as i would like to have another so
> i can easley enter where i got the books from without having to type all the
> infomation in.
>
> Hope someone can help please

Hi guys i have had a look at the above surgestion and i am still unable to
get it to work. i can copy the item but it will not auto expand when i click
on it i can select the items that are already there but i am unable to add to
the list. i have sreated a new coloumn in the datasbase table but i cannot
link the new combibox the the table

anybody got any ideas i is this a step to far for a relitive novice

regards

"sam" wrote:

> Thanks guys i will have a look at the auto expand property
>
> "sam" wrote:
>
> > I have downloaded the book collection database but i would like to alter it a
> > little.
> >
> > When i am entering the details of book on the second box down you can click
> > on the box and enter the books topic IE crime, romance, thriller and so onand
> > then when you enter the next book you have only to enter the first letter and
> > it is entered automaticly.
> >
> > My question is how do i copy this feature as i would like to have another so
> > i can easley enter where i got the books from without having to type all the
> > infomation in.
> >
> > Hope someone can help please

Autoexpand is not something that happens when a control is clicked.
It is a property that you can set on a combobox in design mode. With
Autoexpand turned on then back in run mode, starting to type a entry
into the combobox will cause it to try to find the first occurrence of
an item beginning with the letters you have typed.

Your coverage of the ground will be accelerated by getting a good
beginning book on Access.

I also recommend lurking

microsoft.public.access.gettingstarted
microsoft.public.access.tablesdesign

www.mvps.org/access

HTH
--
-Larry-
--

"sam" <(E-Mail Removed)> wrote in message
news:8278FA9A-42E4-4342-9CBA-(E-Mail Removed)...
> Hi guys i have had a look at the above surgestion and i am still
unable to
> get it to work. i can copy the item but it will not auto expand when
i click
> on it i can select the items that are already there but i am unable
to add to
> the list. i have sreated a new coloumn in the datasbase table but i
cannot
> link the new combibox the the table
>
> anybody got any ideas i is this a step to far for a relitive novice
>
> regards
>
> "sam" wrote:
>
> > Thanks guys i will have a look at the auto expand property
> >
> > "sam" wrote:
> >
> > > I have downloaded the book collection database but i would like
to alter it a
> > > little.
> > >
> > > When i am entering the details of book on the second box down
you can click
> > > on the box and enter the books topic IE crime, romance, thriller
and so onand
> > > then when you enter the next book you have only to enter the
first letter and
> > > it is entered automaticly.
> > >
> > > My question is how do i copy this feature as i would like to
have another so
> > > i can easley enter where i got the books from without having to
type all the
> > > infomation in.
> > >
> > > Hope someone can help please

Thanks for the tip i will not give up i will master this project. Thank you
for your help

"Larry Daugherty" wrote:

> Autoexpand is not something that happens when a control is clicked.
> It is a property that you can set on a combobox in design mode. With
> Autoexpand turned on then back in run mode, starting to type a entry
> into the combobox will cause it to try to find the first occurrence of
> an item beginning with the letters you have typed.
>
> Your coverage of the ground will be accelerated by getting a good
> beginning book on Access.
>
> I also recommend lurking
>
> microsoft.public.access.gettingstarted
> microsoft.public.access.tablesdesign
>
> www.mvps.org/access
>
> HTH
> --
> -Larry-
> --
>
> "sam" <(E-Mail Removed)> wrote in message
> news:8278FA9A-42E4-4342-9CBA-(E-Mail Removed)...
> > Hi guys i have had a look at the above surgestion and i am still
> unable to
> > get it to work. i can copy the item but it will not auto expand when
> i click
> > on it i can select the items that are already there but i am unable
> to add to
> > the list. i have sreated a new coloumn in the datasbase table but i
> cannot
> > link the new combibox the the table
> >
> > anybody got any ideas i is this a step to far for a relitive novice
> >
> > regards
> >
> > "sam" wrote:
> >
> > > Thanks guys i will have a look at the auto expand property
> > >
> > > "sam" wrote:
> > >
> > > > I have downloaded the book collection database but i would like
> to alter it a
> > > > little.
> > > >
> > > > When i am entering the details of book on the second box down
> you can click
> > > > on the box and enter the books topic IE crime, romance, thriller
> and so onand
> > > > then when you enter the next book you have only to enter the
> first letter and
> > > > it is entered automaticly.
> > > >
> > > > My question is how do i copy this feature as i would like to
> have another so
> > > > i can easley enter where i got the books from without having to
> type all the
> > > > infomation in.
> > > >
> > > > Hope someone can help please
>
>
>