Search results

It works to mask the social security number on the form but it also does it to to the corresponding social security numbers on the table. I hope there is a way to show it on the table. Thank you in advance for all your help

I have a form based on a table where social security numbers are entered. I would like to enter a social security number on the form and once it's entered the first 5 digits are masked. When I go to the table I would like to see the complete social security number displayed. Is this possible...

Random Generator I am using only three fields...locker number, name, and date(to keep track of query run date) on my table, query, and form. Should I place this code in the General Declaration of the form and do I need a requer command button to run on instance from the form?

Thanks. To edit my last question. I have 100 persons who have lockers. I want to randomly pick five men and five women for locker inspections. Would the Rnd() function apply these sets of data? Can I randomly select five non-repeating men or women?

I would like to create a simple access program to assign locker numbers between 1 and 750 to employees. Whenever I want to give an employee a new locker number, I would like to click a button to assign them a new number and then enter the date of the assignment. Is this possible and...

=HoursAndMinutes([TimeOut]-[TimeIn]) I have the above function that calculates difference between the start and end times for an employees shift. I have employees that work from 11PM one night to 10AM the next morning. When evaluate time like this the function returns negative values...