Recent content by jjcyeshua

I was able to find a way to make it happen.. I just used Space(#-len(lineresult)) Thank you so much:D

Im trying to export the data into a text file, but whenever i try to i can only get up to 255 characters exported, but i need the width (which is 750 characters). Also I dont plan to export the headers. Any idea? Thanks:)

:confused::confused::confused::confused::confused: Hi! All, I need help on something, Currently i am trying to transfer a data into a text file using transferTxt, but no success at all. The lenght on each data(row)has 750 characters. What would be that best approach to transfer the data into...

Hi folks, vba guru,masters,experts.... I need help.:confused: How can i automate or send report to a list of email from a query that i created. I was able to used SendObject macro but only for a specified email, now i need to make it dynamic. Any ideas, or anyone who could point me to the right...

that's a good one.. thanks

Yes!!!! Thank you.. worked perfectly.....

Hi gurus, I need help/ideas/suggestions. I'm trying to automate a process that copy data from excel to Access.. but not all data in excel, just specific cells. I currrently have a form that i would like this process to be added. i was able to connect to excel file using ADO, but cant lock to...

Hi guys I need some ideas/help on something I'm working on . here's the basic structure. I have a base table and Transaction Table.. Basically Transac Table is just a history table to keep track of alll the changes made in fileds in Base table. If I use my base table as datasource for the...