problem in deleting a range of info

  • Thread starter Thread starter Tan Shi yun via AccessMonster.com
  • Start date Start date
T

Tan Shi yun via AccessMonster.com

Hi,
Actually i'm doing a project for a company on access'97... and the
project is done but i was required to find a bug which i can't find... the
problem goes like this: i went into the main menu and went to click the
button on delete record ... it came out a deletion form and was prompt on
whether to delete a range of bearer or the whole bearer... as i click the
certain range which i wanted to delete... well, the parent name came out
correctly but the child name came out wrongly in the Child bearer
information part... i was required to click "next button" to get to the
correct information which i wanted to delete...
 
Hi,
Actually i'm doing a project for a company on access'97... and the
project is done but i was required to find a bug which i can't find... the
problem goes like this: i went into the main menu and went to click the
button on delete record ... it came out a deletion form and was prompt on
whether to delete a range of bearer or the whole bearer... as i click the
certain range which i wanted to delete... well, the parent name came out
correctly but the child name came out wrongly in the Child bearer
information part... i was required to click "next button" to get to the
correct information which i wanted to delete...
Click to expand...

You're assuming that someone here knows anything about the code behind
the delete record button or the deletion form.

The "child name came out wrongly in the child bearer information part"
might be meaningful to you, but it is not Access terminology and has
absolutely no information content for me!

Could you please post the code, and a description (in terms of Tables,
records, and error messages) of your problem, bearing in mind that you
can see your screen and presumably understand your application's
jargon, whereas we cannot and do not?

John W. Vinson[MVP]
 
Sorry... i didnt really get what you mean by "post the code, and a
description (in terms of Tables,records, and error messages) of your
problem". The info can be deleted but deleting the wrong info... and it
doesnt have error messages. Do you mean by showing the SQL statement to you?
 
Sorry... i didnt really get what you mean by "post the code, and a
description (in terms of Tables,records, and error messages) of your
problem". The info can be deleted but deleting the wrong info... and it
doesnt have error messages. Do you mean by showing the SQL statement to you?
Click to expand...

YOur original message:

==================================================================
Actually i'm doing a project for a company on access'97... and the
project is done but i was required to find a bug which i can't find...
the problem goes like this: i went into the main menu and went to
click the button on delete record ... it came out a deletion form and
was prompt on whether to delete a range of bearer or the whole
bearer... as i click the certain range which i wanted to delete...
well, the parent name came out correctly but the child name came out
wrongly in the Child bearer information part... i was required to
click "next button" to get to the correct information which i wanted
to delete...
==================================================================

You have a "main menu"; I presume this is an Access form.
You click the "button on delete record" - this is presumably a button
on that form, which executes a Macro or some VBA code.
You say "it came out a deletion form and was prompt on whether to
delte a range of bearer" - I have no idea what a "bearer" is; and
here's another form which you can see, but I cannot.

And on and on.

You have Forms, VBA Code, Queries which are doing these operations
(incorrectly, it would appear). You would like us to figure out why
the forms, code, queries are not working correctly.

We cannot do so, because we have no way of knowing what is IN the
code. We're not telepathic, and we're not magicians!

Please open these Forms in design view, and post the VBA code which is
executed by your "delete button" - or post a clearer explanation of
what you are doing.


John W. Vinson[MVP]
 
Back
Top