保存创建的表格 [英] Save a created table

问题描述

我有一个表单，可以从各种追加查询中创建一个表。此表根据我从组合框中选择的季度而变化。现在我要做的是找到一种自动化保存过程的方法，这样对于创建的每个季度，我可以用不同的名称保存表。现在，对于我选择的任何季度，该表都保存在计算的时间表中。


有没有办法在VB中放置代码或单独的命令按钮。


如果需要进一步说明，请告诉我需要。


谢谢。

I have a form that creates a table from various append queries. This table changes based on the quarter i choose from the combo box. Now what I am trying to do is find a way to automate the saving process so that for each quarter that is created I can save the table in a different name. Right now for whatever quarter I select the table is saved in "Calculated Schedule".

Is there a way to put a code in VB to do it or a separate command button.

Let me know if further clarification is needed.

Thanks.

推荐答案

我的表格是从各种追加查询创建一个表。此表根据我从组合框中选择的季度而变化。现在我要做的是找到一种自动化保存过程的方法，这样对于创建的每个季度，我可以用不同的名称保存表。现在，对于我选择的任何季度，该表都保存在计算的时间表中。


有没有办法在VB中放置代码或单独的命令按钮。


如果需要进一步说明，请告诉我需要。


谢谢。

I have a form that creates a table from various append queries. This table changes based on the quarter i choose from the combo box. Now what I am trying to do is find a way to automate the saving process so that for each quarter that is created I can save the table in a different name. Right now for whatever quarter I select the table is saved in "Calculated Schedule".

Is there a way to put a code in VB to do it or a separate command button.

Let me know if further clarification is needed.

Thanks.

这可以做到，但我不建议你随着时间的推移会有多少桌子。


为什么不将数据导出到excel文件呢？

This can be done but I wouldn''t advise it as how many tables are you going to end up with over time.

Why not export the data to an excel file instead?

这可能是真的，但暂时我想给它一个机会。你介意过去怎么做？

That is probably true but for the time being I want to give it a shot. Do you mind going over how it can be done?

你说过在线程中可以保存创建的表但不推荐。能否详细说明一下，因为这是我老板想要做的事情。


谢谢。

Hi,

You said in the thread that saving a created table was possible but not recommended. Could you please elaborate on that since that is what my boss wants to do.

Thanks.

请不要直接告诉我有关编码问题的信息，但请发布到论坛。这有很好的理由，包括其他专家可以在这些问题上添加评论。

回答你的问题：


如果每季度保存一张新表，那么每年将有四张新表。这些都与数据库结构没有任何关系，但仅用于存档目的。这增加了数据库的大小，这有一个限制，我看不出有任何好的理由。


这种情况​​下的常规做法是每季度将表中的数据导出到excel文件。然后，可以使用代码将此文件链接到数据库，并将其包含在查询中或用于表单数据表等上的显示。随着时间的推移，您可以删除不再相关的文件的链接，但仍保留信息如果需要，可以使用excel文件。


如果您有兴趣，我可以为您提供代码。

Please don''t PM me directly about coding issues but post to the forum. There are good reasons for this including the fact that other experts can add there comments on these issues.

To answer your question:

If you save a new table for every quarter then that will be four new tables a year. None of which has any relationship to the database structure but is only for archiving purposes. This increases the size of your database which does have a limit and I can''t see any good reason for this.

The normal practice in cases like this is to export the data from the table every quarter to a excel file. This file can then be linked to the database using code and can be included in queries or for display purposes on a form datasheet, etc, As time goes on you can delete the link to files that are no longer relevant and yet retain the information in the excel file in case it is needed.

I can give you the code to do this if you''re interested.

这篇关于保存创建的表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！