未绑定表单详细信息到表中的新记录 [英] Unbound form details to new record in table

问题描述

嗨专家。我被困住了，请尽快使用你的帮助。我一直试图征服这个，但作为一个相对的VB新手，似乎无法解决它。


我有一个未绑定的表格，其中包含产品的详细信息添加到不同文本/组合框中的计划。我还有一系列日期，旁边有复选框。当我单击表单底部的添加到计划命令按钮时，我需要为每个日期添加一个记录表（以及它的相关详细信息，包括机器和运算符） '放在表格的每个字段中）如果在该日期旁边勾选复选框，则日期和其他信息仅为字段 。


我有尝试了各种方法，如''setvalue''等，并遇到错误，如表未打开。是否有直接的编码解决方案？


我希望你能尽快帮助，非常感谢提前，OllyJ

Hi experts. I''m stuck and could use your help ASAP again please. I have been trying to conquer this one for some time but being a relative VB novice, can''t seem to crack it.

I have an unbound form with details of a product to add to a schedule in different text / combo boxes. I also have a series of dates with check boxes next to them. When I click an ''add to schedule'' command button at the bottom of the form, i need a record to be added to a table for each date (along with its relative details inc ''machine'' and ''operator'' put in each field of the table) where the date and other information are fields only if a check box is ticked next to that date.

I have tried various methods such as ''setvalue'' etc and encountered errors such as the table not being open. Is there a straight forward coding solution?

I hope you can help ASAP, many thanks in advance, OllyJ

推荐答案

为什么一个未绑定的表单而不是绑定的表单？

Why an unbound form instead of a bound form?

像往常一样，Rabbit是正确的！不受约束的表格不适合胆小的人，当然也不适合初学者！使用绑定表格！


欢迎来到TheScripts！

Linq ; 0）>

Rabbit, as usual, is correct! Unbound forms are not for the faint hearted, and certainly not for novices! Go with a bound form!

Welcome to TheScripts!
Linq ;0)>

我认为是一个未绑定的表单，因为我正在使用它来准备要添加到表的详细信息，而表将自动填充绑定到该表的表单。这是一种中间准备表格。即使它是一个约束形式，我仍然需要一个解决方案，我正在努力（使用命令按钮从表单输入多个记录）。


请花一点时间详细了解我的问题，它将帮助我解释我在哪里...


更详细的，我的问题是我要添加通过中间形式制定生产计划表（快速添加）。我填写了几个细节，例如产品应该运行的机器和操作员。在这些细节下面是选项按钮，允许用户选择要安排的周。当他们这样做时，可以看到一系列相关日期，旁边有复选框。选择所选日期后，按下命令按钮（''添加到计划''），我需要将详细信息添加到我的计划表中（为每个日期添加的记录，其中所有先前的详细信息填充剩余的表字段）。


这可能是我需要的一大堆代码，我将非常感谢能够尽快提供帮助的人...


非常感谢提前


OllyJ

I thought an unbound form because I am using it to prepare details to add to a table, which in turn will automatically fill a form bound to that table. It is an intermediary prep form. Even if it was a bound form however, i would still need a solution for what i''m struggling with (entering multiple records into a table from a form using a command button).

Please take a minute to read about my problem in more detail, it will help me explain where I am with it...

In more detail, my problem is that I am adding to a manufacturing schedule through an intermediary form (a ''quick add''). I have several details filled in such as a machine that the product should run on and an operator. Below these details are option buttons allowing the user to pick which week to add to schedule. When they do a series of relevant dates are visible with check boxes next to them. When the chosen dates are selected, and the command button (''add to schedule'') pressed, I need for the details to be added to my schedule table (a record added for each date with all the previous details filling the remaining table fields).

It is probably a nice chunk of code that I need and I would be grateful to anyone who can help as soon as possible please...

Many thanks in advance

OllyJ

这篇关于未绑定表单详细信息到表中的新记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！