Question

I have a single form, linked to a single table. The form has three bound text boxes, each allow for data entry to the table. In the text boxes you enter a date, a dollar amount, and a client to bill for the postage. My problem is what if I have multiple clients, billed to a single expense.

我想改变客户的入门盒,以便一对多个客户进行分类,并按 com子进行分类,而准入将知道会收取所输入的金额,并将输入客户的数目分开。

Is this possible? Any help would be appreciated! I taught myself access for the most part and am not very savvy.

Answer 1

请允许我首先指出,这并不是一个好的想法,但是,如果要由您个人使用,你就可以利用传统做法来分割描述和计算案文,根据约束性领域是如何建立的,你可能会遇到一些问题。

我建议的是一个清单箱、两个文本箱和一个次表。采用变形名单箱,你可以选择一个或多个客户。少法则允许你通过名单上公布,并将记录列入每个客户的表格,日期和数额按清单分列。该表将显示用于检查的插入记录。

例如:

For Each itm In Me.ListBox.ItemsSelected
  sSQL = "INSERT INTO MyTable (ClientID, Amount, InvDate ) " _
       & "VALUES ( " & Me.ListBox.Column(0, itm) & "," _
       & Me.txtAmount / Me.ListBox.ItemsSelected.Count & ",#" _
       & Me.txtDate & "#)"
  CurrentDB.Execute sSQL, dbFailOnError
Next

Me.SubformControlName.Form.Requery

友情链接