UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Using An Attachment As A Template, Access 2010    
 
   
sociotard
post Oct 4 2017, 11:35 AM
Post#1



Posts: 27
Joined: 10-March 16



Is it possible to click a button that opens an excel file stored as an attachment in a table, then proceeds to fill it with queried data? The concept would be to use the attachment file as a template to generate reports in the form of Excel documents.

I need to generate excel files to send in as reports. Until now, they've all been simple enough to generate with "New Excel.Application". The one I have to make now, though, is very complicated, with lots of array calculations and references. I'm concerned it might take a long time to replicate programmatically. I thought I could maybe make one with no data and use it as a template. Has anyone tried this?
Go to the top of the page
 
DanielPineault
post Oct 4 2017, 11:44 AM
Post#2


UtterAccess VIP
Posts: 5,455
Joined: 30-June 11



I've always found it easier to create a folder where the BE is located to house such templates.

Regardless, to answer your question, yes you can. First you need to save the attachment locally and then you can manipulate it as you would any other file.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
DanielPineault
post Oct 4 2017, 12:22 PM
Post#3


UtterAccess VIP
Posts: 5,455
Joined: 30-June 11



Look over the attached demo I quickly put together to illustrate to principle upon which you can build on.
Attached File(s)
Attached File  AttachmentDemo.zip ( 42.92K )Number of downloads: 7
 

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
sociotard
post Oct 21 2017, 02:08 PM
Post#4



Posts: 27
Joined: 10-March 16



I got busy and didn't thank you. But thank you, this was so helpful.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 11:47 AM