变量已经存在 [英] Variable already exist

问题描述

Hello everyone，


我正在开发一个软件来从2个单独的表中加载数据。每次加载数据时，我都希望将每个表的最大值（日期/时间）记录到调度程序表（第三个表）中。


我已将此代码放入点击事件。但是，每次我点击按钮，数据不会像它应该加载，但我得到变量已存在错误访问。我正在使用Access进行这项工作。


我需要帮助。下面是我的代码：

展开 | 选择 | Wrap | 行号

解决方案

移至访问论坛，驻地专家可以更好地协助你好。


**从编程挑战中移出。

您使用的是ADO还是DAO并且引用了相应的库？

我正在使用DAO。非常感谢您的回复。

Hello Everyone,

I am developing a software to load data from 2 separate tables. Each time data is loaded, i want to log the max (date/time) of each table into a scheduler table (third table).

I have put this code in an "on click" event. However, each time i click on the button, the data doesnt load like it is supposed to but i get variable already exist error from access. I am using Access for this work.

I need help. Below is my code:

Expand|Select|Wrap|Line Numbers

解决方案

Moved to the Access Forums where the resident experts can better assist you.

**Moved from Programming challenges.

Are you using ADO or DAO and have you got the appropriate library referenced?

i am using DAO. Your response is deeply appreciated.

这篇关于变量已经存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！