Recent content by mukund9876

relationships disappear Hi - Once again , thanks for your post. I checked the location: Its L:\Access databases\TIP-Database\TIP_be.mdb and the error message states exactly the same path and that its not able to find it. I also check the letter of the mapped drive on the user PC and its L-...

relationships disappear!! Hi - Thanks for you post. I see that the Linked Tables are there and have all data in them. Access gives me a message that speicfies that the user may not have permissions to access the server drive but I know that the user indeed does have permission to access the...

Hi all I am trying to give a new user access to the front end of a DB. When I copy the FE from the server to the local C drive ( Windows XP) the FE loses all its relationships and the user is not able to query anything. I go back to the server and find that the FE is just fine on the file...

dynamic query Hi, Thanks for your response workmad. I thought ur suggestion fixed it but the user just reported another problem. The funding classifications in my DB are as under: STP CMAQ E-STP S-STP Some projects have a combination of funding from STP and CMAQ, hence I suppose the...

dynamic query value passing I can remove the wildcards manually, but the query gets the value from the form when the user chooses STP from the drop down list...This value STP is passed from the form to the query and for some reason the value is passed as *STP* How do I tell accesss to get rid...

Hi, I have the following query: SELECT * FROM qryForCreateReportSold WHERE (((qryForCreateReportSold.Fund) Like '*STP*') AND ((qryForCreateReportSold.[Sale Date])>=#7/1/2005# And (qryForCreateReportSold.[Sale Date])<=#6/14/2006#)); The user fills out a form and hits run query and the...