C
Charles Anh
I created query to call user rights and the ability to
update certain project based on their rights. Some of
the XP machine in the lab I am getting "enter parameter
value" errors when I click on the Close button i created
in the form. Why am i getting this error message on some
XP machine and not on all. I know my query/form is good
because it is working on some XP machine. Please Help.
Here is my query.
SELECT tblProjects.ProjectID, tblProjects.ProjectNumber,
tblProjects.ProjectName, [forms]![frmprojectionbyPerson]!
[txtUserRights] AS Expr1
FROM tblProjects
WHERE (((tblProjects.ProjectDirectorID)=[forms]!
[frmprojectionbyPerson]![txtuserID]) AND
((tblProjects.flgClose)<>-1)) OR ((([forms]!
[frmprojectionbyPerson]![txtUserRights])="All") AND
((tblProjects.flgClose)<>-1))
ORDER BY tblProjects.ProjectNumber;
Charles
update certain project based on their rights. Some of
the XP machine in the lab I am getting "enter parameter
value" errors when I click on the Close button i created
in the form. Why am i getting this error message on some
XP machine and not on all. I know my query/form is good
because it is working on some XP machine. Please Help.
Here is my query.
SELECT tblProjects.ProjectID, tblProjects.ProjectNumber,
tblProjects.ProjectName, [forms]![frmprojectionbyPerson]!
[txtUserRights] AS Expr1
FROM tblProjects
WHERE (((tblProjects.ProjectDirectorID)=[forms]!
[frmprojectionbyPerson]![txtuserID]) AND
((tblProjects.flgClose)<>-1)) OR ((([forms]!
[frmprojectionbyPerson]![txtUserRights])="All") AND
((tblProjects.flgClose)<>-1))
ORDER BY tblProjects.ProjectNumber;
Charles