Search results for query: *

Hi and thanks to everyone for the help/code for sending emails/attachments/multiple emails via VB/Access. It works great. My Lotus Notes configuration runs in Internet mode, meaning it replicates in the background all of its databases including the Email/Sent/OutgoingMail folder. I have...

GKProgrammer, Thanks for the great post I reused it again (Had to dig to this poost to find it). I didn't give you a star last time so here goes! Thanks! Rob

HI, I have spent many hours in Tektips and other websites learnign about Regex. Thanks! I have basically 2 types of data that I want to parse out of an html (txt) file. string 1: <title>1965 Corvette for sale</title> String 2: <meta name="Keywords" content="Corvette, 1965, Cool Car">...

Hi All I managed to fix the problem! Thaks to everyones help! I made it a subroutine where I define public variables: (Makes it an all-purpose find and replace for txt files) PUBTxtInputFile = "C:\TempInput.txt" PUBTxtOutputFile = "C:\TempOutput.txt" PUBTxtFind = ", "...

Hi, I am using some code (below) to try to delete quotation marks in a file (txt). But i can't figure out how to delete the quotation mark (only one at a time - ") Does anyone know how to do this. Your help is much appreciated! Thanks! Rob Public Sub AASDBCleanTxtFile() Dim dbs As...

Bubbler, Can I se your code here. I want to do something similar and would be interste din your final product code. Thanks! RLB2

HI did anyone figure out a work around for this? I am outputting just above the aloted 16K records (Excel 95), but we are using excel 2000. How can I get my 17K records out? Thanks! Rob

Thanks! I'll check it out! Rob

Creosote65, Can you post your working code so I can see the before and after. A big help! Thanks! Rob

Poky, The Event is in the DATA section of the Properties for the Chart in the report. I hope that is what you are looking for? Rob

Darrylle, Thanks for your humor. I still have the problem and did look into my VBA/Access books for help. Nothing found yet. I checked the forum and there doen't appear to be any help (Although it solved many other probelms for me! THX!) Any help is much appreciated! Rob

Folks, I am also having the same problem.. Has anyone figured this out. I have checked all my VBA/Access books and can't seem to find an anser to it. Do I need to declare (Dim) anything before referencing the Report!ReportName!ChartName.RowSource = NewSQL String ??? Any help is much...

Hi! I am want to export the very useful .SNP file (Yes thats sarcasm) from Access to Powerpoint. I want each SNP file to be a page in the PPT file. I haven't looked into this yet, but would appreciate any feedback on how someone did it. Thanks! Rob

Thanks for the Open Filename routine. I tried it out on A2K and it works great! Do you have code for saving a file also? I would appreciate it! I just need to point to the save path, not actually saving a file. Thanks! Rob