新问题 - 请帮忙!! [英] Newby question - Please help!!

问题描述

我以为我开始处理Access，直到我尝试了做一些有用的事情......现在我被困住了。我有一个带有两个表的数据库 -

以保持简单我会说一个是员工文件（员工），

而另一个是地址文件（地址）由SSN链接。我已将

地址设置为查找表 - 如果用户开始输入SSN，那么

应该提取员工记录。

我被困在数据输入表格中。当我输入SSN它

确实提高了员工的记录，但是我不能让它填充

剩余的字段来自地址表。我想从地址表填充

员工姓名等...到员工表。

Northwind数据库有一个很好的例子我正在尝试在订单表格中以

来做。关键似乎是在绑定列的AfterClick事件

过程中（我认为订单编号，但不要记住）b $ b。但它是一种我无法找到参考的格式。它是
就像Me.OrderNum = Me.NewOrderNum。


对不起漫步 - 我知道这不是太清楚了。请

指出我正确的方向!!


TIA！

解决方案

< blockquote>如果你不是新闻组的常驻巨魔和角色刺客，那么你需要知道你在使用他之前使用过的别名

超级新闻，就像你一样，如果你没有得到答案，那很可能是因为人们认为他只是试图开始一个悬挂他的人的线索。 />
拖钓和角色暗杀。


" Jack Schitt" < [e-mail]>在消息中写道

新闻：4d ******************************** @ 4ax.com ...

我以为我开始处理Access，直到我尝试做一些有用的事情......现在我被卡住了。我有一个带有两个表的数据库 -
为了保持简单我会说一个是员工文件（Employees），
，另一个是由SSN链接的地址文件（地址）。我已将
地址设置为查找表 - 如果用户开始输入SSN，它将拉出员工记录。

我陷入困境数据输入表单。当我输入SSN时，它确实拉了员工的记录，但是我无法从地址表填充其余的字段。我想将地址表中的员工姓名等填充到Employee表中。
Northwind数据库有一个很好的例子，我正在尝试做什么，
订单表格。关键似乎是在绑定列的AfterClick事件
过程中（我认为订单号，但不记得）。但它是一种我无法找到参考的格式。它就像Me.OrderNum = Me.NewOrderNum。

我很抱歉漫无目的 - 我知道这不是太清楚了。请
指向正确的方向!!

TIA！

让我们回顾一下并问为什么你有两个单独的表。

你想为一个员工存储多个地址吗？

如果是这样，当你输入一个SSN时，哪个地址应该显示？

如果没有，为什么不把地址放在与员工相同的桌子上？


- 海龟


" Jack Schitt" < [e-mail]>在消息中写道

新闻：4d ******************************** @ 4ax.com ...

我以为我开始处理Access，直到我尝试做一些有用的事情......现在我被卡住了。我有一个带有两个表的数据库 -
为了保持简单我会说一个是员工文件（Employees），
，另一个是由SSN链接的地址文件（地址）。我已将
地址设置为查找表 - 如果用户开始输入SSN，它将拉出员工记录。

我陷入困境数据输入表单。当我输入SSN时，它确实拉了员工的记录，但是我无法从地址表填充其余的字段。我想将地址表中的员工姓名等填充到Employee表中。
Northwind数据库有一个很好的例子，我正在尝试做什么，
订单表格。关键似乎是在绑定列的AfterClick事件
过程中（我认为订单号，但不记得）。但它是一种我无法找到参考的格式。它就像Me.OrderNum = Me.NewOrderNum。

我很抱歉漫无目的 - 我知道这不是太清楚了。请
指出我正确的方向!!

TIA！

我害怕有人会问那！！这实际上并不是我想要完成的事情 - 我只是想让它变得更简单

（在我看来!!）我是什么我正在使用的是HelpDesk类型的应用程序。一个

的PC技术人员应该能够到用户的桌面，从那台电脑上取下这个

数据库，并为该用户进行查找，PC Serial

号码，工作站名称等...（全部驻留在名为

员工的数据库中）。 Serial＃是该查找表的P. Key。当找到

员工记录时，应填写此表单，这将在

附加字段中添加

对应记录到HelpLog Databasem中。作为技术人员的姓名，问题，解决方案等...

所以它应该为每个麻烦电话创建一个新记录。


谢谢！


2004年5月5日星期三，格林威治标准时间11:41:27，MacDermott < ma ******** @ nospam.com>

写道：

让我们回过头来问你为什么有两个单独的表格。
您想为一个员工存储多个地址吗？
如果是这样，当您输入SSN时，应显示哪个地址？
如果没有，为什么不把地址放在与员工相同的表格中？

- Turtle

Jack Schitt < [e-mail]>在消息中写道
新闻：4d ******************************** @ 4ax.com .. < blockquote class =post_quotes>我以为我开始处理Access，直到我尝试做一些有用的事情......现在我被卡住了。我有一个带有两个表的数据库 -
为了保持简单我会说一个是员工文件（Employees），
，另一个是由SSN链接的地址文件（地址）。我已将
地址设置为查找表 - 如果用户开始输入SSN，它将拉出员工记录。

我陷入困境数据输入表单。当我输入SSN时，它确实拉了员工的记录，但是我无法从地址表填充其余的字段。我想将地址表中的员工姓名等填充到Employee表中。
Northwind数据库有一个很好的例子，我正在尝试做什么，
订单表格。关键似乎是在绑定列的AfterClick事件
过程中（我认为订单号，但不记得）。但它是一种我无法找到参考的格式。它就像Me.OrderNum = Me.NewOrderNum。

我很抱歉漫无目的 - 我知道这不是太清楚了。请
指出我正确的方向!!

TIA！

I thought I was starting to get a handle on Access, until I tried
doing something useful...now I''m stuck. I have a DB with two tables -
to keep it simple I''ll say that one is an Employee File (Employees),
and the other is an Address File (Addresses) linked by SSN. I''ve set
Addresses as a Lookup Table - If the user starts typing in the SSN it
should pull up the Employees records.

I''m getting stuck in the Data Entry form. When I type in the SSN it
does pull up the employee''s record, but I can''t get it to populate the
remainder of the fields from the Address table. I want to populate
employee name, etc... from the address table into the Employee table.
The Northwind database has a good example of what I''m trying to do, in
the Orders form. The key seems to be in the AfterClick Event
procedure of the bound column (I think order number, but don''t
remember). But it is in a format I can''t find a reference to. It
goes something like Me.OrderNum = Me.NewOrderNum.

I''m sorry about rambling - I realize this isn''t too clear. Please
point me in the right direction!!

TIA!

解决方案

If you aren''t the newsgroup''s resident troll and character assassin, you
should be aware that you are using an alias he has used before posting from
Supernews, as you are, and if you don''t get answers, it may well be because
people think that he''s just trying to start a thread on which to hang his
trolling and character assassination.

"Jack Schitt" <[e-mail]> wrote in message
news:4d********************************@4ax.com...

I thought I was starting to get a handle on Access, until I tried
doing something useful...now I''m stuck. I have a DB with two tables -
to keep it simple I''ll say that one is an Employee File (Employees),
and the other is an Address File (Addresses) linked by SSN. I''ve set
Addresses as a Lookup Table - If the user starts typing in the SSN it
should pull up the Employees records.

I''m getting stuck in the Data Entry form. When I type in the SSN it
does pull up the employee''s record, but I can''t get it to populate the
remainder of the fields from the Address table. I want to populate
employee name, etc... from the address table into the Employee table.
The Northwind database has a good example of what I''m trying to do, in
the Orders form. The key seems to be in the AfterClick Event
procedure of the bound column (I think order number, but don''t
remember). But it is in a format I can''t find a reference to. It
goes something like Me.OrderNum = Me.NewOrderNum.

I''m sorry about rambling - I realize this isn''t too clear. Please
point me in the right direction!!

TIA!

Let''s back up a moment and ask why you have two separate tables.
Do you want to store multiple addresses for a single employee?
If so, when you type in a SSN, which address should be displayed?
If not, why not put the address in the same table as the employee?

- Turtle

"Jack Schitt" <[e-mail]> wrote in message
news:4d********************************@4ax.com...

I thought I was starting to get a handle on Access, until I tried
doing something useful...now I''m stuck. I have a DB with two tables -
to keep it simple I''ll say that one is an Employee File (Employees),
and the other is an Address File (Addresses) linked by SSN. I''ve set
Addresses as a Lookup Table - If the user starts typing in the SSN it
should pull up the Employees records.

I''m getting stuck in the Data Entry form. When I type in the SSN it
does pull up the employee''s record, but I can''t get it to populate the
remainder of the fields from the Address table. I want to populate
employee name, etc... from the address table into the Employee table.
The Northwind database has a good example of what I''m trying to do, in
the Orders form. The key seems to be in the AfterClick Event
procedure of the bound column (I think order number, but don''t
remember). But it is in a format I can''t find a reference to. It
goes something like Me.OrderNum = Me.NewOrderNum.

I''m sorry about rambling - I realize this isn''t too clear. Please
point me in the right direction!!

TIA!

I was afraid somebody was going to ask that!! This isn''t actually
what I''m trying to accomplish - I was just trying to keep it simpler
(in my mind!!) What I''m working on is a HelpDesk type application. A
PC technician should be able to go to a user''s desk, pull up this
database from that pc, and do a lookup for that user, PC Serial
number, workstation name, etc... (all resides in a DB called
Employee). The Serial# is the P. Key of that lookup table. When the
employee record is found it should populate this form, which will add
corresponding records into the HelpLog Databasem which contains
additional fields such as techician name, problem, solution, etc...
So it should create a new record for every trouble call.

Thanks!

On Wed, 05 May 2004 11:41:27 GMT, "MacDermott" <ma********@nospam.com>
wrote:

Let''s back up a moment and ask why you have two separate tables.
Do you want to store multiple addresses for a single employee?
If so, when you type in a SSN, which address should be displayed?
If not, why not put the address in the same table as the employee?

- Turtle

"Jack Schitt" <[e-mail]> wrote in message
news:4d********************************@4ax.com.. .

I thought I was starting to get a handle on Access, until I tried
doing something useful...now I''m stuck. I have a DB with two tables -
to keep it simple I''ll say that one is an Employee File (Employees),
and the other is an Address File (Addresses) linked by SSN. I''ve set
Addresses as a Lookup Table - If the user starts typing in the SSN it
should pull up the Employees records.

I''m getting stuck in the Data Entry form. When I type in the SSN it
does pull up the employee''s record, but I can''t get it to populate the
remainder of the fields from the Address table. I want to populate
employee name, etc... from the address table into the Employee table.
The Northwind database has a good example of what I''m trying to do, in
the Orders form. The key seems to be in the AfterClick Event
procedure of the bound column (I think order number, but don''t
remember). But it is in a format I can''t find a reference to. It
goes something like Me.OrderNum = Me.NewOrderNum.

I''m sorry about rambling - I realize this isn''t too clear. Please
point me in the right direction!!

TIA!

这篇关于新问题 - 请帮忙!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！