How can I attach a spreadsheet to one of my records in the database?
--
Janice

Hello Janice,

If you want to attach anything other than typed text to a record you will
need an extra field

Go to the design view of the table and add another field
Choose OLE Object as the data type
Choose to view the datasheet - you will see an empty cell.
Right click the cell and choose Insert Object
Choose From File + Browse
Find the file you want and choose OK
Tick the Link box if you want an up-to-date spreadsheet to be attached

If you have any problems with this please repost

Hope this helps

Judith


"Janice" wrote:

> How can I attach a spreadsheet to one of my records in the database?
> --
> Janice

Thank you Judith. Can I attach a spreadsheet to a record in a form without
it showing up in all the records?
--
Janice


"JudithJubilee" wrote:

> Hello Janice,
>
> If you want to attach anything other than typed text to a record you will
> need an extra field
>
> Go to the design view of the table and add another field
> Choose OLE Object as the data type
> Choose to view the datasheet - you will see an empty cell.
> Right click the cell and choose Insert Object
> Choose From File + Browse
> Find the file you want and choose OK
> Tick the Link box if you want an up-to-date spreadsheet to be attached
>
> If you have any problems with this please repost
>
> Hope this helps
>
> Judith
>
>
> "Janice" wrote:
>
> > How can I attach a spreadsheet to one of my records in the database?
> > --
> > Janice

I would like to know this too. Thanks.

"Janice" wrote:

> Thank you Judith. Can I attach a spreadsheet to a record in a form without
> it showing up in all the records?
> --
> Janice
>
>
> "JudithJubilee" wrote:
>
> > Hello Janice,
> >
> > If you want to attach anything other than typed text to a record you will
> > need an extra field
> >
> > Go to the design view of the table and add another field
> > Choose OLE Object as the data type
> > Choose to view the datasheet - you will see an empty cell.
> > Right click the cell and choose Insert Object
> > Choose From File + Browse
> > Find the file you want and choose OK
> > Tick the Link box if you want an up-to-date spreadsheet to be attached
> >
> > If you have any problems with this please repost
> >
> > Hope this helps
> >
> > Judith
> >
> >
> > "Janice" wrote:
> >
> > > How can I attach a spreadsheet to one of my records in the database?
> > > --
> > > Janice

There are two ways:

In your Access database, in Tables, go to Datasheet View and go to Insert in
your toolbar up above and select Hyperlink Column or, in Tables, go to Design
View and select the field that you want to have spreadsheets attached to. In
the Data Type column, select Hyperlink from the drop down arrow. While in
Datasheet View, select the record that you want to attach a spreadsheet to.
Go into your hyperlink field/column and either select Insert Hyperlink from
your toolbar up above or right click and select Hyperlink, Edit Hyperlink.
It is self-explanatory from there. The only thing to remember is that this
field/column will be a hyperlink field. You will not be able to enter any
other data in it besides hyperlinks.

Let me know if you need any help.

Janice


"Janice" wrote:

> How can I attach a spreadsheet to one of my records in the database?
> --
> Janice