输入新记录的数据 [英] Entering Data for New Records

问题描述

当我开始输入新记录的数据时，我想在其旁边打开一个下拉框

，我可以从中选择之前输入的数据
$以同一个字母开头的b $ b记录。这是我以前的数据库，b $ b方法，工作方式。我已经尝试使用表单设计工具箱向导这个

但是没有成功。我仔细阅读了帮助菜单，发现List，Combo和Dropdown上有一些不完整的

指令。下拉图标不在

工具箱中，正如帮助所说的那样。请给我一步一步

说明，如果可能的话使用向导 - 我知道你们中的一些人去了

Basic并在那里输入你的指示，但我更愿意使用

用户友好路线。谢谢。


Neil

Carol Wilson画廊的猫画
http://www.carolwilsongallery.com

When I start to type the data for a new record, I would like a dropdown box to
open next to it from which I can choose the data from a previously entered
record that starts with the same letter. This is the way my previous database,
Approach, worked. I have tried using the form design toolbox wizard for this
but have had no success. I perused the Help menus and found some deficient
instructions on List, Combo and Dropdown. The dropdown icon is not in the
toolbox, as the Help says it should be. Please give me step by step
instructions, using the wizard if possible -- I realize some of you go right to
Basic and enter your instructions there, but I would prefer to employ the
user-friendly route. Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

推荐答案

创建组合框并设置当前的reocrd souce是同一个记录

您当前表格的来源。另外，请确保从rowsource的属性中选择Unique Values

。另外，在组合框的OnEnter事件上使用yourcomboboxname.requery

。当你点击这个框时，这将刷新清单。


HTH

Paul

" Nhmiller" < NH ****** @ aol.comnojunk>在消息中写道

news：20 *************************** @ mb-m14.aol.com。 ..

Create your combo box and set the current reocrd souce to be the same record
source of your current form. Also, make sure that you select Unique Values
from the properties on the rowsource. Also, use yourcomboboxname.requery on
the OnEnter event of the combo box. This will refreshed the list when you
click on the box.

HTH
Paul
"Nhmiller" <nh******@aol.comnojunk> wrote in message
news:20***************************@mb-m14.aol.com...

当我开始输入新记录的数据时，我想在其旁边打开一个下拉框
，我可以从中选择数据以前输入的
记录以相同的字母开头。这就是我之前的数据库方法的工作原理。我已尝试使用表单设计工具箱向导
这个
但没有成功。我仔细阅读了帮助菜单，发现了List，Combo和Dropdown上的一些不足的说明。下拉图标不在
工具箱中，正如帮助所说的那样。请给我一步一步的指示，如果可能的话使用向导 - 我意识到你们中的一些人是
基本的并且在那里输入你的指示，但我更愿意使用<用户友好的路线。谢谢。

Neil
Carol Wilson画廊的猫画
http://www.carolwilsongallery.com

When I start to type the data for a new record, I would like a dropdown
box to
open next to it from which I can choose the data from a previously entered
record that starts with the same letter. This is the way my previous
database,
Approach, worked. I have tried using the form design toolbox wizard for
this
but have had no success. I perused the Help menus and found some deficient
instructions on List, Combo and Dropdown. The dropdown icon is not in the
toolbox, as the Help says it should be. Please give me step by step
instructions, using the wizard if possible -- I realize some of you go
right to
Basic and enter your instructions there, but I would prefer to employ the
user-friendly route. Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

我一直在努力寻找一本解释如何使用的书/手册超出

最基本的水平。或者有一个网站有答案吗？你用的是什么？
？我在这里发布的帖子适用于应该在Help

菜单中的操作，但不是。我意识到Access可以通过右键单击

设计，选择属性，然后知道该怎么做或选择获取对象

来显示我想要的东西。但很少有明显的做法或选择。


Neil

Carol Wilson画廊的猫画
http://www.carolwilsongallery.com

I''ve been trying to find a book/manual that explains how to use Access beyond
the most elementary level. Or is there a website that has the answers? What do
you use? The posts I''ve made here are for operations that should be in the Help
menus, but are not. I''m realizing that Access works by right clicking in
Design, choose Properties, then knowing what to do or select to get the Object
to display what I want. But it is rarely obvious what to do or select.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

我使用Sybex ; Access 97 Developer's Handbook。这是相当不错。技术上非常好b / b
介绍了你可以遵循的概念。


在创建组合框的帮助中查找，然后只需更改记录

来源。它很简单。有很多网站。只需做一个google

seach并输入Access 97 Tutorial或类似的东西，你应该找到

lot。另外，Access附带使用Microsoft构建应用程序

Access 97。手册。它也有一些很好的例子。


祝你好运，

Paul


" Nhmiller" < NH ****** @ aol.comnojunk>在消息中写道

news：20 *************************** @ mb-m25.aol.com。 ..

I use Sybex "Access 97 Developer''s Handbook. Its quite good. It gets very
technical, but has introductions to concepts that you can follow.

Look up in the help on creating a combo box and then just change the record
source. Its quite simple. There are lots of websites. Just do a google
seach and type Access 97 Tutorial or something like that, you should find
lots. Also, Access comes with the "Building Applications With Microsoft
Access 97" manual. It has some good example too.

Good luck,
Paul

"Nhmiller" <nh******@aol.comnojunk> wrote in message
news:20***************************@mb-m25.aol.com...

我一直在努力寻找一本书/手册，解释如何使用Access
超出最基本的水平。或者有一个网站有答案吗？
你使用什么？我在这里发布的帖子是用于应该在
Help
菜单中的操作，但不是。我意识到Access的工作方式是右键单击
Design，选择Properties，然后知道该怎么做或选择获取
对象
来显示我想要的东西。但很少有明显的做法或选择。

尼尔
猫画在卡罗尔威尔逊画廊
http://www.carolwilsongallery.com

I''ve been trying to find a book/manual that explains how to use Access
beyond
the most elementary level. Or is there a website that has the answers?
What do
you use? The posts I''ve made here are for operations that should be in the
Help
menus, but are not. I''m realizing that Access works by right clicking in
Design, choose Properties, then knowing what to do or select to get the
Object
to display what I want. But it is rarely obvious what to do or select.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

这篇关于输入新记录的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！