How can I insert into an Access form data that is regularly used

[Guest]

 

[Joseph Meehan]

We are going to need a lot more information. Please add it in the
content area and don't try to fit it all in the Subject line.

 

[John Vinson]

On Tue, 6 Sep 2005 02:18:01 -0700, "Wussell"

It's considered polite to ask your question in the text area, not just
the subject line; when you do, please include enough information that
one of us who volunteer here might be able to help. We're people, not
a search engine.

My GUESS is that you'll want to set the Default Value property of some
controls on your form, but without more background it's hard to be
sure.

John W. Vinson[MVP]

 

[Guest]

I apologise for not adhering to convention, be gentle with me this is my
first time.

My job requires me to make entries into an Access database form, many of
which are repititive.
I have tried using the clipboard in Word and copying across but
unfortunately its an old version and the clipboard will onlt take one item.
Is there a way I can have the entries held in memory so that I can input
with a keystroke.

Regards,

Russell

 

[Guest]

I apologise for not adhering to convention, be gentle with me this is my
first time.

My job requires me to make entries into an Access database form, many of
which are repititive.
I have tried using the clipboard in Word and copying across but
unfortunately its an old version and the clipboard will onlt take one item.
Is there a way I can have the entries held in memory so that I can input
with a keystroke.

Regards,

Russell

 

[Joseph Meehan]

I apologise for not adhering to convention, be gentle with me this is
my first time.

My job requires me to make entries into an Access database form, many
of which are repititive.
I have tried using the clipboard in Word and copying across but
unfortunately its an old version and the clipboard will onlt take one
item. Is there a way I can have the entries held in memory so that I
can input with a keystroke.

Regards,

Russell

No problem.

I am still not 100% sure I understand your whole problem, but I can make
a guess or two.

First thing that is likely to help is the Control " ' " key. That is
holding down the Control key while you press the single quote key. That
copies the data from the prior record so if you are entering a list of
records and three of the fields tend to repeat, you can use this to fill in
those three fields (one at a time) with the data from the prior record.

There are third party add on's that can extend the Window's clipboard
feature to allow a number of clips.

Now I will make one other suggestions. If there is a lot of repeated
information, especially if it is repeating information in more than one
field, you may be the victim of a poorly designed table. It may help in
this and other issues to split the table. This is a design change to the
database and should not be attempted until you know what you are doing, but
it can be very helpful. The procedure is call normalization and information
is available in the Access help file.