Recent content by Iamrickdeans

Thanks for your help I have managed to solve the problem but I am not near the source code now to post my coded solution. My process became, Take the original PDF Decompile into TIFF format so each page was an individual document Compile only the required images into a new singular TIFF file...

Hi Again To be honest I do not know if publisher is the right tool for the job I will try to illustrate further. I am doing a tax return for the IRS the file is a 1042s the file is a PDF of which only three parts of this file are required to be split out and then sent to our customers. I...

Hi Michael Thanks for looking at my post! I am still trying to work it out and just cannot get it! I have an access database located in L:\MailMerge\MailMerge.accdb Within that are Three tables; 2011, 2012, 2013 each of these tables are identical in setup and each contains a field...

:banghead:I thank you all in advance for any help you can provide me, I am looking to perform a mail merge from access to Publisher. I have linked everything together and got everything looking the way that I want it to look however... What I want to do is when I perform the mail merge I would...

That's cracked it, Again buddy your a star! Access is such a strange beast at times... :D

Oh apparently you cannot use the CDec directly within a query!?! I find this quite strange... Well that's me out of ideas.

Well the CCur has worked perfectly, the conversion to decimal not so... I have written this element as Select CDec(dbo_T5VaultsL2.VL2Beneficial) AS Beneficial however I receive the message Wrong number of arguments used with function in query expression 'CDec....' I tried changing the...

Thanks for the replies guys, I am going to start looking at your sugestions to clarify I am trying to convert the VL2BENEFICIAL into a decimal which can contain up to 20 decimal places and the PRCPRICE is to be converted into Currency so I will try the CCur function.

Apologies if this doesn't quite fit within the queries area exactly... I have created a link to a CRM system that we have, and am using access as an interface for a specific task with the data contained within this CRM. I have written a query that pulls to fields of data together but...

Converted code to VBA and the problem is resolved... The answer you gave was so very close to what I had been doing, I am just going to kick myself... On a serious note, the help you provide is incredible to me and loads of others. Until I am in a position to provide the same kind of help...

Having tried Output File: "L:\Operations Database\Projects\1042\Outputfile\" & Forms![Client]![RecipientsAccountNumber] & " - ClientPartA" I also tried Output File: "L:\Operations Database\Projects\1042\Outputfile\" & Forms![Client]![RecipientsAccountNumber] " & " - ClientPartA" No joy...

What is coming up is two pop up windows the one at the back reads Now outputting 'ClientPartB' to the file 'L:\Operations Database...\2011Outputfile\ & "Forms!xxxx[RecipientsAccountNumber]" The window on top then reads Microsoft Access Can't save the output data to the file you've...

Hi Paul You've helped me before buddy and it's really appreciated I had tried your code before and it still errors out on me... If I change the output file to a specific value for example L:\Operations Database\Projects\1042\2011Outputfile\300 it saves the value as 300.PDF However...

Hi Everyone, It's been a while since I posted but I have inevitably hit a brick wall with my re-learning of Access and I am stumped, perplexed, smacking my head off the wall trying to work out the solution (which I feel as soon as it's pointed out I am going to kick myself for) I am using...

Thanks so much Paul, I will investigate this and feed back on my success/failures. regards richard