Recent content by vman

Perfect! Thanks for the quick reply spikepl. That really was the problem.

Hi, I am writing a SELECT DISTINCT query to find unique values in one of the columns in my database. However, the query seems to be returning the lowest value twice. Can anybody point out what am I missing? My data is : WeekEndingDate 17-Aug-12 17-Aug-12 24-Aug-12 10-Aug-12 10-Aug-12...

For anyone who might face the same problem - the issue was resolved by changing the "Record Locks" property for the form "frmEmployeeDetails". Good Luck!

Thanks for trying :) Tyler, and for the idea for using a "close" before Opening. I am new to access and macros/VBA so I wasn't aware that a "close" clause exists. However, Unfortunately that did not work either :( I tried a close both before and after the openform clause, but to no avail. To...

Thanks, Tyler. Sorry, if I did not make my question clear. I am able to code the macro and open up the form. My problem is that it works only once. For example, if I generate the report which has 5 employees in it, and I click on any one of them - it would open up the frmEmployeeDetails, as I...

Hi, I am fairly new to MS Access and don't have much understanding on VBA code as well. However, for the sake of learning and to replace and old excel based solution used to capture details of various team members in our team - I am trying to create a database in MS Access. So far, I have...