Solved Access 2010 error when going from Windows XP to Windows 7

August 6, 2012 at 05:39:53
Specs: Windows XP
Access 2010 databases (those that retrieve Windows Login) are giving an error on those PCs that have been upgraded to Windows 7 from Windows XP. According to the error code and what I looked it up- it is an issue with Office 2010's calendar feature. We have been in office 2010 so that doesn't make since. Is there a different VBA code?

See More: Access 2010 error when going from Windows XP to Windows 7

Report •


#1
August 6, 2012 at 07:55:34
actually i had a similar issue with one of my databases due to a calendar issue. i cant exactly remeber what the fix was, but if you can provide the exact error, and maybe tell us when it occurs, ie when you press a button, or when you open the database, can you debug the error and paste the code? i think it could be related to the calender control, and instead of using the calendar you should use Date Picker.....

Report •

#2
August 6, 2012 at 08:44:09
I logged in under a different account so while the name changed, it is still me.

When the data bases are loading this is the message, "Your Microsoft Access database project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0. The error message comes again after 'enabling content'. As soon as you try to open a form other than the start up I end up in the VBA viewer for that form:
"Compile error: Can't find project or library"
the code is as follows:

Private Sub form_Load()
Dim userName As String
Dim dept As String
Dim role As String


userName = Environ("USERNAME")
If IsNull(DLookup("Department", "Employees", "User_Name='" & userName & "'")) = True Then
MsgBox "You are not authorized to acces this application. Contact Help Desk for authorization"
Application.Quit
Else
dept = DLookup("Department", "Employees", "User_Name='" & userName & "'")
role = DLookup("Role", "Employees", "User_Name='" & userName & "'")
Me.deptLbl.Caption = dept
Select Case dept

The same messages appear on all of our databases that pull in a user name/ windows id. These databases were built by interns from a local MBA program. I am not strong with VBA (yet) so please be patient.


Report •

#3
August 6, 2012 at 09:06:11
✔ Best Answer
Here you go, i was right, it is due to the calender control, what you will to do is replace your calender control and use date picker.

read this. Also do a google search for mscal.ocx access 2010. there are loads of site offering help, but the general solution is to not use the calender control.

http://superuser.com/questions/3441...


Report •

Related Solutions

#4
August 6, 2012 at 11:35:07
Thank you! Following the directions on the link you provided worked perfectly!

Report •

#5
August 6, 2012 at 11:45:21
You'r welcome can you please mark this a solved? Thamk

Report •

#6
August 15, 2012 at 09:05:58
I am really embarrased but I can't figure out how to mark this as complete and "Set as Best Answer."
:)

Report •

#7
August 16, 2012 at 00:44:52
I think the thread is set as solved automatically when you choose a best answer, you should be able to set a best answer by going to one of the replies and there should be a big black and white button that says "Set as Best Answer" :)

Report •

#8
December 11, 2012 at 09:11:01
In this case you may lost your access data, if it's right make use of http://www.repairaccess.accessrepairtoolbox.com

repair access database quickly fix database tables, links, queries and other objects, it is possible even in the most serious cases and without the modification of additional settings


Report •


Ask Question