请帮助我访问 [英] Please help me with access
问题描述
你好
我是Access的新手，我遇到了这个问题。
我创建了一个带有加载表的数据库他的数据来自txt文件
并且一切正常好
我有76条记录，它在我的数据库中很好地获取了当我
显示一切都很好。
现在我的宏...我添加了一个SQL代码，删除了表中
中的所有记录加载新数据。
有76条记录，但它告诉我它要删除152条记录。
但是我之前显示了表格数据而且只看到了我的76条记录记录。
然后我创建了一个VB子计数器来计算我的表中的记录，它说
152 !!
这个他比我在我的桌子和我的txt文件中看到的双倍！？
那么请你能告诉我这是什么问题吗？
非常感谢
Jiador
" Jiad或" < LA **** @ hotmail.com>在消息中写道
news：b2 ************************* @ posting.google.co m ... < blockquote class =post_quotes>你好
我是Access的新手，我遇到了这个问题。
我创建了一个数据库，其中包含一个从中加载数据的表txt文件
并且一切正常
我有76条记录，它在我的数据库中很好地获取，当我显示它时一切都很好。
现在在我的宏...我添加了一个SQL代码，在加载新数据之前删除表中的所有记录。
有76条记录，但它告诉我它要删除152条记录。
但我之前显示了表格数据，只看到了我的76条记录。
然后我创建了一个VB子计数器来计算我在桌子上的记录，它说了
152！ ！
这是我在表格和txt文件中看到的双倍！？
那么请你能告诉我这是什么问题吗？
非常感谢
Jiador
回到你所在的地方我，你偷工作的外星人呕吐。
也许你导入了两次你的数据？
你再看看你的表之后它报告了更多的
记录？
- Turtle
" Jiador" < LA **** @ hotmail.com>在消息中写道
news：b2 ************************* @ posting.google.co m ... < blockquote class =post_quotes>你好
我是Access的新手，我遇到了这个问题。
我创建了一个数据库，其中包含一个从中加载数据的表txt文件
并且一切正常
我有76条记录，它在我的数据库中很好地获取，当我显示它时一切都很好。
现在在我的宏...我添加了一个SQL代码，在加载新数据之前删除表中的所有记录。
有76条记录，但它告诉我它要删除152条记录。
但我之前显示了表格数据，只看到了我的76条记录。
然后我创建了一个VB子计数器来计算我在桌子上的记录，它说了
152！ ！
这是我在表格和txt文件中看到的双倍！？
那么请你能告诉我这是什么问题吗？
非常感谢
Jiador
H1Bs回家 <无**** @ nocrap.com>写了
Go ...
这个巨魔呕吐是从半匿名新闻服务器teranews发布的。 ，
已知由Don P Mellon使用。
Hello
I''m new with Access and I have this problem.
I created a database with a table that load his data from a txt file
and all works good
I have 76 records and it is well fetched in my database and when I
display it all is good.
Now in my macro... I added a SQL code that delete all the records in
the table before loading the new data.
There is 76 records but it tell me that it want to delete 152 records.
But I displayed the table data before and a saw only my 76 records.
Then I created a VB sub that count my records in my table and it said
152 !!
This his the double than what I see in my table and in my txt file !?
So please can you tell me what is the problem ?
Thank you very much
Jiador
"Jiador" <la****@hotmail.com> wrote in message
news:b2*************************@posting.google.co m...Hello
I''m new with Access and I have this problem.
I created a database with a table that load his data from a txt file
and all works good
I have 76 records and it is well fetched in my database and when I
display it all is good.
Now in my macro... I added a SQL code that delete all the records in
the table before loading the new data.
There is 76 records but it tell me that it want to delete 152 records.
But I displayed the table data before and a saw only my 76 records.
Then I created a VB sub that count my records in my table and it said
152 !!
This his the double than what I see in my table and in my txt file !?
So please can you tell me what is the problem ?
Thank you very much
Jiador
Go back to where you came from, you job-stealing alien puke.
Perhaps you imported your data twice?
Did you look again in your table AFTER it reported the larger number of
records?
- Turtle
"Jiador" <la****@hotmail.com> wrote in message
news:b2*************************@posting.google.co m...Hello
I''m new with Access and I have this problem.
I created a database with a table that load his data from a txt file
and all works good
I have 76 records and it is well fetched in my database and when I
display it all is good.
Now in my macro... I added a SQL code that delete all the records in
the table before loading the new data.
There is 76 records but it tell me that it want to delete 152 records.
But I displayed the table data before and a saw only my 76 records.
Then I created a VB sub that count my records in my table and it said
152 !!
This his the double than what I see in my table and in my txt file !?
So please can you tell me what is the problem ?
Thank you very much
Jiador
"H1Bs Go Home" <no****@nocrap.com> wrote
Go ...
This troll-spew was posted from the semi-anonymous news server "teranews",
known to be used by Don P Mellon.
这篇关于请帮助我访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
