Recent content by iheartvba

Hi, I don't know the best process to do this, Could be something like; 1. create a variable in vba which stands for a file object and say that variable is to be defined on click of cmdDefineFile, then say you highlight the file "CreditCardReport.pdf" which is located on your C:\ then click...

I don't know how to acheive this so I will list my objective first: My objective is to Create A record in access for a file (lets say that file is located on C:\)as well as e-mails (ideally directly from outlook) without having to drag and drop that file Into access (Maybe I could highlight the...

Hi I am getting the following error when i click cmdFFR (See note1): Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE'. I can't figure out why this is. Spelling all seems to be correct. Public Dimensions are as follow: Option Compare Database Option...