By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Please help me with access

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a

"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.

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
"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.

Nov 12 '05 #4

P: n/a

"Larry Linson" <bo*****@localhost.not> wrote in message
news:NP*****************@nwrddc02.gnilink.net...
"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.

AFAIK, his record at being honest is a lot better than yours, "Larry
Linson," semi-anonymous masturbator.

Karl Luft,
Senior Systems Engineer
Connext Corp.
Nov 12 '05 #5

P: n/a
"Karl Luft" <ka******@hotmail.com> wrote
AFAIK, his record at being honest is
a lot better than yours, ...


This, too, was posted from the semi-anonymous news server "teranews", known
to be used by Don P Mellon. And, of course, if it were, perchance, Don P
Mellon posting under the pseudonym of "Karl Luft", we'd expect him to defend
himself.

And, too, this one uses a "hotmail" e-mail address, also known to be
commonly, but not exclusively, used for Don P Mellon's pseudonyms.

Nov 12 '05 #6

P: n/a

"Larry Linson" <bo*****@localhost.not> wrote in message
news:dn*****************@nwrddc03.gnilink.net...
"Karl Luft" <ka******@hotmail.com> wrote
> AFAIK, his record at being honest is
> a lot better than yours, ...
This, too, was posted from the semi-anonymous news server "teranews",

known to be used by Don P Mellon. And, of course, if it were, perchance, Don P
Mellon posting under the pseudonym of "Karl Luft", we'd expect him to defend himself.

And, too, this one uses a "hotmail" e-mail address, also known to be
commonly, but not exclusively, used for Don P Mellon's pseudonyms.

You're an absolute genius, Larry. But why are you wasting your time trying
to do database work? You ought to be working for the FBI or maybe the CIA.
The intelligence community needs your talents!

Teranews +Karl Luft+HotMail=Don P Mellon

God, that's brilliant!

Sandy

Nov 12 '05 #7

P: n/a

"H1Bs Go Home" <no****@nocrap.com> wrote in message
news:32******************************@news.teranew s.com...

Go back to where you came from, you job-stealing alien puke.


To Whoever--

Not a very nice reply. But reality is not nice sometimes.

(Suggestion: Stop watching Lou Dobbs MoneyLine!)

Sandy
Nov 12 '05 #8

P: n/a
"Sandra McMullen" <Sa*****@hotmail.com> wrote in message
news:29******************************@news.teranew s.com...

"Larry Linson" <bo*****@localhost.not> wrote in message
news:dn*****************@nwrddc03.gnilink.net...
"Karl Luft" <ka******@hotmail.com> wrote
> AFAIK, his record at being honest is
> a lot better than yours, ...
This, too, was posted from the semi-anonymous news server "teranews",

known
to be used by Don P Mellon. And, of course, if it were, perchance, Don P
Mellon posting under the pseudonym of "Karl Luft", we'd expect him to

defend
himself.

And, too, this one uses a "hotmail" e-mail address, also known to be
commonly, but not exclusively, used for Don P Mellon's pseudonyms.

You're an absolute genius, Larry. But why are you wasting your time

trying to do database work? You ought to be working for the FBI or maybe the CIA. The intelligence community needs your talents!

Teranews +Karl Luft+HotMail=Don P Mellon

God, that's brilliant!

Sandy


How about Teranews + Hotmail + Sandy = Teranews + Hotmail + Karl Luft? You
never give up, do you?

The posts by "Sandy McMullen" also were from teranews with a return address
at hotmail, the very same combination known to have been used in the past by
Don P Mellon.
Nov 12 '05 #9

P: n/a

"Larry Linson" <bo*****@localhost.not> wrote in message
news:uK*****************@nwrddc01.gnilink.net...
"Sandra McMullen" <Sa*****@hotmail.com> wrote in message
news:29******************************@news.teranew s.com...

"Larry Linson" <bo*****@localhost.not> wrote in message
news:dn*****************@nwrddc03.gnilink.net...
"Karl Luft" <ka******@hotmail.com> wrote

> AFAIK, his record at being honest is
> a lot better than yours, ...

This, too, was posted from the semi-anonymous news server "teranews", known
to be used by Don P Mellon. And, of course, if it were, perchance, Don P Mellon posting under the pseudonym of "Karl Luft", we'd expect him to

defend
himself.

And, too, this one uses a "hotmail" e-mail address, also known to be
commonly, but not exclusively, used for Don P Mellon's pseudonyms.

You're an absolute genius, Larry. But why are you wasting your time

trying
to do database work? You ought to be working for the FBI or maybe the

CIA.
The intelligence community needs your talents!

Teranews +Karl Luft+HotMail=Don P Mellon

God, that's brilliant!

Sandy


How about Teranews + Hotmail + Sandy = Teranews + Hotmail + Karl Luft?

You never give up, do you?

The posts by "Sandy McMullen" also were from teranews with a return address at hotmail, the very same combination known to have been used in the past by Don P Mellon.

Cuckoo:::Cuckoo:::Cuckoo
Nov 12 '05 #10

P: n/a
No it's not that,
I already tried it thank you :-)

Somebody on another group told me than there can be problem with
access when we do sql things like I did.
He told me to do my things in a Access query and to run it from a
macro and it work very well :-)

So the case is cleared :-)

Jiador
Nov 12 '05 #11

P: n/a
"Sandra McMullen" wrote
Cuckoo:::Cuckoo:::Cuckoo


The referenced post was from the semi-anonymous news server teranews and
used a return address of hotmail, both known to be commonly used by Don P
Mellon.

Interestingly, this post echoes the feeling of many, including myself, about
the anonymous and semi-anonymous poster(s). In fact, someone, not long ago
in this newsgroup, expressed puzzlement at why anyone would go to such
effort to make [him|her|it]self despised by everyone else here -- I think
"Sandra" may have provided one possible answer.
Nov 12 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.