Word表单访问表数据传输 [英] Word Form to Access Tables Data Transfer

问题描述

您好，

我正在使用Access 2003和Word 2003，我正在尝试将单词表单中的数据导入到一对多关系中的多个访问表中，但是我似乎无法弄明白。


我使用以下示例创建一个将数据传输到单个访问表的单词表单

< a rel =nofollowhref =http://msdn2.microsoft.com/en-us/library/aa155434(office.10).aspx\"target =_ blank> http://msdn2.microsoft.com/ en-us / lib ... ffice.10）.aspx


这似乎工作正常。我的问题是我想在表单上记录几个地址而不是一个。所以我设置了第二个表来记录名为tblAddresses的地址，并将字段Address，City，State和Zip移动到该表中。我将这两个表以一对多的关系与一个名为ContractID的字段相关联。


在Word表单本身我已经为第一个地址设置了书签fldAddress1，fldState1 ，fldState1，fldZip1和Zip2。

对于第二个地址fldAddress2，fldState2，fldfldZip3和fldZip4


我只是不确定如何更改模块的代码，所以它将单词形式的地址数据放入tbladdress，然后为第二个地址添加另一条记录，并将其全部链接到tblContracts中的记录。


有没有人有任何想法？


谢谢

Hi there,
I''m using Access 2003 and Word 2003 and I''m trying to import data from the word form to multiple access tables in a one to many relationship, but I can''t seem to figure it out.

I have used the following example to create a word form that transfers data to a single access table

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

This seems to work fine. My problem is that I want to record several addresses on the form rather than just one. So I have set up a second table to record the addresses called tblAddresses and moved the fields Address, City, State and Zip to this table. I have linked the two tables in a one-to-many relationship with a field called ContractID.

On the Word form itself I have set up bookmarks for the first address as fldAddress1, fldState1, fldState1, fldZip1 and Zip2.
And for the second address fldAddress2, fldState2, fldfldZip3 and fldZip4

I''m just not sure how to change the code of the module so it puts the address data from the word form into tbladdress then adds another record for the second address and keeps it all linked to the record in tblContracts.

Does anyone have any ideas?

Thanks

推荐答案

一个问题跳到脑海，为什么你甚至会尝试将松散的文本文件导入一个数据库？


ps使用访问表单或@ v.least excel ...;）

one question jumps to mind, why would you even attempt to import loose text file into a database?

p.s use access forms or @ the v.least excel... ;)

我操纵了我自己的个人示例但是我正在使用这个例子，因为它比试图解释我自己的数据库和表单更容易。


基本上其他人会填写很多这些Word表单而不是我自己重新输入所有这些信息，因为其他人无权访问数据库，我可以直接将数据导入数据库。

I''ve manipulated the example for my own personal use but I''m using this example as its easier than trying to explain my own database and form.

Basically other people will be filling in lots of these Word forms and rather than having to retype all this information my self, as the other people don''t have access to the database, i can just import the data straight into the database.

一个问题跳到脑海，为什么你甚至会尝试将松散的文本文件导入数据库？


ps使用访问表单或@ v.least excel ...;）

one question jumps to mind, why would you even attempt to import loose text file into a database?

p.s use access forms or @ the v.least excel... ;)

因为你很清楚新的你可以原谅做出疯狂的假设，你比他们更了解OP的问题。

请记住，将来并非所有事情都像你想象的那样明显。许多问题都以特定的方式表达，只是为了尽可能简单明了地表达问题。


我想另一种表达方式是如果你没有任何帮助添加 - 考虑智慧最好用较少的单词表达。

As you''re clearly new you can be forgiven for making wild assumptions that you understand the OP''s question better than they do.
Please remember in future that not everything is as obvious as you seem to assume. Many questions are phrased in a particular way simply to express the problem as simply and clearly as possible.

I suppose another way of expresssing this is "If you haven''t anything helpful to add - consider wisdom is best expressed in fewer words."

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