Insert Excel object in the form

[Anauaton]

Hi,

My forms are composed in tabs; I would like to insert a third one on which I want to input and Excel object. I already managed to insert an Excel object but I do not know the difference between linked / unbound object and, once inserted, either I can't edit it (under form view) or if I can, the change is repeated to all other records using the same form.

Basically I need this Excel object to be unique to the record edited, a sort of "memo" field but instead of free text it's a spreadsheet with cells. I do not need the data inside the spreadsheet to be used for other records or to be kept in the database, except as "attached" to the edited record.

Can you help?

Thank you!

 

[highandwild]

What do you expect users to use the spreadsheet for?

Will the spreadsheets be used outside of the database?

 

[Anauaton]

Hi,

I am the user! I need this spreadsheet to attach comments specific to the record, in the form of figures (ie, financial information, ratios, other specific to the record). I do not need a framework, ie the data input in the cell will change from record to record, following different models if required. For instance, if I want to input sales data for 5 years for the record A, I will do a specific table for the record A; maybe I will want to input sales data and profits before tax for the record B, then I will build two tables in the spreadsheet area of the record B. It should remain totally unbound / free for all requirement specific to the records.

And I do not intend to use the spreadsheet outside of Access, nor do I intend to import anything from outside to these spreadsheets.

Thanks for your help.

 

[highandwild]

Put these two files in the same folder and open the Access form.

Thi form is not bound to a table but that would be easy.

Under the button you would need to create a new workbook before running the existing code if it does not already exist.

You will need a logical naming convention for the workbooks probably based upon the record ID.

Is this what you are after?

 

[Anauaton]

Yes that is quite helpful already; but as I am using Access 2007 and that I can put attachments inside the database, is there a way to avoid the external attachement? Ideally, as I have already 450 records in my database, I would like to avoid ending up with 450 excel files in my folder... and I target 1500 records overall.

I was thinking, as I already attached files to many records (I have an attachment field at this effect), that are then stored inside the database, like pdf articles for exemple, I could do the same with an excel file; when I need to edit I just open, edit, save then close the attachement. But it would really be beautiful if I could have it as an object displayed in a box, instead of having it attached as a separate file, since I will not need a big workbook, maybe just a spreadsheet of 15 rows * 7 columns visible on my third tab would be just enough.

What do you think?

Thanks

 

[highandwild]

Does this post and links help?

http://www.access-programmers.co.uk/forums/showthread.php?t=165510