conversion issue 97 to 2000

[EG]

I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

 

[Sandra Daigle]

There is a known issue with Access 97 (And Access 2000 pre-SR1 I believe)
which causes this when in VBA you make in implicit reference to the value of
checkbox using code like 'if me.fCheckbox then' instead of 'if me.fCheckbox
= true'. There are also cases where failing to close and destroy recordsets
can create a lost instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;164455


Also, on occassion I find this happens when the VB project becomes corrupt.
This can usually be fixed by decompiling the project.

 

[EG]

How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG

-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I believe)
which causes this when in VBA you make in implicit reference to the value of
checkbox using code like 'if me.fCheckbox then' instead of 'if me.fCheckbox
= true'. There are also cases where failing to close and destroy recordsets
can create a lost instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project becomes corrupt.
This can usually be fixed by decompiling the project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

 

[Sandra Daigle]

Here are a few links on decompile. They are written for Access97 but the
same method works for Access2000 and Access2002. Be sure to make a copy of
your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb;[LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG

-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project becomes
corrupt. This can usually be fixed by decompiling the project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

 

[EG]

Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?

-----Original Message-----
Here are a few links on decompile. They are written for Access97 but the
same method works for Access2000 and Access2002. Be sure to make a copy of
your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG

-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project becomes
corrupt. This can usually be fixed by decompiling the project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

 

[Sandra Daigle]

I'm not quite sure I understand your question - are you asking whether the
autonum field could create the problem? If so, I would say no - I haven't
had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?

-----Original Message-----
Here are a few links on decompile. They are written for Access97 but
the same method works for Access2000 and Access2002. Be sure to make
a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project becomes
corrupt. This can usually be fixed by decompiling the project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

 

[EG]

Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking whether the
autonum field could create the problem? If so, I would say no - I haven't
had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?

-----Original Message-----
Here are a few links on decompile. They are written for Access97 but
the same method works for Access2000 and Access2002. Be sure to make
a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project becomes
corrupt. This can usually be fixed by decompiling the project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

.

 

[EG]

recompile didnt resolve the issue ...

-----Original Message-----
Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking whether the
autonum field could create the problem? If so, I would say no - I haven't
had any issues with AutoNums causing this problem.

Was there an error?

this

newsgroup.

Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97 but
the same method works for Access2000 and Access2002. Be sure to make
a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There

are
also cases scid=kb;en-

us;164455

to

this

the

task

.

.

 

[Sandra Daigle]

Good luck - you know where to find me!

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking
whether the autonum field could create the problem? If so, I would
say no - I haven't had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97
but the same method works for Access2000 and Access2002. Be sure
to make a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en- us;164455


Also, on occassion I find this happens when the VB project
becomes corrupt. This can usually be fixed by decompiling the
project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

.

 

[Sandra Daigle]

Post the code in your form (and in any subforms).

One other thing to try is to create a new mdb and import all of your
existing objects into the new mdb. Sometimes this is a better way to remove
corruption.


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

recompile didnt resolve the issue ...

-----Original Message-----
Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking whether
the autonum field could create the problem? If so, I would say no - I
haven't had any issues with AutoNums causing this problem.

Was there an error?

this

newsgroup.


EG wrote:
Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97 but
the same method works for Access2000 and Access2002. Be sure to make
a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There

are
also cases

where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?

scid=kb;en-

us;164455


Also, on occassion I find this happens when the VB project becomes
corrupt. This can usually be fixed by decompiling the project.

to

this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in

the

task
list. help!

.

.

.

.

 

[EG]

I've uncovered the culprit(s) to my problem - having been
able to create a new form and add some controls and create
the problem again.

So, now how to fix. Please help - even if its just to
point me in the right direction :=)

I have a field,[AgeAtPresentation], in table, [Patient
Info].
In table, [Patient Info], are also the fields, [Date of
Initial Encounter] and [Date of Birth].

AgeAtPresentation is calculated using the values the end
user puts in for [Date of Initial Encounter] and [Date of
Birth].

How do I do that on a form? The way I currently do it
leaves MSAccess.exe running in the task list for Access
2000. It doesnt do it for Access 97. Here is my email,
(e-mail address removed). Thanks

-----Original Message-----
Good luck - you know where to find me!

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking
whether the autonum field could create the problem? If so, I would
say no - I haven't had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97
but the same method works for Access2000 and Access2002. Be sure
to make a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?

scid=kb;en-
us;164455

Also, on occassion I find this happens when the VB project
becomes corrupt. This can usually be fixed by decompiling the
project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

.

.

 

[EG]

:=)

Problem resolved!!!! Or more precisely, worked around my
lack of expertise. Thank you for all of your help!

-----Original Message-----
Good luck - you know where to find me!

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)

-----Original Message-----
I'm not quite sure I understand your question - are you asking
whether the autonum field could create the problem? If so, I would
say no - I haven't had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97
but the same method works for Access2000 and Access2002. Be sure
to make a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx?

scid=kb;en-
us;164455

Also, on occassion I find this happens when the VB project
becomes corrupt. This can usually be fixed by decompiling the
project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

.

.

 

[Sandra Daigle]

Glad you've got is resolved - what was the code that was causing the
problem?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

:=)

Problem resolved!!!! Or more precisely, worked around my
lack of expertise. Thank you for all of your help!

-----Original Message-----
Good luck - you know where to find me!

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Yea, I thought perhaps with converting autonum fields may
get fubarred or something. There's no err msg happening
at all.

I am off to try the recompile and if that doesnt work,
perhaps I'll post my table layout and what little code is
behind the form - maybe its something I am overlooking
(implicit reference, etc..)

thanks for help so far
:=)



-----Original Message-----
I'm not quite sure I understand your question - are you asking
whether the autonum field could create the problem? If so, I would
say no - I haven't had any issues with AutoNums causing this problem.

Was there an error?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


EG wrote:
Before doing the recompile ... the form that seems to
cause this problem is for inputting data to the only table
in my datbase that has as its primary key an AutoNumber
field ... could that be part of the problem?


-----Original Message-----
Here are a few links on decompile. They are written for Access97
but the same method works for Access2000 and Access2002. Be sure
to make a copy of your mdb before you decompile.

http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
http://support.microsoft.com/default.aspx?scid=kb; [LN];279334

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.


EG wrote:
How do you decompile a VB project?
And thanks ... I have narrowed this "lost instance" to
occur when one particular form is opened.
:=)
EG
-----Original Message-----
There is a known issue with Access 97 (And Access 2000 pre-SR1 I
believe) which causes this when in VBA you make in implicit
reference to the value of checkbox using code
like 'if me.fCheckbox
then' instead of 'if me.fCheckbox = true'. There are also cases
where failing to close and destroy recordsets can create a lost
instance of Access.

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/?kbid=190074

ACC: Problems Quitting Microsoft Access
http://support.microsoft.com/default.aspx? scid=kb;en-
us;164455


Also, on occassion I find this happens when the VB project
becomes corrupt. This can usually be fixed by decompiling the
project.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

EG wrote:
I converted my app from Access 97 to access 2000. now when
i quit the application, msaccess.exe remains in the task
list. help!

.

.

.