如何将未绑定的字段文本保存到表? [英] 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屋!