Search results

Hi, I have one main form M1 with 2 subform S1 & S2. M1 is parent of S1 and S1 & S2 are linked via the filter property. However, if no record are available in S1, S2 is still queried with all records. How can i disable fetching all records on load and query only if S1.controlname is not...

Great Function. Thank You Very Much. HiTechCoach. any idea how i can implement password complexity, i.e a mix of alphanumeric characters during validate? Thanks Jean-Marc

I am looking for a code snippet to be used in MS Access that can enable to hash password supplied at login and store the hash password in the backend database. Grateful if someone could provide some helping hands. Thanks Jean-Marc

Thank DCrake. Implemented your solution. it works. :)

Hi DCrake, Thanks for your response. I've specified the date as long date format. Unfortunately, i can't specify the exact date since i need the statistics for 1 month. Any workaround? THanks JM

Hi, I need to query a table to obtain a count on the number of records created and/or modified after a certain time e.g. 18:00:00 PM. Select COUNT(X) from my_Table where created_date < a_specifc_time or modified_date < a_specific_time I'm used to Oracle and a newbie on Accesss. Thanks...