Recent content by shannonsims

That took care of it. Thanks a million Bilbo.

Yes. I'm restricting the file attachments to PDF only.

Bilbo, Below is the completed code. On your advice, I added the Dim DateString code and defined the variable (which worked flawlessly) to name the newly saved file "YYYY_MM_DD_Employee_AdminDocDescription" as pulled from the unput on the entry form. The only issue I'm having now is that...

And again you've pointed me to the obvious mistake. I had the Name and Control Source mixed up in properties.It did have an error about not being able to find the strDestination, but (as you pointed out earlier) it was caused by date format issues (ie. 4/9/2012). Breaking it out by Year, Month...

I stand corrected Bilbo. It will move through the Me.Employee.Value but hangs up on the Me.AdminDocDate.Value and Me.AdminDocDescription.Value. Unsure what could be causing it.

I tried the second option in the below coding and got the following error message "Method or Data Member not found" for: strFilename = Me.AdminDocDate.Value & Me.Employee.Value & Me.AdminDocDescription.Value I also tried pulling the AdminDocDate out since you said the formatting might cause...

Bilbo, It may be that simple....Noobie here trying to learn the language. I figured it had to be something fairly simple but didn't know how to format the code to pull it from the fields and and define the strFilename. Where would that fit into the above coding? Appreciate the help.

I recently drafted the below code that allows me to track administrative documents for personnel in Access 2010 and save a PDF of the document on a shared drive in order to keep the database from bloating beyond the 2GB limit. I'm now trying to save the attachment with a name that is based on...