I have read alot of messages saying they could not open a form using criteria.
I am simply trying to open a form (no criteria).
This system has been fine for years but due to us having to upgrade to 2010 from 2003, I had to rewrite the login/security forms to do away with the workgroup files.
my code is
The only oddities are:
1. some people are on 2003 and some 2007.
2. Some people have full rights and some have read only rights
When I tried to test the read only rights all of the sudden it started to give the readonly user and myself (full rights) the 2501 error.
I have checked for missing references and registered comctl32.ocx but still get this error.
Any ideas what I need to check or do next?
Thanks
lhuffst
I am simply trying to open a form (no criteria).
This system has been fine for years but due to us having to upgrade to 2010 from 2003, I had to rewrite the login/security forms to do away with the workgroup files.
my code is
Code:
System generated version
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Main Menu"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Changed to this when that didn't work
DoCmd.OpenForm "Main Menu", acNormal
DoCmd.Close acForm, "MainScreen"
The only oddities are:
1. some people are on 2003 and some 2007.
2. Some people have full rights and some have read only rights
When I tried to test the read only rights all of the sudden it started to give the readonly user and myself (full rights) the 2501 error.
I have checked for missing references and registered comctl32.ocx but still get this error.
Any ideas what I need to check or do next?
Thanks
lhuffst