Please help me with access

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

re: Please help me with access

"Jiador" <laverf@hotmail.com> wrote in message
news:b2c1fef.0401161316.28cd8472@posting.google.co m...[color=blue]
> 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[/color]


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

re: Please help me with access

Perhaps you imported your data twice?
Did you look again in your table AFTER it reported the larger number of
records?

- Turtle
"Jiador" <laverf@hotmail.com> wrote in message
news:b2c1fef.0401161316.28cd8472@posting.google.co m...[color=blue]
> 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[/color]

re: Please help me with access

"H1Bs Go Home" <nocrap@nocrap.com> wrote
[color=blue]
> Go ...[/color]

This troll-spew was posted from the semi-anonymous news server "teranews",
known to be used by Don P Mellon.

re: Please help me with access

"Larry Linson" <bouncer@localhost.not> wrote in message
news:NP1Ob.3784$9U6.1711@nwrddc02.gnilink.net...[color=blue]
> "H1Bs Go Home" <nocrap@nocrap.com> wrote
>[color=green]
> > Go ...[/color]
>
> This troll-spew was posted from the semi-anonymous news server "teranews",
> known to be used by Don P Mellon.
>[/color]


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

Karl Luft,
Senior Systems Engineer
Connext Corp.

re: Please help me with access

"Karl Luft" <karl1001@hotmail.com> wrote
[color=blue]
> AFAIK, his record at being honest is
> a lot better than yours, ...[/color]

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.

re: Please help me with access

"Larry Linson" <bouncer@localhost.not> wrote in message
news:dnkOb.2816$MV4.1407@nwrddc03.gnilink.net...[color=blue]
> "Karl Luft" <karl1001@hotmail.com> wrote
>[color=green]
> > AFAIK, his record at being honest is
> > a lot better than yours, ...[/color]
>
> This, too, was posted from the semi-anonymous news server "teranews",[/color]
known[color=blue]
> 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[/color]
defend[color=blue]
> 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.
>[/color]


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

re: Please help me with access

"H1Bs Go Home" <nocrap@nocrap.com> wrote in message
news:32a8eba1909c1e5747d419634ef4b693@news.teranew s.com...[color=blue]
>
> Go back to where you came from, you job-stealing alien puke.
>[/color]

To Whoever--

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

(Suggestion: Stop watching Lou Dobbs MoneyLine!)

Sandy

re: Please help me with access

"Sandra McMullen" <SandyMc@hotmail.com> wrote in message
news:2965d8347dc794267896409ba4e7159d@news.teranew s.com...[color=blue]
>
> "Larry Linson" <bouncer@localhost.not> wrote in message
> news:dnkOb.2816$MV4.1407@nwrddc03.gnilink.net...[color=green]
> > "Karl Luft" <karl1001@hotmail.com> wrote
> >[color=darkred]
> > > AFAIK, his record at being honest is
> > > a lot better than yours, ...[/color]
> >
> > This, too, was posted from the semi-anonymous news server "teranews",[/color]
> known[color=green]
> > 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[/color]
> defend[color=green]
> > 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.
> >[/color]
>
>
> You're an absolute genius, Larry. But why are you wasting your time[/color]
trying[color=blue]
> to do database work? You ought to be working for the FBI or maybe the[/color]
CIA.[color=blue]
> The intelligence community needs your talents!
>
> Teranews +Karl Luft+HotMail=Don P Mellon
>
> God, that's brilliant!
>
> Sandy[/color]

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.

re: Please help me with access

"Larry Linson" <bouncer@localhost.not> wrote in message
news:uKEOb.18889$ko5.540@nwrddc01.gnilink.net...[color=blue]
> "Sandra McMullen" <SandyMc@hotmail.com> wrote in message
> news:2965d8347dc794267896409ba4e7159d@news.teranew s.com...[color=green]
> >
> > "Larry Linson" <bouncer@localhost.not> wrote in message
> > news:dnkOb.2816$MV4.1407@nwrddc03.gnilink.net...[color=darkred]
> > > "Karl Luft" <karl1001@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",[/color]
> > known[color=darkred]
> > > to be used by Don P Mellon. And, of course, if it were, perchance, Don[/color][/color][/color]
P[color=blue][color=green][color=darkred]
> > > Mellon posting under the pseudonym of "Karl Luft", we'd expect him to[/color]
> > defend[color=darkred]
> > > 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.
> > >[/color]
> >
> >
> > You're an absolute genius, Larry. But why are you wasting your time[/color]
> trying[color=green]
> > to do database work? You ought to be working for the FBI or maybe the[/color]
> CIA.[color=green]
> > The intelligence community needs your talents!
> >
> > Teranews +Karl Luft+HotMail=Don P Mellon
> >
> > God, that's brilliant!
> >
> > Sandy[/color]
>
> How about Teranews + Hotmail + Sandy = Teranews + Hotmail + Karl Luft?[/color]
You[color=blue]
> never give up, do you?
>
> The posts by "Sandy McMullen" also were from teranews with a return[/color]
address[color=blue]
> at hotmail, the very same combination known to have been used in the past[/color]
by[color=blue]
> Don P Mellon.
>[/color]


Cuckoo:::Cuckoo:::Cuckoo

re: Please help me with access

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

re: Please help me with access

"Sandra McMullen" wrote
[color=blue]
> Cuckoo:::Cuckoo:::Cuckoo[/color]

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.