设计连续表格以输入得分数据 [英] Designing a continuous form for entering score data

问题描述

您好我是使用Access 2013的初学者


我正在尝试为我的一个有5个字段的表格设计数据输入表格，让我们称之为：患者ID（FK），日期，项目编号，项目名称，评级


表格必须在一个日期为一名患者收集19个单项评级（评分在1-5之间）。 br />

我不能避免输入患者ID和日期19次所以请一些建议请


谢谢

解决方案

这是（261.5 KB，198视图）

首先，BRAVO！关于创建表单。你快到了。有几件事需要考虑。


首先，因为我认为你仍然处于你必须添加范式的范例中。项目编号和项目名称，然后评估，我看到你只列出了四个记录，你正在编辑项目名称？此外，沿着这些行，如果项目名称与项目表格正确相关，则控件将显示为组合框，而不是，所以有些不对劲 - 无论是您的表单还是表格本身。我最初的想法是桌子。如果你可以发送一个tblAssessments（在数据表视图和设计视图中）。


要让你的表单显示19条记录，只需切换到设计视图并拉伸子表单，以便它更高。如果你很好滚动，那也没关系。然而，显示所有19个项目可能是获得快速快照的好处....您还应该能够删除所有导航控件。


附件是一个非常难看的版本的打开表格。


代码：

展开 | 选择 | Wrap | 行号

Hi I am a beginner using Access 2013

I am trying to design a data entry form for one of my tables which has 5 fields, let''s call them: Patient ID(FK), Date, Item Number, Item Name, Rating

The form has to collect 19 individual item ratings (scored between 1-5) for one patient on one date.

I can''t avoid inputting the Patient ID and Date 19 times so would appreciate some advice please

Thanks

解决方案

This is a companion thread to Struggling creating a version of this Excel sheet in Access form.

First, you must find a way to select the proper patient/Admission Date. Since the same patient may be admitted more than once, you need to not only pick the NHS Number, but also the Admission Date.

If you create a form with your admissions Table as the Record Source. Add all the fields from the Table (this is for viewing purposes only, so they do not need to be enabled). Next, create an unbound combo box with three columns. As a row source, use a query that includes the Patient ID, the NHS Number and the Admission Date (you can just as easily use a join to the Patients Table so that you can get names--either method will work). The first column of the combo box should be the bound column, as the assessments will be based off the PK of the Admissions Table.

Once the User selects the Correct Patient from the combo box, filter the form based on the Patient ID you have just selected. This will verify that you have the correct patient/Admission date.

Then, have a command button that will do three things:

1. Append the appropriate records to the Assessments Table
2. Open a form for entering data
3. Filter that form based on the Patient Data

The Form it opens can either be a Continuous Form with a Header and footer, which you may resize either programatically or by resizing the design window or (a method I prefer) to have a Form, with a Subform, sized so that 19 [and only 19] continuous records will be displayed. Numerous methods to create both of these, but either setup will require the assessments table to be the record source. If a subform is used, the Parent/Child fields should be the PatientID and the Admission Date.

The Command button mentioned above, for example, would have the following procedure in its On Click Event:

Expand|Select|Wrap|Line Numbers

Hi twinnyfo

I have attached a doc showing my progress to date

I am pleased that I have done some of the things you suggested by myself, but much of the early part of you post went over my head I''m afraid.

These are my current issues:

I would like Item Number and Item Name to auto populate since they are standard and come from the Items table, is this doable?
Failing that, I would like Item Name to be auto-populated based on Item Number.

I want to adopt your sizing idea so that the form is big enough for 19 rows if it cannot grow as the rows are entered

If possible I would like Patient ID to come from a previous form using OpenArgs (I have successfully accomplished this elsewhere, but have a different issue regarding the form which is probably another thread!!)

Thoughts?

Hargo

Attached Files

Assessments data entry with continuous subform.doc (261.5 KB, 198 views)

First, BRAVO! on the creation of your form. You are almost there. There are a couple things to think about.

First, because I think you are still in the paradigm that you must "add" the Item Numbers and Item Names and then the assessment, I see you only have four records listed, and you are editing the Item Name? Additionally, along those lines, if Item Name were properly related to the Items Table, the control would show up as a Combo Box, which it is not, so something is amiss--either with your Form or with your table itself. My initial thought is the table. If you can send a screeshot of tblAssessments (both in datasheet view and design view).

To get your form to show 19 records, simply switch to design view and stretch the subform so that it is taller. If you are fine scrolling, that is OK, too. However, showing all 19 items may be benficial to get a quick snapshot.... You also should be able to remove all the navigation controls.

Attached is a really ugly version of the opening Form.

The Code:

Expand|Select|Wrap|Line Numbers

这篇关于设计连续表格以输入得分数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！