Search results

Since the code works, all I really want to know (at this point) is how to: Close the word application (even after I close the db I can't manually delete the doc created) How to automaticly delete each form after the email is sent Can't figure out how to save to a specific folder, but they can...

Good morning & evening Ladies and Gents, I've been requested to build a access DB to manage a email process. Through various searches, articles I've created the below, I'm not by any means a Developer, just a basic access user that reads a lot and like to help out. I've tried mailmerge, but...

You Mate are D Man! Enjoy your weekend!

Hi labolt, The NewPackage Table currently has restricted fields as it's a linked table from a SharePoint site with a InfoPath smartform (Data from form ports to backend table). For me to manipulate (VBA) the merged data to single row entries on a serparate table, I have to port all...

Good afternoon all I have the below code: INSERT INTO [New Package Port] ( NWID, Title, Courier, [Inter Office], [No Lc], Reference, [Product Type], [Tracking Number], [LC 2], [LC 3], [LC 4], [LC 5], [LC 6], [LC 7], [LC 8], [LC 9], [LC 10], [LC 11], [LC 12], [LC 13], LCNum, LCRange, [LC 14]...

Good day all, Here is some background We have a Team that enters data through an Infopath form to Sharepoint. The Infopath has 13 LcNum fields with a tracking number acting as a primary field. If the user needs to exceed the 13 LcNum (LcNum1-LcNum13) fields in a repeating table can be used...

Thanks for the guidance Galaxiom, I was trying to see if I could create the validaiton rule within the table iteself as such will be linked to a Sharepoint Site that will have form built in InfoPath....unfortunetly there is never an easy way out and a second or third step is always needed...

Hello all, I'm currently building a simple incoming package tracker. My current issue is creating a "after update" validation rule off the Tracking number field that would determine the length needed based on the Courier choosen (Macro). I have a incoming_tbl with a Courier dropdown as...

Good day or evening to all! Just joined the Forum after years being in the shadows and would first like to thank this great community for the knowledge shared here! With that said.... I have a question....lol Basic/Intermediate MS Access knowledge, can build simple database but not to much...