aCCESS 2007 cONVERSION qUESTION

[Nigel]

I can convert a database converted in Access 2000 into Access 2007 no problem
and I can run it without an issues,

I can take that converted database and convert it to an ACCDE but when I go
to run it I get error messages telling me that it cannot evaluate a function
for whatever reason.

Surely if I can run it converted and it compiles into an ACCDE without any
issues it should run as an ACCDE

Are their any references I need to add to make it work correctly as an ACCDE

[Allen Browne]

No additional references are needed.

Which libraries do you have referenced?
The most common ones for each version of Access are listed here:
http://allenbrowne.com/ser-38.html

What is the function name? Any chance it could clash with the name of one of
the built-in libraries? The Object Browser (F2 in the code window) should
show that.

What security choices have you made? Is the ACCDE in a trusted location? Is
it digitally signed? Was it signed in A2000 before you converted it? (There
were apparently some problems with that.)

--
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.

"Nigel" <nige...@belmontpines.com> wrote in message
news:BF5D9937-B94C-412F...@microsoft.com...

[Nigel]

The error I am getting (when I open the login form) is Object or Class does
not support the set of events,

THe references appear to be valid just doesnt want to play

[Nigel]

this is what I have on the on open property of the form

SS_OnOpen Me
bcg_SetColors Me, DLookup("txtcolor1", "txtcolor"), DLookup("txtcolor2",
"txtcolor")
If DLookup("dualuser", "zzsortorder", "id=1") = True Then
Me!office.Visible = True
bp_ButtonVisible Forms!login!office, True
Me!Remote.Visible = True
bp_ButtonVisible Forms!login!Remote, True
Me!dualtext.Visible = True
If DLookup("officeuser", "zzsortorder", "id=1") = True Then
Me!officemode.Visible = True
End If
If DLookup("remoteuser", "zzsortorder", "id=1") = True Then
Me!remotemode.Visible = True
End If
End If
Dim intX As Integer
xg_GetScreenResolution
If Me!Width = "640x480" Or Me!Width = "800x600" Then
Me!minimum.Caption = "Minimum Resolution should be 1025x768."
Me!min2.Visible = True
Me!minimum.ForeColor = 255
'DoCmd.SetWarnings False
'DoCmd.OpenQuery "aaaResolutionPOOR"
Else
Me!minimum.Caption = "Screen Resolution is Acceptable."
Me!minimum.ForeColor = 0
'DoCmd.OpenQuery "aaaResolutionOK"
End If

Me!Userid.SetFocus
' Sub SetStartupProperties()
intX = AddAppProperty("AppTitle", dbText, "SMS Plus Version 2007 A")
Application.RefreshTitleBar
' Check links to the Northwind database; returns True if links are OK.

Dim dbs As Database, rst As Recordset

Set dbs = CurrentDb
DoCmd.ShowToolbar "Customer", acToolbarNo
' Open linked table to see if connection information is correct.
On Error Resume Next
Set rst = dbs.OpenRecordset("employees")

' If there's no error, return True.
If err = 0 Then
'CheckLinks = True

Else
'CheckLinks = False
DoCmd.OpenForm "attachsms"

DoCmd.Close acForm, "login"

End If
exit_sub:
Exit Sub

err_msg:
MsgBox err.Description
Resume exit_sub

[Allen Browne]

Nigel, let me be clearer about trusted locations.
Click the Office button (top left.)
Access Options
Trust Center
Trust Center Options
Trusted Locations
Add New Location
Specify the folder where your ACCDE resides as a trusted location.
Does that solve it?

Let me be clearer about references.
Press Ctrl+G to open the Immediate Window.
Choose References on the Tools menu.
What references are checked?
Are they actually needed?

Further question: What version of Windows are you using?
I have seen this message in Vista, linked to UAC issues:
http://allenbrowne.com/bug-17.html

--
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.

"Nigel" <nige...@belmontpines.com> wrote in message

news:A0ABF10E-2A1F-40A4...@microsoft.com...

> The error I am getting (when I open the login form) is Object or Class
> does
> not support the set of events,
>
> THe references appear to be valid just doesnt want to play
>
> "Allen Browne" wrote:
>
>> No additional references are needed.
>>
>> Which libraries do you have referenced?
>> The most common ones for each version of Access are listed here:
>> http://allenbrowne.com/ser-38.html
>>
>> What is the function name? Any chance it could clash with the name of one
>> of
>> the built-in libraries? The Object Browser (F2 in the code window) should
>> show that.
>>
>> What security choices have you made? Is the ACCDE in a trusted location?
>> Is
>> it digitally signed? Was it signed in A2000 before you converted it?
>> (There
>> were apparently some problems with that.)
>>

[Nigel]

No sorry it didn't solve the problem, I have only the references I need, It
compiles fine it will even create the ACCDE just won't run it, if I run it as
a regular database it works fine which is OK I will Have to live with that