仅显示基于特定值的记录 [英] Showing only records based on a specific value

问题描述

您好 -

我需要一些帮助。我不认为这太难做了，但是我已经离开任何访问开发一段时间了，似乎无法弄明白。我已经尝试了查询和过滤......我给了！


字段：Typeproject（列表框）

价值观：CSA，TASKERS，CONFERENCES ，签名


例如，我想要一个名为TASKERS的表单 - 当它打开时 - 只显示字段值typeproject的记录。已被指定为TASKERS。这是一个用于搜索记录以进行编辑等的表格。


任何帮助都将不胜感激。


谢谢


SV

Hello-
I need a little help. I don''t think this is too difficult to do, however I have been away from any access development for some time and can''t seem to figure it out. I''ve tried queries and filtering......I give!

FIELD: Typeproject (Listbox)
VALUES: CSA, TASKERS, CONFERENCES, SIGNATURE

For example I want the form called TASKERS - when it opens - to show only records in which the value for the field "typeproject" has been designated as "TASKERS". This is a form which will be used to search for records for editing, etc.

Any help would be greatly appreciated.

THANKS

SV

推荐答案

Hello-
$ b $我需要一些帮助。我不认为这太难做了，但是我已经离开任何访问开发一段时间了，似乎无法弄明白。我已经尝试了查询和过滤......我给了！


字段：Typeproject（列表框）

价值观：CSA，TASKERS，CONFERENCES ，签名


例如，我想要一个名为TASKERS的表单 - 当它打开时 - 只显示字段值typeproject的记录。已被指定为TASKERS。这是一个用于搜索记录以进行编辑等的表格。


任何帮助都将不胜感激。


谢谢


SV

Hello-
I need a little help. I don''t think this is too difficult to do, however I have been away from any access development for some time and can''t seem to figure it out. I''ve tried queries and filtering......I give!

FIELD: Typeproject (Listbox)
VALUES: CSA, TASKERS, CONFERENCES, SIGNATURE

For example I want the form called TASKERS - when it opens - to show only records in which the value for the field "typeproject" has been designated as "TASKERS". This is a form which will be used to search for records for editing, etc.

Any help would be greatly appreciated.

THANKS

SV

假设：

__1。列表框名称：lstTypeProject

Assumption:
__1. List Box Name: lstTypeProject

展开 | 选择 | Wrap | 行号

谢谢...


我试过你为代码发送了什么，但我做错了什么。以下是我的内容：


表格名称为：frmTaskers_Suspense-Edit / Search

字段名称为：项目列表

字段控制源是：ProjectID


我把代码放在''s属性的形式 -

事件：输入 - 事件过程：


当我单击命令按钮打开表单时，我收到以下错误消息：

编译错误：

Syntex错误


Private Sub Form_Open（取消为整数）这是黄色的

''打开表格并仅显示记录在列表框中选择的项目类型：

DoCmd.OpenForm" frmTaskers_Suspense-Edit / Search"，acNormal ,,Taskers =''" &安培;我！ [项目清单]& "" 这显示为红色


我检查了帮助，但我没有足够的编码经验来了解问题所在。


有什么想法吗？


谢谢。


SV

Thanks...

I tried what you sent for a code but I am doing something wrong. Here is what I have:

The form name is: frmTaskers_Suspense-Edit/Search
The field Name is: Project List
The field Control Source is: ProjectID

I put the code in the form''s property-
Event: On Enter - event procedure:

When I click on the command button to open the form I get the following error message:
Compile Error:
Syntex Error

Private Sub Form_Open(Cancel As Integer) THIS IS HILIGHED IN YELLOW
''To open form and display only records with the project type selected in the list box:
DoCmd.OpenForm "frmTaskers_Suspense-Edit/Search", acNormal, , "Taskers=''" & Me! [Project List]& "''" THIS SHOWS IN RED

I checked HELP but I don''t have near enough coding experience to understand what the problem is.

Got any ideas?

Thanks.

SV

谢谢...


我尝试了你发送的代码，但我做错了。以下是我的内容：


表格名称为：frmTaskers_Suspense-Edit / Search

字段名称为：项目列表

字段控制源是：ProjectID


我把代码放在''s属性的形式 -

事件：输入 - 事件过程：


当我单击命令按钮打开表单时，我收到以下错误消息：

编译错误：

Syntex错误


Private Sub Form_Open（取消为整数）这是黄色的

''打开表格并仅显示记录在列表框中选择的项目类型：

DoCmd.OpenForm" frmTaskers_Suspense-Edit / Search"，acNormal ,,Taskers =''" &安培;我！ [项目清单]& "" 这显示为红色


我检查了帮助，但我没有足够的编码经验来了解问题所在。


有什么想法吗？


谢谢。


SV

Thanks...

I tried what you sent for a code but I am doing something wrong. Here is what I have:

The form name is: frmTaskers_Suspense-Edit/Search
The field Name is: Project List
The field Control Source is: ProjectID

I put the code in the form''s property-
Event: On Enter - event procedure:

When I click on the command button to open the form I get the following error message:
Compile Error:
Syntex Error

Private Sub Form_Open(Cancel As Integer) THIS IS HILIGHED IN YELLOW
''To open form and display only records with the project type selected in the list box:
DoCmd.OpenForm "frmTaskers_Suspense-Edit/Search", acNormal, , "Taskers=''" & Me! [Project List]& "''" THIS SHOWS IN RED

I checked HELP but I don''t have near enough coding experience to understand what the problem is.

Got any ideas?

Thanks.

SV

尝试：

Try:

展开 | 选择 | Wrap | 行号

这篇关于仅显示基于特定值的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！