如何将未绑定的字段文本保存到表？ [英] How to save unbound field text to table?

问题描述

我需要根据使用表格中来自

未绑定字段的数据的查询创建不同的记录集。我发现我不能这样做，而是

需要将有问题的数据（通常是文本字符串）保存到表格中。


我认为最好的方法就是使用Make Table查询 -

表的方式保持小 - 一行 - 而且

被覆盖的东西。


但如何从未绑定数据创建生成表查询？


SELECT Forms ！frmMain！frmCn！FindString INTO tblSearch; - 这失败了....


欢迎任何建议！


提前thx！

I need to create different recordsets based on queries that use data from
unbound fields in a form. I''ve discovered that I can''t do this, and instead
need to save the data in question (usually a text string) to a table.

I''m thinking the best way to do this is to use a Make Table query -- that
way the table stays small -- one row -- and there is less chance for
something to get overwritten.

But how to create a make table query from unbound data?

SELECT Forms!frmMain!frmCn!FindString INTO tblSearch; -- this fails....

any suggestions welcome!

thx in advance!

推荐答案

查看帮助文件中的CREATE TABLE语句。

一旦使用您需要的字段创建表，请保存
的值
未绑定字段。


斯图尔特


" deko" < DJ **** @ hotmail.com>在消息中写道

news：jS ****************** @ newssvr25.news.prodigy.c om ...

Look at the CREATE TABLE statement in the help file.
Once the table is created with the fields you require, save the value of the
unbound field there.

Stewart

"deko" <dj****@hotmail.com> wrote in message
news:jS******************@newssvr25.news.prodigy.c om...

我需要根据使用表单中未绑定字段的数据的查询创建不同的记录集。我发现我不能这样做，而
则需要将有问题的数据（通常是文本字符串）保存到表格中。

我在想这样做的最好方法是使用Make Table查询 - 表格保持小 - 一行 - 并且
某些东西被覆盖的可能性较小。

但是如何从未绑定的数据创建一个make表查询？

SELECT Forms！frmMain！frmCn！FindString INTO tblSearch; - 这失败了....

欢迎提出任何建议！

提前预订！

I need to create different recordsets based on queries that use data from
unbound fields in a form. I''ve discovered that I can''t do this, and instead need to save the data in question (usually a text string) to a table.

I''m thinking the best way to do this is to use a Make Table query -- that
way the table stays small -- one row -- and there is less chance for
something to get overwritten.

But how to create a make table query from unbound data?

SELECT Forms!frmMain!frmCn!FindString INTO tblSearch; -- this fails....

any suggestions welcome!

thx in advance!

创建一个包含所需字段的表格

然后参考FORM以节省价值


示例

INSERT INTO TABLENAME

VALUES（FRM！[EMPNO]，FRM！[XX]）

" Stewart Allen" < SA **** @ REMOVETHISwave.co.nz>在消息中写道

news：bl ********** @ news.wave.co.nz ...

Create a table with field you required
then refer FORM to save value

Example
INSERT INTO TABLENAME
VALUES(FRM![EMPNO], FRM![XX])
"Stewart Allen" <sa****@REMOVETHISwave.co.nz> wrote in message
news:bl**********@news.wave.co.nz...

查看CREATE TABLE语句帮助文件。
一旦使用您需要的字段创建表格，请将
的值保存在那里的未绑定字段。

Stewart

;杰科" < DJ **** @ hotmail.com>在消息中写道
新闻：jS ****************** @ newssvr25.news.prodigy.c om ...

Look at the CREATE TABLE statement in the help file.
Once the table is created with the fields you require, save the value of the unbound field there.

Stewart

"deko" <dj****@hotmail.com> wrote in message
news:jS******************@newssvr25.news.prodigy.c om...

我需要基于表单中未绑定字段使用数据
的查询创建不同的记录集。我发现我不能这样做，并且

I need to create different recordsets based on queries that use data from unbound fields in a form. I''ve discovered that I can''t do this, and

而是

需要将有问题的数据（通常是文本字符串）保存到表中。 br />
我在想这样做的最好方法是使用Make Table查询 -
这样表可以保持小 - 一行 - 并且<有什么东西要被覆盖。

但是如何从未绑定的数据创建一个make table查询？

SELECT Forms！frmMain！frmCn！FindString INTO tblSearch; - 这失败了....

欢迎提出任何建议！

提前预订！

need to save the data in question (usually a text string) to a table.

I''m thinking the best way to do this is to use a Make Table query -- that way the table stays small -- one row -- and there is less chance for
something to get overwritten.

But how to create a make table query from unbound data?

SELECT Forms!frmMain!frmCn!FindString INTO tblSearch; -- this fails....

any suggestions welcome!

thx in advance!

这些小的单记录表中有多少你可能会传播，

使您的数据库混乱，以及您计划在世界上如何管理和

实际上使用那么多表？我建议你重新考虑一下：附加查询

不会覆盖某些东西 - 除非在

访问中有一些我们不知道的访问。


Larry Linson

Microsoft Access MVP


" deko" < DJ **** @ hotmail.com>在消息中写道

news：jS ****************** @ newssvr25.news.prodigy.c om ...

How many of these little one-record tables are you likely to spread around,
cluttering your database, and how in the world do you plan to manage and
actually use that many tables? I suggest you reconsider: an Append query
will not overwrite something -- not unless there''s some humungous bug in
Access that we don''t know about.

Larry Linson
Microsoft Access MVP

"deko" <dj****@hotmail.com> wrote in message
news:jS******************@newssvr25.news.prodigy.c om...

我需要根据使用表单中未绑定字段的数据的查询创建不同的记录集。我发现我不能这样做，而
则需要将有问题的数据（通常是文本字符串）保存到表格中。

我在想这样做的最好方法是使用Make Table查询 - 表格保持小 - 一行 - 并且
某些东西被覆盖的可能性较小。

但是如何从未绑定的数据创建一个make表查询？

SELECT Forms！frmMain！frmCn！FindString INTO tblSearch; - 这失败了....

欢迎提出任何建议！

提前预订！

I need to create different recordsets based on queries that use data from
unbound fields in a form. I''ve discovered that I can''t do this, and instead need to save the data in question (usually a text string) to a table.

I''m thinking the best way to do this is to use a Make Table query -- that
way the table stays small -- one row -- and there is less chance for
something to get overwritten.

But how to create a make table query from unbound data?

SELECT Forms!frmMain!frmCn!FindString INTO tblSearch; -- this fails....

any suggestions welcome!

thx in advance!

这篇关于如何将未绑定的字段文本保存到表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！