PJ_KD
asked on
Need to pull last 4 digits from an entered field and store this info in the form and in the table
New employees are entered into our Access database through an Employee Form. The last 4-digits of their SSN is used as their Payroll number. I would like to have the 4 digits automatically stored in the Employee table and displayed on the Employee form to avoid an individual mis-keying this information.
I have limited Access knowledge so an easy to implement solution would be welcome.
A very quick response would be appreciated since we need this field for a Payroll conversion we are performing.
I have limited Access knowledge so an easy to implement solution would be welcome.
A very quick response would be appreciated since we need this field for a Payroll conversion we are performing.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Although the Right function should work, even after checking all of the references that could be checked, the Right function is not being recognized. This database is Access 97 and Right should work, but I can't find what else to check. I will keep looking.
Exit your DB. The go to START->Run - copy and paste:
regsvr32 C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
regsvr32 C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
You might also want to visit:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q194374&ID=KB;EN-US;q194374
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q194374&ID=KB;EN-US;q194374
ASKER
I have scanned the C: drive and the Office 97 installation disk and the VBE6.dll file is not present. I will look on Microsoft's web site and see if there is something that I can download. Thank you for your ongoing comments.
ASKER
I am looking at the link that you referenced and will see if that helps. I will be back in touch.
ASKER
Thanks for both of your assistance. It took me a while to figure out that I had some extra references that were preventing the "Right" function from working. After the References in the Module area were set correctly, your help resulted in the resolution of my issue.
Many thanks.
Many thanks.
Glad to help out.
ASKER
I also would like to store this 4 digit value in the Table so that I can export the table contents to an Excel spreadsheet that is then imported into our payroll system.