在Access窗体上显示和填充Excel模板 [英] Display and populate an Excel Template on an Access form

问题描述

我的公司有许多资源可用于许多项目。 我希望展示（作为概念证明）拥有资源跟踪器的价值，同时不再创建数百个电子表格。 最简单的方法（因为我不知道SharePoint，Excel Services，PerformancePoint Services，Project Server等）是将一些数据加载到Acess中，然后演示资源跟踪器/图表等的仪表板。

My company has many resources working on many projects.  I want to show (as a proof of concept) the value of having a resource tracker, and simultanelously moving away from creating hundreds of spreadsheets.  Simplest way of doing this (as I don't know SharePoint, Excel Services, PerformancePoint Services, Project Server etc. well enough) is to load some data into Acesss, and then demonstrate the dashboards of resource trackers/charts etc.

本质上我想要的是一个显示冻结标题（多行标题）的访问表单和一个基本信息的冻结左窗格，多列跟踪信息可滚动。 花了我十分钟时间作为excel模板敲门。 
但我不想为每个项目单独的excel文件（从静态文档堆到MIS就是重点）。 在访问形式中重新设计标题，冷冻窗格等可能是可能的，但颈部真的很痛。 
真的应该是使用表单上显示的一个Excel模板的简单方法，在运行时，根据选择的任何项目（主/子组合 - 在表格中填充表中的数据）简单的一点）。

In essence what I want is an access form that displays frozen headings (multiple rows of headings) and a frozen left pane of essential info, with the multiple columns of tracking info scrollable.  Took me ten minutes to knock up as an excel template.  But I don't want a separate excel file for each project (moving away from heaps of static documents to a MIS is the whole point).  Redesigning headings, frozen panes etc. in an access form is probable possible but a real pain in the neck.  There really ought to be a simple way of using the one Excel template displayed on the form which is, at run time, populated with the data from the tables, according to whichever project is selected (master/child combo-the easy bit).

我无法完成这项工作。 有什么想法吗？ 我可以通过电子邮件发送我放在一起的示例Excel跟踪器来显示我想要的内容 - 无法找到将其附加到此帖子的方法！

I can't make this work.  Any ideas?  I can email the example Excel tracker I put together to show what I want to get to-can't find a way of attaching it to this post either!

推荐答案

嗨Mike，

我不确定在Access中显示Excel的重点。您是说数据存储在Access中，您只想在Excel中显示它们？

Not sure I see the point of displaying Excel within Access. Are you saying the data is stored in Access and you just want to display them in Excel?

这篇关于在Access窗体上显示和填充Excel模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！