使用msgbox函数进行双数据输入？ [英] double data entry with msgbox function?
问题描述
我需要在MS Access数据库中使用双数据输入。我有
在这个小组上阅读了许多论据和理由，但我有
来做这件事。我已经看到了关于如何做到这一点的各种提示，包括使用查询，但这并没有令人满意。我有两个
的人知道Access只是勉强输入数据所以我想要的是bgbox函数弹出一个窗口
每当进行第二轮数据输入的人在
中输入与第一轮输入不匹配的东西时，
。
1使用两张桌子和两张表格最简单吗？如果是这样的话，
我需要对第二张桌子/表格做些什么特别的事吗？
2.是否可以使用一个msgbox两个值之间的比较
并提醒进入第二轮的人
他们的条目不匹配的数据并让他们接受
他们的新条目并覆盖之前的条目或取消他们的条目
并使用第一轮中输入的值。
如果这样可行，有人可以帮我编程。
为了论证，让我说我有table1，form1，table2，form2和
我需要检查的第一个变量是AGE 。
感谢您的帮助。
我看到它的方式，最大的问题（如果你必须做这种事情）
匹配table1中的记录1和table2中的记录1。表单/ msgbox
部分非常简单。要输入的每一行数据都包含一个
强制ID字段吗？如果是，那就很容易了。如果不是，不那么容易
并且非常有问题。
示例：
用户1输入John Smith - 表1中的25岁
用户2进入约翰史密斯 - 表2中的年龄27岁
这是一个错误还是有两个（或更多）不同的约翰史密斯？
但是...
用户1输入John Smith - ID＃101 - 表1中的年龄25
User2进入John Smith - ID＃101 - 表2中的年龄27
应用程序检查表1中的ID＃101，表2中的ID为＃101，并报告
错误。 />
执行此操作的代码非常简单。
lq
< blockquote>我看到它的方式，最大的问题（如果你必须做这种事情）
匹配table1中的记录1和table2中的记录1。表单/ msgbox
部分非常简单。要输入的每一行数据都包含一个
强制ID字段吗？如果是，那就很容易了。如果不是，不那么容易
并且非常有问题。
示例：
用户1输入John Smith - 表1中的25岁
用户2进入约翰史密斯 - 表2中的年龄27岁
这是一个错误还是有两个（或更多）不同的约翰史密斯？
但是...
用户1输入John Smith - ID＃101 - 表1中的年龄25
User2进入John Smith - ID＃101 - 表2中的年龄27
应用程序检查表1中的ID＃101，表2中的ID为＃101，并报告
错误。 />
执行此操作的代码非常简单。
lq
< blockquote>你能解释为什么你要用一个例子来做这个，让我们从
那里去。
-
PC数据表
您的资源以获取Access，Excel和Word应用程序的帮助
重新* *****@pcdatasheet.com
www.pcdatasheet.com
如果您无法获得所需的帮助在新闻组中，我可以帮助您支付非常合理的费用。超过1000名访问用户来找我寻求帮助。
需要一个月历或7天日历吗？需要预约安排？需要
房间预订安排？需要员工的工作安排？联系我！
< jh ****** @ gmail.com>在消息中写道
news：11 ********************** @ z14g2000cwz.googlegr oups.com ...
我需要在MS Access数据库中使用双数据输入。我已经在这个小组中阅读了许多论据和理由，但我已经做到了这一点。我已经看到了关于如何做到这一点的各种提示，包括使用查询，但这并没有令人满意。我有两个人知道Access几乎不足以输入数据所以我真正想要的是像msgbox函数一样弹出一个窗口
每当做第二轮的人时数据录入类型与第一轮录入的内容不匹配。
1.使用两个表格和两个表格最简单吗？如果是这样，那么我需要对第二个表格/表格做些什么特别的事情吗？
2.是否可以使用一个msgbox进行比较
两个值并提醒进入第二轮的人他们的条目不匹配的数据并让他们接受他们的新条目并覆盖之前的条目或取消他们的条目
和使用在第一轮中输入的值。
如果这样可行，有人可以帮我编程。
为了论证，让我说我有table1，form1，table2，form2我需要检查的第一个变量是年龄。
感谢您的帮助。
I need to use double data entry with an MS Access database. I have
read many arguments and reasons against this on this group but I have
to do this. I have seen various tips on how this can be done including
the use of queries but this hasn''t worked satisfactorily. I have two
people who know Access just barely enough to enter the data so what I
really want is something like the msgbox function to pop up a window
whenever the person doing the second round of data entry types in
something that doesn''t match the first round of entry.
1. Would it be easiest to use two tables and two forms? If so, is
there anything special I need to do to the second table/form?
2. Would it be possible to use a msgbox that makes the comparison
between the two values and alerts the person entering the second round
of data that their entry doesn''t match AND lets them either accept
their new entry and override the previous entry or cancel their entry
and use the value entered in the first round.
If this will work, can someone please help me with the programming.
For argument sake, lets say I have table1, form1, table2, form2 and the
first varialbe I need to check is AGE.
Thanks for any help.
The way I see it, the biggest issue (if you must do this sort of thing)
is matching record 1 in table1 with record 1 in table2. The form/msgbox
part is pretty easy. Does every row of data to be entered include a
mandatory ID field? If yes, then it''s pretty easy. If no, not so easy
and very problematic.
Example:
User1 enters John Smith - Age 25 in table 1
User2 enters John Smith - Age 27 in table 2
Is this an error or are there two (or more) different John Smiths?
But ...
User1 enters John Smith - ID# 101 - Age 25 in table 1
User2 enters John Smith - ID# 101 - Age 27 in table 2
Application checks ID#101 in Table1 with ID#101 in Table2 and reports
the error.
The code to do this is pretty straight forward.
lq
The way I see it, the biggest issue (if you must do this sort of thing)
is matching record 1 in table1 with record 1 in table2. The form/msgbox
part is pretty easy. Does every row of data to be entered include a
mandatory ID field? If yes, then it''s pretty easy. If no, not so easy
and very problematic.
Example:
User1 enters John Smith - Age 25 in table 1
User2 enters John Smith - Age 27 in table 2
Is this an error or are there two (or more) different John Smiths?
But ...
User1 enters John Smith - ID# 101 - Age 25 in table 1
User2 enters John Smith - ID# 101 - Age 27 in table 2
Application checks ID#101 in Table1 with ID#101 in Table2 and reports
the error.
The code to do this is pretty straight forward.
lq
Could you explain WHY you have to do this with an example and let''s go from
there.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
If you can''t get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
<jh******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...I need to use double data entry with an MS Access database. I have
read many arguments and reasons against this on this group but I have
to do this. I have seen various tips on how this can be done including
the use of queries but this hasn''t worked satisfactorily. I have two
people who know Access just barely enough to enter the data so what I
really want is something like the msgbox function to pop up a window
whenever the person doing the second round of data entry types in
something that doesn''t match the first round of entry.
1. Would it be easiest to use two tables and two forms? If so, is
there anything special I need to do to the second table/form?
2. Would it be possible to use a msgbox that makes the comparison
between the two values and alerts the person entering the second round
of data that their entry doesn''t match AND lets them either accept
their new entry and override the previous entry or cancel their entry
and use the value entered in the first round.
If this will work, can someone please help me with the programming.
For argument sake, lets say I have table1, form1, table2, form2 and the
first varialbe I need to check is AGE.
Thanks for any help.
这篇关于使用msgbox函数进行双数据输入？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
