I have two data bases with the same forms in each. In the second (New Version) form one populates correctly, the other two do not. In the original all populate correctly and the code is the same in each. The object is to list reports that begin with the respective "r", "F" or "x".
Can anyoone tell me why this is happening and how to fix it???
=================================================
This is the code for the one that populates correctly:SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="r"))
ORDER BY MSysObjects.Name DESC;
This the code for the second form that does not populate:SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="F"))
ORDER BY MSysObjects.Name DESC;
This the code for the third form that does not populate:SELECT
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="x"))
ORDER BY MSysObjects.Name DESC;
Can anyoone tell me why this is happening and how to fix it???
=================================================
This is the code for the one that populates correctly:SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="r"))
ORDER BY MSysObjects.Name DESC;
This the code for the second form that does not populate:SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="F"))
ORDER BY MSysObjects.Name DESC;
This the code for the third form that does not populate:SELECT
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764) AND ((Left([MSysObjects].[Name],1))="x"))
ORDER BY MSysObjects.Name DESC;
Last edited: