创建表单按钮以导出表 [英] Create a form button to export a table
问题描述
大家好，
我需要定期将我的数据库备份为Excel文件，并使用文件导出选项
。
问题是我需要任何人使用数据库才能轻松完成这个
- nopt just me。对于所有用户，数据库都是隐藏的，只有
a菜单屏幕是可见的。
我可以在菜单屏幕上创建一个按钮来导出表格>
基本上提出了另存为。窗口。
我的主菜单名为Archive Records DB。我希望
定期出口的表格是客户名单
我对代码或我的理解不是很好，所以如果任何人
可以指出我正确的方向，我将不胜感激!!
Hi all,
I need to regularly backup my database as an Excel file and have been
using the File Export option.
Problem is I need anyone using the database to be able to do this
easily - nopt just me. For all users the database is hidden and only
a menu screen is visable.
Can I create a button on my menu screen that will export a table >
basically bring up the "save as" window.
My main menu for is called "Archive Records DB" and the table I want
to regularly export is "Customer List"
I''m not terribly good with code or my understanding of it so if anyone
can point me in the right direction it will be greatly appreciated!!
推荐答案
好吧我想我解决了问题主要是 - 并且创建了另一个。
我在一个新宏中使用了TransferSpreadsheet函数并将其设置为
将我的表导出为Excel文件。 br />
使用此功能，您必须在宏中的文件名标准下指定文件名并保存路径
。
我希望能够根据菜单屏幕上的
未绑定字段来控制文件的保存位置。
我尝试输入[Forms]！[Archive Records DB]！[ExportDirectory]进入
宏字段''文件名''但这不起作用 - 宏运行和
不是ng - 甚至没有收到错误消息。有没有人知道
是如何工作的？
well I think I solved the problem mostly - and created another one.
I used the TransferSpreadsheet function in a new Macro and set it to
export my table as an Excel file.
With this function you have to specify the file name and save path
under the ''File Name'' criteria in the Macro.
I would like to be able to control where the file is saved based on an
unbound field on the menu screen.
I tried typing [Forms]![Archive Records DB]![ExportDirectory] into the
Macro field ''File Name'' but this doesn''t work - the macro runs and
does nothing - don''t even get an error message. Does anyone know how
to make this work?
" DeZZar" < de ************** @ gmail.comwrote in message
news：1b **************** ****************** @ a3g2000p rm.googlegroups.com ...
"DeZZar" <de**************@gmail.comwrote in message
news:1b**********************************@a3g2000p rm.googlegroups.com...
>
我需要定期备份我的数据库作为Excel文件
>
I need to regularly backup my database as an Excel file
除非您的数据库包含一个平面表，否则就不是
可能无需存储冗余重复项。使用Excel作为数据备份
方法不是我推荐的方法。
基思。
Well unless your database consists of one flat table then that just isn''t
possible without storing redundant duplicates. Using Excel as a data backup
method isn''t one I''d recommend.
Keith.
除非你的数据库由一个平面表组成，否则就不是
Well unless your database consists of one flat table then that just isn''t
可能没有存储多余的重复项。 *使用Excel作为数据备份
方法不是我推荐的。
基思。
possible without storing redundant duplicates. *Using Excel as a data backup
method isn''t one I''d recommend.
Keith.
感谢Keith，但我的多表数据库的实际导出是
，根据宏的原样工作得很好。
备份这个数据库作为excel文件很好 - 它是
医生订购的。
我''我刚刚试图控制我的maco在未绑定的表单字段上将保存的文件基于
的位置。类似于如何从未绑定的表单字段控制查询条件
。
任何人都有任何想法？
Thanks Keith, but the actual export of my multi table database is
working just fine based on the macro in place.
Backup for this database as an excel file is just fine - its what the
doctor ordered.
I''m just now trying to control where my maco puts the saved file based
on an unbound form field. Similar to how you control query criteria
from an unbound form field.
anyone got any ideas?
这篇关于创建表单按钮以导出表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
