列表框中的报告驻留在外部数据库中 [英] Reports in listbox to reside in external db

问题描述

我在选项卡表单的列表框中显示了报告。列表框的行源是：

I have reports visible in a listbox on a tabbed form. The Row Source for the listbox is:

展开 | 选择 | Wrap | 行号

推荐答案

进一步解释原因（我认为）我需要这样做：我预见如果可能的话，我希望避免将报告更新为一个问题。每个美国州每年更新一次表格（这是我报告的基础）。使用外部数据库来存储报告将允许我简单地将更新的报告通过电子邮件发送到150多个位置，并且如果我更新了主数据库中包含的特定状态报告，则可以消除任何必要的数据迁移。


这有什么意义吗？作为Access的新手，也许我错过了一些东西。好的，所以我将TblReports导出到外部数据库。从主数据库中，我设置了导出表的链接。我保留了相同的名称TblReports （不知道这是否会引起问题）。这里是列表框的行源：

Further explanation on why (I think) I need to do this: I foresee updating the reports as an issue I wish to avoid if possible. Each U.S. State updates their forms (which are the basis of my reports) annually. Using an external db to house the reports would allow me to simply email the updated reports to the 150+ locations, and eliminate any data migration that would be necessary if I updated the State-specific reports housed in their main db.

Does this make any sense? Being very new to Access, maybe I''m missing something. Ok, so I exported TblReports to an external db. From the main db, I setup a link to the exported table. I kept the same name "TblReports" (don''t know if this will cause issues). Again here is the row source for the listbox:

展开 | 选择 | Wrap | 行号

我还没试过这个，但你可以' 链接到外部数据库中的表，然后执行联合查询以填充列表框。

I haven''t actually tried this, but you can ''Link'' to the Table in the External Database, then perform a Union Query to populate your List Box.

感谢ADezii，这正是我做的，它运作良好。我现在已经创建了一个表单，允许用户选择链接的mdb的路径并且它正在工作。但是，我希望表单上的列表框能够显示当前链接的mdb的完整路径。我试过

Thanks ADezii, that''s exactly what I did and it works well. I''ve now created a form to allow a user to select the path to the linked mdb and it''s working. However, I would like a listbox on the form that would show the full path to the current linked mdb. I''ve tried

展开 | 选择 | Wrap | 行号

这篇关于列表框中的报告驻留在外部数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！