Problem with old Access file made with Access 2003

[prototype206]

Hello everyone I'm new to the forum and I excuse in advance if i shouldn't post here.

Little background info I'm a doctor not a programer and for our surgery scedual we use old access document made long time ago I believe with Access 2003.
Recently we bought new laptop and it can't open the access file properly neithter with Access 2003 and 2010.

1) The Calender doesn't show and I can't choose date for the operation.The error i recieve is this "runtime error 2683 there is no object in this control". From what i've learner so far the problem stems from the calender control.
2) There is a custom button for printing only the operation for the day which also doestn't work.

I will attach the file here so you can see for yourself.
Thank you in advanced.

 

[theDBguy]

Hi. Welcome to AWF!

More than likely, your db is probably using an old ActiveX calendar control, which has been discontinued in newer Access versions. I can't tell you why you can't open the same MDB using Access 2003 though. Are you saying the new laptop has Access 2003 installed on it?

 

[prototype206]

Yes i installed it myself on the laptop but it also doesn't work on my PC.

 

[theDBguy]

Yes i installed it myself on the laptop but it also doesn't work on my PC.

Again, I wouldn't know why you can use Access 2003 now; but if you want to use Access 2010 (or later), someone will have to update your database to remove the non-working ActiveX control and replace it with something else or just use the new built-in calendar control.

 

[prototype206]

Again, I wouldn't know why you can use Access 2003 now; but if you want to use Access 2010 (or later), someone will have to update your database to remove the non-working ActiveX control and replace it with something else or just use the new built-in calendar control.

Thank you for the advice.

 

[theDBguy]

Thank you for the advice.

Hi. I would love to help further; but when I tried to open your file, I couldn't understand the names of the buttons, etc. (I don't speak Russian?). Good luck!

 

[prototype206]

Hi. I would love to help further; but when I tried to open your file, I couldn't understand the names of the buttons, etc. (I don't speak Russian?). Good luck!

I will translate the button and upload again

 

[MajP]

As stated the issue is the old calendar control which no longer is supported. You need to delete the calendar control. If you have a date text box it now comes with an automatic pop up calendar when you enter the text box. Many people like to use a custom pop up calendar which are pretty easy to utilize. There are lots of examples here.

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

 

[theDBguy]

I will translate the button and upload again

If you want to, but the buttons would just be a start. You'll also need to translate the tables, queries, forms, and reports.

 

[prototype206]

If you want to, but the buttons would just be a start. You'll also need to translate the tables, queries, forms, and reports.

I know only how to open the table I don't know how to open the queries, forms, and reports.

 

[isladogs]

@DBGuy
The file the OP uploaded isn't visible to anyone who isn't a moderator

 

[prototype206]

@DBGuy
The file the OP uploaded isn't visible to anyone who isn't a moderator

Sorry i didnt upload properly. Now it should be ok.

 

[theDBguy]

@DBGuy
The file the OP uploaded isn't visible to anyone who isn't a moderator

Sorry i didnt upload properly. Now it should be ok.

Please confirm that the file is visible now. I haven't done anything yet to fix that (not even sure how yet either).

 

[isladogs]

Its visible now but I haven't looked at it yet and am about to sign off as its late here.
Hopefully the OP can fix the issue following MajP's explanation.
There should be no need to translate queries, forms and reports in order to manage the old calendar control

 

[theDBguy]

There should be no need to translate queries, forms and reports in order to manage the old calendar control

I only said that because the names are in Russian, just in case the code refers to any of them. For example,

DoCmd.OpenForm "RussianFormName"

I wanted to make sure I knew which form to check for problems.

Good night!

 

[Dick7Access]

Hi. Welcome to AWF!

More than likely, your db is probably using an old ActiveX calendar control, which has been discontinued in newer Access versions. I can't tell you why you can't open the same MDB using Access 2003 though. Are you saying the new laptop has Access 2003 installed on it?

Where have I heard that before

 

[gemma-the-husky]

I can't see that it has been mentioned, but your issue will be that A2003 is 32bit, and your current version is probably 64bit.

In "file", click "Account", then "About Access" and it will most likely say 64bit at the end of the header. So you would need to convert your A2003 database to 64bit. Alternatively, you could uninstall office and reinstall office as 32bit, but that depends whether you have the installation disks. That might be the easiest fix, though.

 

[shadow9449]

I downloaded the application and ran it in Access 2003. The problem that I encountered was that Calendar2 is on a subform, whereas the code that references it is on the main form. I moved the control from the subform to the main form and renamed it Calendar2 and it works. Try that and see if that helps.

As others have said, this isn't going to work on any version of Access past 2003 so either keep using Access 2003 or convert it to an updated version of Access and use a more recent calendar.

 

[arnelgp]

something similar?

 

[prototype206]

I downloaded the application and ran it in Access 2003. The problem that I encountered was that Calendar2 is on a subform, whereas the code that references it is on the main form. I moved the control from the subform to the main form and renamed it Calendar2 and it works. Try that and see if that helps.

As others have said, this isn't going to work on any version of Access past 2003 so either keep using Access 2003 or convert it to an updated version of Access and use a more recent calendar.

I think i put the calender in the subform but it wasn't originally there.