Recent content by jwbrooks99

Forgot to mention that I run office 2010 32bit and only access 2003

Hi There. I have a Access 2003 adp compiled on a 64bit windows 7 SP1 machine that gives #name? in all fields that uses functions like trim(), date(), format() when deployed on runtimes running on 32bit windows. It works fine on the developer machine (64bit). I recently added the ADO workaround...

VBA newby..... I am busy coding a document management system. I store the path of the document in a table. I managed to get the application to upload office files to a target directory and view them. I currently open the files using it's default application e.g .doc in MS Word etc. I would like...

Thank you Leigh. As mentioned still new at this and the topic is a bit over my head. Will never the less take a crack at it

I am using ADP

Thank you for the example. I have imported the modules and tried it. I get an error with the function GetAppDir(), strDB = CurrentDB.name. The error reads Run time error '91', Object variable or With block variable not set. Any ideas how to rectify? The process is great and I would really...

I have been battling to automate a word mailmerge using SQLExpress. I cannot figure out what the path should be to the mailmerge datasource. I am completely new to VBA. I come from a legacy procedural environment and will really appreciate a detailed explanation on the topic. I managed to come...