Search results

Hello All, I need help dividing data from 1 field in a table to several fields. The field contains several access codes that are only separated by an MS Access line break - chr(10). The data can consist of numbers and letters and is not any set length. Example: T10810 ST123008001 ST05900103...

I have a VBA code that will send an email to managers and CC "students" email, but when the Student's email is null there is an error. This is the code for the CC line. .CC = Me.Student_Email How can I write the VBA code where if there is a Student_Email it will insert it, otherwise it won't...

Hi All, I haven't had an opportunity to work in Access for a few years and am rusty beyond belief. :banghead: I am trying to insert a date from a unbound textbox in a form to a table. Both the textbox and the table field are set to shortdate format. I've confirmed that everything else works if...