形成导航和显示记录的问题 [英] Form problem with navigation and display of records

问题描述

我是Access中的新VB编程，我正在请求以下代码的帮助。


WIndows OS MSaccess 2003


此代码附加到未绑定的表单，该表单将显示基于从另一个表单传递给表单的信息的特定记录集。我遇到的问题是，对于每个case语句，正在返回正确的记录（值和记录数），但是移动命令不起作用或者不显示记录，只显示集合中的第一个记录。我可以使用故障排除代码将记录集推进到文件中显示为空白的任何位置，直到我单击cmdMoveFirst按钮。我错过了什么。我不认为导航按钮的代码非常简单。从我做过的研究中我认为/怀疑，但主要是猜测它是光标的类型和位置。任何帮助将不胜感激，特别是有关解决这类问题的提示。


TIA

b

Hi, I am new VB programming in Access and I am requesting help with the following code.

WIndows OS MSaccess 2003

This code is attached to an unbound form that will display a specific recordset based in information passed to the form from another form. The problem I am having is that for each of the case statements the proper records (values and Number of records) are being returned but the movement commands do not work or do not display the record, only the first record in the set is displayed. I can use the troubleshooting code to advance the recordset to any point in the file at which the display is blank until I click the cmdMoveFirst button. I?m missing something. I don?t think it is the code for the nav buttons that pretty simple stuff. From what research I?ve done I think/suspect, but mostly guess it?s the cursor type and location. Any help would be greatly appreciated, especially tips on trouble shooting this type of problem.

TIA
b

展开 | 选择 | Wrap | 行号

推荐答案

您好，我是Access中的新VB编程，我正在请求帮助使用以下代码。


WIndows OS MSaccess 2003


此代码附加到未绑定表单，该表单将显示基于的特定记录集从别人传递到表格的信息形式。我遇到的问题是，对于每个case语句，正在返回正确的记录（值和记录数），但是移动命令不起作用或者不显示记录，只显示集合中的第一个记录。我可以使用故障排除代码将记录集推进到文件中显示为空白的任何位置，直到我单击cmdMoveFirst按钮。我错过了什么。我不认为导航按钮的代码非常简单。从我做过的研究中我认为/怀疑，但主要是猜测它是光标的类型和位置。任何帮助将不胜感激，特别是有关解决这类问题的提示。


TIA

b

Hi, I am new VB programming in Access and I am requesting help with the following code.

WIndows OS MSaccess 2003

This code is attached to an unbound form that will display a specific recordset based in information passed to the form from another form. The problem I am having is that for each of the case statements the proper records (values and Number of records) are being returned but the movement commands do not work or do not display the record, only the first record in the set is displayed. I can use the troubleshooting code to advance the recordset to any point in the file at which the display is blank until I click the cmdMoveFirst button. I?m missing something. I don?t think it is the code for the nav buttons that pretty simple stuff. From what research I?ve done I think/suspect, but mostly guess it?s the cursor type and location. Any help would be greatly appreciated, especially tips on trouble shooting this type of problem.

TIA
b

展开 | 选择 | Wrap | 行号

有人说，你是一个言语不多的人，ADezii，但这有点太过分了！ />

Linq ; 0）>

It''s been said that you''re a man of few words, ADezii, but this is carrying things a little too far!

Linq ;0)>

我无法直接回复孤立的问题所以我把它放在这里，希望OP能找到它。

在我看之前你的情况详细，我只有两个问题：

I was unable to respond directly to an Orphaned Question so I placed it here in the hope that the OP would find it.

Before I look over your situation in detail, I just have 2 questions:

1. 为什么不明确''绑定'你的表格通过设置表单的Recordset属性来设置此Recordset？以这种方式，导航将由Access内部处理，不应该是一个考虑因素。
   
   

1. Why not explicitly ''Bind'' your Form to this Recordset by setting your Form''s Recordset Property? In this manner, navigation will be handled internally by Access and shouldn''t be a consideration.
   
   

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

这篇关于形成导航和显示记录的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！