Recent content by luvsmel

Thank you so much arnelgp, I was able to get this to work in one query :)

I have tried many different combinations of the split functions. Since I haven't use this in a long time, I'm not able to understand the difference between the functions. I came up with a few solutions but the require almost 20 queries. I have changed from line breaks to commas delimiting the...

Hi arnelgp, This almost worked but it doesn't completely send the right data. So the field can have anywhere from 0-9 Access codes in it. I have filtered out null fields in the query but with the current code it only transfers data if there is something after it. I need update/delete queries...

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...

Thank you SOOOO much. I changed the tables field name to ClassDate and it worked right away. :) Mel

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...