Deleting Stuff

M

Morris.C

This isn't a serious question, I'm just interested in WHY?

When I go through our database and delete obsolete/out-dated tables,
queries and forms, Access doesn't seem to just highlight the next element
but seems to jump randomly to wherever it wants!

eg. If I delete qry_1_backup, Access won't just move to qry_2, but might
jump down to qry_197! WHY?
qry_1
qry_1_backup
qry_2
qry_2_backup
qry_3
qry_4.......qry200

WHY?
 
V

Van T. Dinh

Access usually just move the focus to the next object in the list. Note
that you are thinking numerically for the digits but to Access they are
_characters_ and not number is this context. So, if you sort (ascendingly)
the Queries by name, this is what you get (for example):

qry_1
qry_197
qry_199999999999
qry_1_backup
qry_2
.....
 
M

Morris.C

Access usually just move the focus to the next object in the list.
Note that you are thinking numerically for the digits but to Access
they are _characters_ and not number is this context. So, if you sort
(ascendingly) the Queries by name, this is what you get (for example):

qry_1
qry_197
qry_199999999999
qry_1_backup
qry_2
....
Click to expand...

I just used qry_1..>..qry200 as an example.
I'll use actual queries:

qry_NJNSDCN_01
qry_NJNSDCN_01_old
qry_NJNSDCN_02
qry_NSD_01
qry_NSD_02.......(lots of different queries)....>
qry_R_S_T_X

I deleted 'qry_NJNSDCN_01_old', Access jumped to qry_R_S_T_X
What has that got to do with how Access treats numbers!?
(And by the way, the ARE SORTED BY NAME!)
 
V

Van T. Dinh

In my case, Access (2002) jumps to "qry_NJNSDCN_02" in your sample names.

When you compare String, "199999" is less than "2". Lots of users think
numerically and conclude (incorrectly) that "199999" is greater than "2".
 
P

punchy

Hi guys Talking about deleting, I'm having trouble trying to delete a "Show
All" sign from my Microsoft 2000. Every time I open a docket this sign which
is a bit like a musical note that is upside down keeps on showing up. Even if
I look back on older docket it still come up. Any Ideas on how to get rid of
it. Punchy
 
J

Joan Wild

Morris.C said:
I just used qry_1..>..qry200 as an example.
I'll use actual queries:

qry_NJNSDCN_01
qry_NJNSDCN_01_old
qry_NJNSDCN_02
qry_NSD_01
qry_NSD_02.......(lots of different queries)....>
qry_R_S_T_X

I deleted 'qry_NJNSDCN_01_old', Access jumped to qry_R_S_T_X
Click to expand...

It's possible that it is jumping based on Date Created or Date Modified.
 
J

Joan Wild

punchy said:
Hi guys Talking about deleting, I'm having trouble trying to delete a
"Show All" sign from my Microsoft 2000. Every time I open a docket
this sign which is a bit like a musical note that is upside down
keeps on showing up. Even if I look back on older docket it still
come up. Any Ideas on how to get rid of it. Punchy
Click to expand...

I'm having trouble understanding what you are talking about, but I'll take a
guess.

First, are you talking about Word, and the 'paragraph mark'? Do you see
that same symbol on your toolbar (and it's enabled)? If so, just click that
button to disable the symbols. These will show you your tabs, spaces, and
paragraph marks (among other things).

You asked this question in a newsgroup about Access, the database product.
There are many Word newsgroups available that all start with
microsoft.public.word should my answer not have helped.
 
P

punchy

Joan Wild said:
I'm having trouble understanding what you are talking about, but I'll take a
guess.

First, are you talking about Word, and the 'paragraph mark'? Do you see
that same symbol on your toolbar (and it's enabled)? If so, just click that
button to disable the symbols. These will show you your tabs, spaces, and
paragraph marks (among other things).

You asked this question in a newsgroup about Access, the database product.
There are many Word newsgroups available that all start with
microsoft.public.word should my answer not have helped.
Click to expand...

Hi Joan
First of all I apologise for taking so long to reply but was taken ill and
had to be rushed down to Perth from Carnarvon W.A. for treatment. Thankfully
I am OK now. Regarding your help re my query yes you were on the right track,
the only difference being was that the symbol you wrote about was not on the
tool bar but after a search I did find it and was able to disable and cure
the problem, so thank you once again for your help Punchy
 
J

Joan Wild

punchy said:
Hi Joan
First of all I apologise for taking so long to reply but was taken
ill and had to be rushed down to Perth from Carnarvon W.A. for
treatment. Thankfully I am OK now. Regarding your help re my query
yes you were on the right track, the only difference being was that
the symbol you wrote about was not on the tool bar but after a search
I did find it and was able to disable and cure the problem, so thank
you once again for your help Punchy
Click to expand...

You're welcome; glad to hear you are OK.
 
Top