Creating excel worksheet for individual records...

[Rico]

I want to create a table with fields such as DATE: SHIFT:
CAST LOT #: PART TYPE:, etc. The last field I want to be
an excel worksheet. I know I can set the field as an OLE
object and insert one that way but what I need to do is
insert the same template worksheet for each record and
when I open the form to enter information I want the
worksheet to be ready to edit and then when I create a new
record I want it to be the template again so I can enter
different information for a different record. Does that
make sense? Not sure if its possible. What's possible
isn't always what I want and what's impossible is always
what I need. Thanks in advance for your help.

Rico

 

[Tim Ferguson]

The last field I want to be
an excel worksheet. I know I can set the field as an OLE
object and insert one that way but what I need to do is

It's possible but using Access/ Jet it's not a very good idea. The OLE data
type adds huge amounts of overhead, so a database rapidly goes oversize
even if the actual object you add are quite small.

The recommended method is to store the files as files, and keep the path-
and file-name in the database. In your case, there is path-, file- and
worksheet names to keep track of, but there is sample code in Dev Ashish's
site <http://www.mvps.org/access/> and in Steve Lebans
<http://www.lebans.com>

Hope that helps


Tim F