将Allen Browne的代码链接到Northwind [英] Linking Allen Browne's code to Northwind
问题描述
Northwind订单输入应用程序数据库非常棒！
---------------------- -------------------
但缺少一件事：实时库存数量计算！
- ---------------------------------------
我知道这个话题已经讨论过&在论坛中，但我还没有找到任何显示以下内容的人：
-----------------
1）将Allen Browne的代码链接到Northwind？然后一个
2）库存报告显示产品和&手头数量等
-----------------
Allen Browne链接显示样本表格布局&代码，但我有点b $ b麻烦看到如何将此代码连接到Northwind或订单分录
数据库样本。
- 他的示例有一个tblInvoiceDetail表，其中有一个名为Quantity的字段。
- 这与我现有的tblOrderDetails有什么关系？
数量？
- 我在哪里或如何创建库存报告？
提前感谢您的帮助！
jlig
***通过开发人员指南 http://www.developersdex.com 发送** *
Jerry Alexander写道：
Northwind订单输入应用程序数据库很棒！
至少有一位开发人员认为Northwind和Solutions数据库
是世界上最丑陋，最低效的创作。
-
-
Lyle
"那些试图控制思想的人的目标始终如一。他们
找到一个世界的单一解释，一个思想系统和
行动将（他们相信）涵盖一切;然后他们试着将b $ b强加给所有有思想的人。
- Gilbert Highet
Northwind has OrderDetails表中的产品数量，但是，当您收到产品时，
缺少处理产品采购的表格
以响应采购订单。 />
您需要为采购订单和收到的货物添加表格
（采购），以便您的数据库具有
等式。
-
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http：// allenbrowne.com/tips.html
回复群组，而不是mvps dot org的allenbrowne。
Jerry Alexander < JE *** @ gospeland.com>在消息中写道
新闻：V5 ************* @ news.uswest.net ...
罗斯文订单输入应用程序数据库很棒！
--------------------------------------- -
但有一件事是缺乏的：实时库存数量计算！
--------------------------- --------------
我知道这个话题已经讨论过&在论坛上，但我还没有发现任何显示以下内容的人：
-----------------
1）链接艾伦Browne的代号是Northwind？然后一个
2）库存报告显示产品和&手头数量等
-----------------
艾伦布朗链接显示了一个示例表格布局&代码，但我在查看如何将此代码连接到Northwind或Order Entry
数据库示例时遇到了麻烦。
- 他的示例有一个tblInvoiceDetail表，其中包含一个字段数量。
- 这与我现有的还有数量的tblOrderDetails有什么关系？
- 我在哪里或如何创建库存报告？
提前致谢为了你的帮助！
jlig
艾伦，我过去已经建立了商业应用程序，但从来没有
处理库存数量和库存现有报告。因此，当我查看您的代码以及如何将其与我的
数据库相关联时，我承认
非常弱。
我拿走了你的桌子和字段样本，创建表格&链接
字段。
我还拿出了你的tblProduct表&将您的其他表
直接链接到我现有的tblProducts ProductID字段。一切看起来都很好B.
对我来说很好。
---------------------------- ---------
现在由于我的无知，我如何将你的代码合并到我的数据库中？
---------- ---------------------------
- 我是否用命令创建了一个表单？
- 我是否要创建一个新的Module1？
------------------------------ -------
感谢您的帮助！
ps：你有没有提供这段代码作为样本mdb？
再次感谢，
jlig
***通过Developersdex发送 http://www.developersdex.com ***
The Northwind Order Entry Application database is great!
-----------------------------------------
But one thing is lacking: Real-time Stock Qty calculation!
-----------------------------------------
I know that this topic has been discussed over & over in forums, but I
have yet to find anyone that has shown the following:
-----------------
1) Linking Allen Browne''s code to Northwind? then an
2) Inventory report to show Products & Qty-On-Hand, etc.
-----------------
The Allen Browne link shows a sample table layout & code but I''m having
trouble seeing how to connect this code to a Northwind or Order Entry
database sample.
- His example has a tblInvoiceDetail table with a field called Quantity.
- How does this relate to my existing tblOrderDetails that also has
Quantity?
- Where or how do I create an Inventory Report?
Thanks in advance for your help!
jlig
*** Sent via Developersdex http://www.developersdex.com ***
Jerry Alexander wrote:
The Northwind Order Entry Application database is great!
At least one developer thinks that the Northwind and Solutions databases
are among the world''s ugliest and most inefficient creations.
--
--
Lyle
"The aim of those who try to control thought is always the same. They
find one single explanation of the world, one system of thought and
action that will (they believe) cover everything; and then they try to
impose that on all thinking people."
- Gilbert Highet
Northwind has the quantity of the product in the OrderDetails table, but it
lacks the tables to handle the acquisition of products when you receive them
in response to a purchase order.
You will need to add the tables for purchase orders and goods received
(acquisition) so that your database has both the in and out sides of the
equation.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jerry Alexander" <je***@gospeland.com> wrote in message
news:V5*************@news.uswest.net...
The Northwind Order Entry Application database is great!
-----------------------------------------
But one thing is lacking: Real-time Stock Qty calculation!
-----------------------------------------
I know that this topic has been discussed over & over in forums, but I
have yet to find anyone that has shown the following:
-----------------
1) Linking Allen Browne''s code to Northwind? then an
2) Inventory report to show Products & Qty-On-Hand, etc.
-----------------
The Allen Browne link shows a sample table layout & code but I''m having
trouble seeing how to connect this code to a Northwind or Order Entry
database sample.
- His example has a tblInvoiceDetail table with a field called Quantity.
- How does this relate to my existing tblOrderDetails that also has
Quantity?
- Where or how do I create an Inventory Report?
Thanks in advance for your help!
jlig
Allen, I have built business applications in the past but never had to
deal with Stock Quantity and Inventory On-Hand reports. So I admit to
being very weak when I look at your code and how to relate it to my
database.
I have taken your table & fields samples, created the tables & linked
the fields.
I also took out your tblProduct table & linked your other tables
directly to my existing tblProducts ProductID field. Everything looks
fine to me.
-------------------------------------
Now for my ignorance, how do I incorporate your code into my database?
-------------------------------------
- Do I create a form with a command buton?
- Do I create a new Module1 ?
-------------------------------------
Thanks for the help!
ps: Have you ever provided this piece of code as a sample mdb?
Thanks again,
jlig
*** Sent via Developersdex http://www.developersdex.com ***
这篇关于将Allen Browne的代码链接到Northwind的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
