Recent content by Macjnr

Thanks Nam No it is not always A#. I put that for simplicity when asking for help. The actual codes are as shown below

Hi, I have MS Access tool used for mail merge. Mail Merge is done using different letter templates e.g all records in the DB with Code A1 go to a letter template A1, Code A2 records are mail merged to template A2 etc. To perform the mail merge I have created as many queries in Access as there...

OK. done that. What can I do if I do not want the user to input the code. The letter codes are predefined and all the use is required to do is click on a button and the code executes a number of other instructions. Plus the letter codes are not easy to remember

OK. done that. What can I do if I do not want the user to input the code. The letters codes are predefined and all the use is required to do is click on a button and the code executes a number of other instructions. Plus the letter codes are not easy to remember

OK. See what I have come up with but does not work either Before SQLStatement:="SELECT * FROM `" & fCriteria & "`", SQLStatement1:="", _ After SQLStatement:="SELECT * FROM Letters WHERE (((Letter_Code)="LTRPLA")), _

boblarson, the sql statement SQLStatement:="SELECT * FROM `" & fCriteria & "`", SQLStatement1:="", _ is in vba. The code posted above does not work

See the SQL view of LTRPLA query. There are 10+ queries similar to this one with the differing in the WHERE clause. Other codes are LTRSDS, LTRFDS etc SELECT Letters.Letter_Code, Letters.Date, Letters.Router_Account_Number, Letters.Account_Number, Letters.Credit_Card_Number, Letters.Title...

That is exactly my problem. Can you do me a sample query that would achieve that ? I have tried but in vain Will greatly appreciate.

OK. I have a table letters and has over 10,000 records. I have also created 10+ queries who's names go into the fCriteria variable hence the reason it works fine when a Select * from fCriteria query as is now is used. Is there a way I can use one query where I pass the letter_code and the...

Hi boblarson, No I am not. The table is within the same database. All I want to do is introduce the where clause and I am not doing well on that front. the challenge is on SQLStatement:="SELECT * FROM `" & fCriteria & "`", SQLStatement1:="", _

Hi good people, I have records a fCriteria table that I am connecting to using the code below. How can I filter records in the table using based on Letter_Code field ? E.g Filter all records where the code is LTRPLA found in Letter_Code field. Regards, almacjnr

Teh code below is used for doing a mail merge. It works well the 1st time but spits out an error that the database cannot be found when invoked the 2nd time. Why would this be happening ? Thank you in advance for the help.

Hi, The code attached is used for performing a mail merge (which it does) by creating a document and closes the source/template document. What code can I add to close and save the merged document in read only in word or even better in pdf ? Will greatly appreciate your help. Thank you

Hi, Can any one help enhance the code below to 1. send the result of the mailmerge to pdf 2. Save the results to a specific location Regards, Chris

Hi, Thank you. The code worked perfectly. Thank you so much Yes you are right I havent dealt with the data types which I now want to work on. Any ideas on how I can 1. handle line one by saving it in a different table ? 2. Handle the data types ? Regards, Chris