访问97到2010转换问题 [英] Access 97 to 2010 conversion problem

问题描述

我最近将Access 97中构建的数据库转换为Access 2010. 2010年，我现在遇到窗体控件问题。控件现在声明#Name？如显示的值。我将文本框控件源设置为：

I have recently converted a database built in Access 97 to Access 2010. In 2010 I am now having a problem with an control on the form. The control now states #Name? as the shown value. I have the text box Control source set as:

展开 | 选择 | Wrap | 行号

推荐答案

最有可能cause是在转换中更改的变量名称，字段名称或表名称。我会检查所有这些引用。

The most likely cause is a variable name, field name, or table name that got changed in the conversion. I would check all those references.

我认为它与尝试直接在控件源中使用VB变量有关。你能谈谈myShop和myDate吗？它们是如何在vb环境中声明的，它们是如何以及何时设置的？

I believe it is related to trying to use a VB variable directly in the control source. Can you say a bit more about myShop and myDate? How are they declared within the vb environment, and how and when are they set?

变量是


Public myDate As Date

公共myShop为字符串


它们是通过打开的args设置加载的形式，我有一个解析函数，允许我发送多个变量。

The variables are

Public myDate As Date
Public myShop As String

They are set on load of the form through open args, I have a parse function that allows me to send multiple variables.

这篇关于访问97到2010转换问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！