导出访问表单到ppt [英] Export access form to ppt

问题描述

我正在考虑将表单（通过过滤器）导出到ppt演示文稿中。我目前正在打印到pdf，它没有任何问题;除了看到的一半页面空在底部。无论如何，我在msdn microsoft上找到了以下代码。我试图改变员工以匹配我的表，并使用姓氏来匹配过滤后的字段。这只是给我一个Hi页面1和filered字段中的值的ppt。 （53张这样的幻灯片）那么，是否有可能通过使用表格的布局（通过过滤后的产品）来完成以下内容，而无需在ppt中逐个复制，粘贴和操作？

I am toying with the idea of exporting a form (which is by filter) into a ppt presentation. I am currently printing to pdf and there is nothing really wrong with it; other than the seeing half the page empty at the bottom. Anyhow, I found the below code on msdn microsoft. I attempted it with changing employees to match my table, and lastname to match the filtered field. This just gives me a ppt with Hi page 1 and the value within the filered field. (53 slides of this) So, is it possible that something like the below could work by using the form''s layout (by the filtered product) without having to copy, paste and manipulate one by one in ppt?

展开 | 选择 | Wrap | 行号

推荐答案

所以，如果我关注你，你''喜欢单个Powerpoint幻灯片，就像Access表单一样？


我们还需要知道您正在使用哪个版本的Office，因为自动化代码之间存在一些重大变化VERS离开。

SO, If I am following you, you''d like a single Powerpoint slide that acts like an Access form?

We also need to know which version of Office you are using as there are some drastic changes in the automation code between versions.

Access 2010：


我想在幻灯片上显示每条记录，格式与表格相同选定的过滤器。因此，如果我选择TAC，TAC的所有记录都将在ppt中。底部不会像pdfs一样底部出现空白。看起来即使我设置了边距等等......白色占用了大量的空间。


您的意思是表现得像一个表格其他人可以编辑字段？这将是一个有趣的概念。

Access 2010:

I was thinking to have each record to show on a slide, with the same format as the form and by the selected filter. So, if I selected TAC, all records from TAC would be in the ppt. There would be no empty white at the bottom as in the pdfs. It seems even though I have the margins set, etc...white takes up a lot of space.

Did you mean by "acting like a form" that others could edit the fields? That would be an intersting concept.

我不会让powerpoint充当数据库的前端。

但是你可以设置一个引用Powerpoint到DAO模型，然后根据存储的查询打开记录集（或者为此，很可能是动态的）。


我有一个connect-4 / Blackout ;风格游戏我在powerpoint中建立了一个我为三年级学生教授的课程。这不是最简单的建设，因为在互联网上关于在powerpoint中使用VBA的信息不是很多;然而，我开始使用数据库概念，直到我遇到它将在PC和Mac上运行的事实 - 仍然可行，但真的很痛苦。


所以重点：

尝试将您的Access表单导出到powerpoint。我没有看到一个简单的方法。


所以一个解决方法......取决于你的数据库文件：

- 如果它很小，那么我们可以使用单滑动方法，我们在powerpoint中打开记录集，然后使用数据库中的信息填充幻灯片控件。我们将使用一些动作按钮来绑定到下一个按钮。 "以前"功能（请注意，我将与您同时学习一些(^_^)）以移动到正确的数据库记录。如果它是一个足够小的记录集 - 可能只是读入数组并逐步通过数组。


或


- 变化您在帖子中已经拥有的代码：不是像在您的代码中那样插入幻灯片，而是从您希望的格式化单个主幻灯片开始，然后从访问中使用复制方法（ Slide.Duplicate方法（PowerPoint）Office 2010 ）为每个感兴趣的记录复制此主幻灯片，并将记录的信息输入控件。有一种方法可以命名每个控件，我们通过幻灯片集合中的索引来引用幻灯片。所以我们复制主人，更改它的控件显示文本，然后继续。可以使用默认的幻灯片P& N-Action按钮等...如果你从一开始就接近开始，那么你可以在PP内微调演示文稿。


在任何一种情况下，代码将是相当复杂的，我会说像阿德兹，兔子，TheSmileyCoder，最后但并非最不重要的Neopa接近9/10范围的10分量表，我大约5到8和然后是第二年大学Compsci大约4/5 - 这个比率在5到6范围内。

I wouldn''t let powerpoint act as the front-end to a database.
You can however set a reference in Powerpoint to the DAO model and then open a recordset based on a stored query (or for that fact, most likely a dynamic one).

I have a "connect-4/Blackout" style game I built in powerpoint for a class I teach to third year students. It was not the easiest thing to build as there isn''t a lot of information on the internet about using VBA in powerpoint; however, I started out with the database concept until I ran into the fact that it would be running on both PC''s and Macs - still doable, but a real pain.

So to the point:
Trying to get your Access form exported to powerpoint. I''ve not seen an easy method.

So a workaround... depending on your database file:
- If it is small then we could use the single slide approach where we open the recordset within powerpoint and then populate the slide controls with information from the database. We''d use some action buttons to tie into the "next" "previous" functionality (mind you, I''ll be learning some of this with you at the same time (^_^) ) to move to the correct database record. If it''s a small enough recordset - might just read into an array and step thru the array.

OR

- A variation on the code you already have in your post: instead of inserting a slide as in the code you have, start out with a single master slide formatted as you desire, then from within access, use the duplicate method ( Slide.Duplicate Method (PowerPoint) Office 2010 ) to duplicate this master slide for each record of interest and enter the record''s information into the controls. There''s a way to name each control and we refer to the slide by its index within the slides collection. So we duplicate the master, change it''s controls displayed text, and move on. Can use the default slide P&N-Action buttons etc... If you start out with everything fairly close to begin with then you can finetune the presentation within PP.

IN either case, the code is going to be fairly complex, I''d say on a 10 point scale with People like Adezii, Rabbit, TheSmileyCoder, and last but not least Neopa closer to that 9/10 range, me around a 5 to 8 and then a 2nd year college Compsci around 4/5 - this rates around the 5 to 6 range.

这篇关于导出访问表单到ppt的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！