I have generated a database where I often need to enter the same address for
different records. is there any way to do this as an auto-fill or linked
table so hat i don't have to retype the address each time?

GC78 wrote:
>I have generated a database where I often need to enter the same
> address for different records. is there any way to do this as an
> auto-fill or linked table so hat i don't have to retype the address
> each time?

Let's stop a second. "I often need to enter the same address for
different records." That always makes me thing the problem is table
normalization. Is your table structure properly normalized?

--
Joseph Meehan

Dia duit

If a particular address is extremely common, you could simply set the Default
property of the field to that address. This is done in design view; simply
set the Default Value property to "1152 Highland Court", or whatever the
address actually is.

Alternatively, you could simply use Copy and Paste. If you want to copy and
paste a lot of data, you could export your table to Excel and work with your
data there, then re-import your table.

-Chris

"GC78" wrote:

> I have generated a database where I often need to enter the same address for
> different records. is there any way to do this as an auto-fill or linked
> table so hat i don't have to retype the address each time?
>
>

On Thu, 2 Mar 2006 11:06:27 -0800, "GC78"
<(E-Mail Removed)> wrote:

>I have generated a database where I often need to enter the same address for
>different records. is there any way to do this as an auto-fill or linked
>table so hat i don't have to retype the address each time?
>

Typing ctrl-' will copy down the value from the previously entered
record.

Without knowing anything about your data or your table structure, I
can't really suggest anything specific, but if your table has many
repeated fields, then a normalized design with one record per address
would indeed be helpful.

John W. Vinson[MVP]

Let me explain more clearly. I work in a lab where we send samples to be
tested in other labs. I am entering one record for each test done ("test" is
the primary key), and the address/contact information for the lab where it is
to be sent. However, some labs do more than one test, so I am having to
re-enter their addresses for each test that they do. I am wondering if there
is some sort of auto-complete function, as in Excel, so that once I start
typing the address it will be automatically completed; or whether there is
some other way to do this. Thanks...

"Joseph Meehan" wrote:

> GC78 wrote:
> >I have generated a database where I often need to enter the same
> > address for different records. is there any way to do this as an
> > auto-fill or linked table so hat i don't have to retype the address
> > each time?
>
> Let's stop a second. "I often need to enter the same address for
> different records." That always makes me thing the problem is table
> normalization. Is your table structure properly normalized?
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

Let me explain more clearly. I work in a lab where we send samples to be
tested in other labs. I am entering one record for each test done ("test" is
the primary key), and the address/contact information for the lab where it is
to be sent. However, some labs do more than one test, so I am having to
re-enter their addresses for each test that they do. I am wondering if there
is some sort of auto-complete function, as in Excel, so that once I start
typing the address it will be automatically completed; or whether there is
some other way to do this. Thanks...

"John Vinson" wrote:

> On Thu, 2 Mar 2006 11:06:27 -0800, "GC78"
> <(E-Mail Removed)> wrote:
>
> >I have generated a database where I often need to enter the same address for
> >different records. is there any way to do this as an auto-fill or linked
> >table so hat i don't have to retype the address each time?
> >
>
> Typing ctrl-' will copy down the value from the previously entered
> record.
>
> Without knowing anything about your data or your table structure, I
> can't really suggest anything specific, but if your table has many
> repeated fields, then a normalized design with one record per address
> would indeed be helpful.
>
> John W. Vinson[MVP]
>

On Thu, 2 Mar 2006 14:09:26 -0800, "GC78"
<(E-Mail Removed)> wrote:

>Let me explain more clearly. I work in a lab where we send samples to be
>tested in other labs. I am entering one record for each test done ("test" is
>the primary key), and the address/contact information for the lab where it is
>to be sent. However, some labs do more than one test, so I am having to
>re-enter their addresses for each test that they do. I am wondering if there
>is some sort of auto-complete function, as in Excel, so that once I start
>typing the address it will be automatically completed; or whether there is
>some other way to do this. Thanks...

Then you should certainly have a separate table of Labs, and your test
table should NOT contain any address information for the labs.
Instead, it should contain only the LabID, a link to the primary key
of the Labs table. In your Form you would use a combo box based on the
Labs table to select which lab; your Reports would be based on a query
joining the test table to the Labs table, picking up the lab address
fields from the Labs table and the test-specific information from the
tests table.

You may be making the common assumption that you need all information
in the same table. *You don't*. You can and will use Queries joining
tables to produce reports.

John W. Vinson[MVP]

GC78 wrote:
> Let me explain more clearly. I work in a lab where we send samples to
> be tested in other labs. I am entering one record for each test done
> ("test" is the primary key), and the address/contact information for
> the lab where it is to be sent. However, some labs do more than one
> test, so I am having to re-enter their addresses for each test that
> they do. I am wondering if there is some sort of auto-complete
> function, as in Excel, so that once I start typing the address it
> will be automatically completed; or whether there is some other way
> to do this. Thanks...

I see John has already responded. You have a test table, now you need a
lab table. Each lab will have one entry and you just link to the lab not
repeat all the information. Access likes it that way. This is not Excel
you know.



>
> "Joseph Meehan" wrote:
>
>> GC78 wrote:
>> >I have generated a database where I often need to enter the same
>> > address for different records. is there any way to do this as an
>> > auto-fill or linked table so hat i don't have to retype the address
>> > each time?
>>
>> Let's stop a second. "I often need to enter the same address for
>> different records." That always makes me thing the problem is table
>> normalization. Is your table structure properly normalized?
>>
>> --
>> Joseph Meehan
>>
>> Dia duit

--
Joseph Meehan

Dia duit