MS Access：浏览文件命令按钮（VBA编译错误） [英] MS Access: Browse For File Command Button (VBA Compile Error)

问题描述

我在Windows 7上使用Access 2000，并且一直在关注如何创建浏览文件的大量示例。在文本框中显示文件路径的按钮。


这就像我找到解决方案一样接近，但是我用粗体突出显示的行有错误下面。


错误说明：

编译错误：


找不到方法或数据成员


有谁可以解释可能导致问题的原因？


我的代码如下：

I''m using Access 2000 on Windows 7, and have been following numerous examples of how to create a "Browse for file" button which displays the path of the file in a text box.

This is as close as I have come to finding a solution, and yet I have an error with the line highlighted in bold below.

The error states:

Compile Error:

Method or Data Member not found

Can anyone explain what might be causing the problem?


My code is found below:

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

推荐答案

我相信y我们的问题在第19行。你有

I believe that your problem is in line 19. You have

展开 | 选择 | Wrap | 行号

您是否设置了对Office库的引用？查看使用filedialog对象选择文件或文件夹，在Objects段落中获取更多信息。

Have you set a reference to the Office library? Look in Select file or folder using filedialog object, in the Objects paragraph for more info.

第19行当然是一个问题，但是突出显示的行（之前因BOLD标签在CODE中不能很好地显示而变得模糊不清标签）是问的问题（和笑脸的回应处理）。


你们两个都很好的工作： - ）

Line #19 certainly is a problem, but the highlighted line (which was obscure before as BOLD tags don''t show well within CODE tags) is the problem asked about (and Smiley''s response deals with that).

Good work both of you :-)

这篇关于MS Access：浏览文件命令按钮（VBA编译错误）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！