| | |
|
|
|
Is there a way to duplicate a field in a form? |
|---|
| message from =?Utf-8?B?TG93ZW5uYQ==?= on 25 May 2004 |
Could anyone please let me know if there is a way to create a button (?) to duplicate data? To explain: I'm about to enter large amounts of data for horse show entries and some horses enter more than one class. It gets complicated if I try and explain what I'm doing but if anyone has a vague idea what I'm trying to do - please help!
From,
A very confused Cornish woman!
|
| John Vinson replied to =?Utf-8?B?TG93ZW5uYQ==?= on 27 May 2004 |
Well, if your tables are properly normalized you should not need to
enter any horse information twice; you would have a table of Horses
and each animal would be entered into it only once.
It is possible to write VBA code to duplicate a record on a form - but
this should rarely be needed!
Two suggestions:
- Ctrl-' will "ditto" the previous record's entry in each field.
- If you do decide to do it programmatically, there are several ways
to do it; an Append query is probably simplest. The details will
depend on your form and table structure, but you'ld save the current
record and then execute an Append query using the Primary Key of the
just saved record as a criterion.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Jeff Boyce replied to =?Utf-8?B?TG93ZW5uYQ==?= on 25 May 2004 |
Lowenna
I'll encourage you to spend a bit more time defining, then describing. If
you offer a vague idea of the issue you are trying to resolve, won't that
mean you'll only get a vague suggestion? <g>
What is your underlying data structure? This will make a difference in how
(or even "if") you "duplicate data". By the way, Access can (and probably
should) be set up so that data duplication is unnecessary.
|
| Joseph Meehan replied to =?Utf-8?B?TG93ZW5uYQ==?= on 25 May 2004 |
I am a little confused as to exactly what you are doing.
Good data design generally means you should not need to duplicate data.
You usually should not be entering the same data over and over.
Now one common exception to the above may occur when you want to copy
the data from a list or from the prior record.
If you need to add data from a list, look up Drop Down Box in the help
file where you are in the form design view. It will provide a lot of good
help.
If you want to use the data from the prior record then the usual way is
to use Cont " ' " Hold down the Control key while pressing the quote key.
There are many other ways of doing like things, but we have no idea what
might be best for you because we are not at all sure exactly what you need
to do.
|
|
Archived message: Is there a way to duplicate a field in a form? (MS Access Database)
