Problem with a 2000 .mde in Access2007
Thanks for reading this.
I am developing in Access2000 but the .mde has to run on a Access 2007 machine and there's some weird stuff happening so I am beginning to hate 2007 before I have had a chance to get to know it.
In my subform I have three fields used to highlight current row. In the sample below, I use two to determine if I am in the last record. No doubt this is not the most efficient but it works for me.
I need to start in record 1 then visit every record so that my code can evaluate and change the contents of some fields. In 2000 it works fine. In 2007 I get doubled up text stings and ever increasing totals.
To demonstrate my problem, this code produces a series of messages.
DoCmd.GoToRecord , , acFirst
Do While NoOfRecords > 0 'set earlier with RecordsetClone.RecordCount
If Me!ctlCurrentRecord > Me!ctlRecordCount Then Exit Do
MsgBox "LineRef " & Me!LineNumber & " Record " & Me!ctlCurrentRecord
NoOfRecords = NoOfRecords - 1
DoCmd.GoToRecord , , acNext
Loop
In Access 2000 the messages are as intended;
Line 1 Record 1
Line 2 Record 2
Line 3 Record 3.
In Access 2007 it all goes wrong;
Line 1 Record 1
Line 1 Record 2
Line 1 Record 3
It does progress down my subfrom but the focus stays in the first record. If it is happy telling me the contents of ctlCurrentRecord, why does it not tell me the content of LineRef.
I suspected the References so looked at it using A2007 and it is using the later (12) libraries. My machine uses the older libraries so I have tried to install MSACC9.OLD and MSOUTL9.OLB but running regsvr32 "C:\Program Files\Microsoft Office\Office\ MSACC9.OLB" gives a message that the entry point was not found and this does not appear to be a .dll file so I am stumped there.
On the A2007 machines I have set up Trusted Locations for the back end data and the front end but that didn't help.
Also, the Access2007 machine "lost" the data from a selection of fields. Disaster, panic, embarrassment. Then I just happened to have cause to install a fresh .mde and it all appeared again. This is weird stuff and I don't know where to start.
Thanks for reading this.
I am developing in Access2000 but the .mde has to run on a Access 2007 machine and there's some weird stuff happening so I am beginning to hate 2007 before I have had a chance to get to know it.
In my subform I have three fields used to highlight current row. In the sample below, I use two to determine if I am in the last record. No doubt this is not the most efficient but it works for me.
I need to start in record 1 then visit every record so that my code can evaluate and change the contents of some fields. In 2000 it works fine. In 2007 I get doubled up text stings and ever increasing totals.
To demonstrate my problem, this code produces a series of messages.
DoCmd.GoToRecord , , acFirst
Do While NoOfRecords > 0 'set earlier with RecordsetClone.RecordCount
If Me!ctlCurrentRecord > Me!ctlRecordCount Then Exit Do
MsgBox "LineRef " & Me!LineNumber & " Record " & Me!ctlCurrentRecord
NoOfRecords = NoOfRecords - 1
DoCmd.GoToRecord , , acNext
Loop
In Access 2000 the messages are as intended;
Line 1 Record 1
Line 2 Record 2
Line 3 Record 3.
In Access 2007 it all goes wrong;
Line 1 Record 1
Line 1 Record 2
Line 1 Record 3
It does progress down my subfrom but the focus stays in the first record. If it is happy telling me the contents of ctlCurrentRecord, why does it not tell me the content of LineRef.
I suspected the References so looked at it using A2007 and it is using the later (12) libraries. My machine uses the older libraries so I have tried to install MSACC9.OLD and MSOUTL9.OLB but running regsvr32 "C:\Program Files\Microsoft Office\Office\ MSACC9.OLB" gives a message that the entry point was not found and this does not appear to be a .dll file so I am stumped there.
On the A2007 machines I have set up Trusted Locations for the back end data and the front end but that didn't help.
Also, the Access2007 machine "lost" the data from a selection of fields. Disaster, panic, embarrassment. Then I just happened to have cause to install a fresh .mde and it all appeared again. This is weird stuff and I don't know where to start.
Last edited:
