用于在目录中包含文件夹的表 - 多级 [英] Table to include folders in a directory - Multilevel
问题描述
我见过一些线程但是想在Access 2003中创建一个包含以下信息的表
地址/文件/类型/尺寸/
C：/访问/文件夹/ 375KB
C：/ TableExcel.xls / xls或excel。 / 200 KB
C：Access / Test2Access.Mdb / mdb或access / 200Kb
C：Access / TestAccess.Mdb / mdb或access / 50 Kb
C：访问/模板/文件夹/ 100KB
我不会在我的表中包含C和D驱动器中的所有文件夹和文件。
这可能。如果是这样，你可以给我一个程序来做同样的事情。我是Acess的新手。
谢谢你的帮助和支持
Hi,
I have seen some of the threads but and looking to create a table in Access 2003 with the following information
Address / File / Type / size /
C: / Access / Folder / 375KB
C: / TableExcel.xls / xls or excel. / 200 KB
C:Access / Test2Access.Mdb / mdb or access / 200Kb
C:Access / TestAccess.Mdb / mdb or access / 50 Kb
C:Access / Templates / Folder / 100KB
I wont my table to include all folders and files in both C and D drive.
Is this possible. If so can u give me a program to do the same. I am a novice to Acess.
THanks for ur help and Support
推荐答案
我们在这里不提供解决方案乔治。我们会帮助您自己学习如何做。如果你感兴趣我们可以做一定数量的手持。
你所谈论的当然是可能的。您需要更清楚地了解您的目标。你可以理解这一点（听起来可能非常有趣，如果你愿意的话）。
We don''t provide solutions here George. We help you to learn how to do it yourself. If you''re interested we can do a certain amount of hand-holding.
What you talk about is certainly possible. You would need to be clearer exactly what you are looking to do. This could all be quite involved you understand (sounds like it may be quite fun though, if you''re up for it).
感谢NeoPa的回复。
对不起，如果我听起来像是想要一个解决方案。我实际上想学习如何实现以下目标。
我真正希望实现的是一个可以创建表的代码。该表将包含当前位于C：drive multilevel中的所有文件/文件夹 该表应包含以下字段。
地址：这是地址 - 例如：C：/ Access
文件/文件夹名称 - 这是此文件夹中存在的所有文件/文件夹
类型 - 说明扩展名（.mdb，.xls或者如果它是一个文件夹）
大小 - 说明项目的大小。
到目前为止我设法做到了下面的代码。这基本上会显示存储在我的C盘中的所有文件和文件夹。我正在寻找帮助来提取其他字段并使其成为多层次。当然，如果可能的话，会将我直接带到文件夹地址。希望你能教导/帮助我。
Thanks NeoPa for your response.
Sorry if I sounded like I wanted a solution. I actually wanted to learn how I could achieve the following.
Really what I am looking to achieve is a code that could create a table. The table is to include all files/folder that are currently located in C: drive multilevel)The table should have the following field.
Address: this is the address - for example: C:/Access
File/Folder name - This is all the files/folders that exist in this folder
Type - states the extension (.mdb, .xls or if it is a folder)
Size - states the size of the item.
So far I have managed to do the code below. This basically brings out all files and folders stored in my C drive. I am looking for help to extract the other fields and make it multilevel. And ofcourse if possible a Link that will take me directly to the folder address. Hope u could teach/help me.
要获得有关文件的更多信息，您可能需要使用FileSystemObject的。请参阅脚本运行时参考在MSDN上和 Microsoft Scripting Runtime＃1 来自Bytes的见解部分。
To get further information about the files, you will probably need to use the FileSystemObject. See Scripting Run-Time Reference on MSDN and Microsoft Scripting Runtime #1 from the Insights section here on Bytes.
这篇关于用于在目录中包含文件夹的表 - 多级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
