473,322 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Object invaliad or no longer set error after onverting from Access 97 to 2000

Hello
I have a very complex database application, which have been working
fine for several years in Access 97. Now I had to convert it into
Access 2000.
The main form (course) has got 2 subforms. One subform (course
occurrence) has got 4 subforms of its own, another subform (course web
description) has got 1. The main form has got navigation buttons,
occurrence subform has got navigation buttons (there can be several
occurrences of the course) and one of the second level subforms
(qualifications) has got own navigation buttons. The navigation
buttons are from Access 97 Developer's Handbook by Litwin, Getz and
Gilbert. In Access 97 version of the application these custom
navigation buttons were a blessing, now it is a pain.
Quite a lot of VBA code (including Navigation module from Developer's
Handbook) uses a concept of recordsetclone. As long as one navigates
through the form, it's OK. But every other action: opening of another
form, for example, then the return to the course form, and here it is:
Object invalid and no longer set.
I have commented all "On Error..." statements throughout the code to
catch, what generates the error. The problem seems to be
recordsetclone, and not set recordsetclone command itself, but next
after it, for example in module Navigation:
Function adhEnableButtons(frm As Form)
'
' Attached to the specified form's Current event.
'
' This function enables and disables buttons as
' necessary, depending on which is the current
' record on the form.
'
' This function counts on buttons named cmdFirst,
' cmdPrev, cmdNext, cmdLast and cmdNew. One
' could code around this, but it seemed like
' overkill for this example.
'
' In:
' frm: A reference to the form in question.
' Out:
' Nothing

Dim rst As DAO.Recordset
Dim fAtNew As Integer
Dim fUpdatable As Integer
'The following command and label is added by me - Galina
'On Error GoTo TheEnd:
frm!txtCurrRec = frm.CurrentRecord
Set rst = frm.RecordsetClone
rst.MoveLast

After one returns to the courses form, rst.MoveLast throws the
application out.
I really wouldn't like to change navigation buttons. What can I do?
Any help would be greatly appreciated.
I believe, I have service pack 7 for jet installed on my PC:
4.0.7328.0
Galina
Nov 12 '05 #1
2 1842
First thing to try is Jet 4 SP8 (version 4.0.8015).
Download from support.microsoft.com

Also make sure you have Office 2000 SP3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Galina" <ga****@mail.ru> wrote in message
news:ec*************************@posting.google.co m...
Hello
I have a very complex database application, which have been working
fine for several years in Access 97. Now I had to convert it into
Access 2000.
The main form (course) has got 2 subforms. One subform (course
occurrence) has got 4 subforms of its own, another subform (course web
description) has got 1. The main form has got navigation buttons,
occurrence subform has got navigation buttons (there can be several
occurrences of the course) and one of the second level subforms
(qualifications) has got own navigation buttons. The navigation
buttons are from Access 97 Developer's Handbook by Litwin, Getz and
Gilbert. In Access 97 version of the application these custom
navigation buttons were a blessing, now it is a pain.
Quite a lot of VBA code (including Navigation module from Developer's
Handbook) uses a concept of recordsetclone. As long as one navigates
through the form, it's OK. But every other action: opening of another
form, for example, then the return to the course form, and here it is:
Object invalid and no longer set.
I have commented all "On Error..." statements throughout the code to
catch, what generates the error. The problem seems to be
recordsetclone, and not set recordsetclone command itself, but next
after it, for example in module Navigation:
Function adhEnableButtons(frm As Form)
'
' Attached to the specified form's Current event.
'
' This function enables and disables buttons as
' necessary, depending on which is the current
' record on the form.
'
' This function counts on buttons named cmdFirst,
' cmdPrev, cmdNext, cmdLast and cmdNew. One
' could code around this, but it seemed like
' overkill for this example.
'
' In:
' frm: A reference to the form in question.
' Out:
' Nothing

Dim rst As DAO.Recordset
Dim fAtNew As Integer
Dim fUpdatable As Integer
'The following command and label is added by me - Galina
'On Error GoTo TheEnd:
frm!txtCurrRec = frm.CurrentRecord
Set rst = frm.RecordsetClone
rst.MoveLast

After one returns to the courses form, rst.MoveLast throws the
application out.
I really wouldn't like to change navigation buttons. What can I do?
Any help would be greatly appreciated.
I believe, I have service pack 7 for jet installed on my PC:
4.0.7328.0
Galina

Nov 12 '05 #2
Allen
Thank you very much! It worked!!!
Galina

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
First thing to try is Jet 4 SP8 (version 4.0.8015).
Download from support.microsoft.com

Also make sure you have Office 2000 SP3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Galina" <ga****@mail.ru> wrote in message
news:ec*************************@posting.google.co m...
Hello
I have a very complex database application, which have been working
fine for several years in Access 97. Now I had to convert it into
Access 2000.
The main form (course) has got 2 subforms. One subform (course
occurrence) has got 4 subforms of its own, another subform (course web
description) has got 1. The main form has got navigation buttons,
occurrence subform has got navigation buttons (there can be several
occurrences of the course) and one of the second level subforms
(qualifications) has got own navigation buttons. The navigation
buttons are from Access 97 Developer's Handbook by Litwin, Getz and
Gilbert. In Access 97 version of the application these custom
navigation buttons were a blessing, now it is a pain.
Quite a lot of VBA code (including Navigation module from Developer's
Handbook) uses a concept of recordsetclone. As long as one navigates
through the form, it's OK. But every other action: opening of another
form, for example, then the return to the course form, and here it is:
Object invalid and no longer set.
I have commented all "On Error..." statements throughout the code to
catch, what generates the error. The problem seems to be
recordsetclone, and not set recordsetclone command itself, but next
after it, for example in module Navigation:
Function adhEnableButtons(frm As Form)
'
' Attached to the specified form's Current event.
'
' This function enables and disables buttons as
' necessary, depending on which is the current
' record on the form.
'
' This function counts on buttons named cmdFirst,
' cmdPrev, cmdNext, cmdLast and cmdNew. One
' could code around this, but it seemed like
' overkill for this example.
'
' In:
' frm: A reference to the form in question.
' Out:
' Nothing

Dim rst As DAO.Recordset
Dim fAtNew As Integer
Dim fUpdatable As Integer
'The following command and label is added by me - Galina
'On Error GoTo TheEnd:
frm!txtCurrRec = frm.CurrentRecord
Set rst = frm.RecordsetClone
rst.MoveLast

After one returns to the courses form, rst.MoveLast throws the
application out.
I really wouldn't like to change navigation buttons. What can I do?
Any help would be greatly appreciated.
I believe, I have service pack 7 for jet installed on my PC:
4.0.7328.0
Galina

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: mcmg | last post by:
Hi, I have an asp app that works fine on a windows xp machine but does not work on a windows 2000 server. I have the following code in my global.asa: <OBJECT RUNAT=Server SCOPE=SESSION...
11
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
7
by: deko | last post by:
I'm getting intermittent "Object Invalid or No Longer Set" errors in my Access 2002 mdb. What causes these errors? Has anyone dealt with this before? I can't trace it because it's not easy...
7
by: (Pete Cresswell) | last post by:
We were testing a version of our app that's been running for months with no problems and it started throwing "Object no longer exists" messages on two machines in the test environment. We tried...
2
by: TSanders | last post by:
Hello everyone, I hope someone here can help. I created an application in MSAccess 2000 using VBA for a local telco to track their DSL orders. The database is split into a front end and a back...
26
by: yb | last post by:
Hi, Is there a standard for the global 'window' object in browsers? For example, it supports methods such as setInterval and clearInterval, and several others. I know that w3c standardized...
0
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
2
by: 4bex | last post by:
Hello there, I am trying to get to the bottom of an 'Object invalid or no longer set' issue, but I am not a database programmer. We have approx 20 users on MS Access 2002 front...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.