I expect /'s in Date are causing an issue. Consider:
rs!EmployeeID & "-" & Format(Date(), "yyyymmdd")
VIP
Windows 7 64bit 
Access 2010 32bit
I expect /'s in Date are causing an issue. Consider:
rs!EmployeeID & "-" & Format(Date(), "yyyymmdd")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 7 64bit Access 2010 32bit
I expect /'s in Date are causing an issue. Consider:
rs!EmployeeID & "_" & Format(Date(), "yyyymmdd")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
generating mailing label reports
Posting Permissions
Reply With Quote