Search results

I keep getting an error "Could not find object". Then it references the file CAPCMS08062012. which is the first file in the folder. I modified this code from an example I got on this "AWESOME" site. I really mean that! I have multiple files to import on a regular basis. This would save me a...

No, I have not been able to download any of the files. I'll try the cmd prompt. Thanks

Thanks for the reply, Never thought of using a batch file, However it solve a bunch of code issues. Thanks. I can't get the download batch to work correctly. Is ther any way I can run this and have it step thru the process? Like in VB? Thanks Rich Here's what I have so far @Echo Off REM --...

I have data coming from a secure ftp site. I have been doing this manually but it's getting old real quick. Im looking for ways to automate this. I want to be able to download multiple files into a single table in my database. Im looking for suggestions. I have been on the forum sites all day...

Hey Bob, I found this code on PlanetSourceCode.Com. It works GREAT! Thought I'd pass it on. Thanks for your help. Option Compare Database '************************************** ' Name: Merge Multiple PDF Files ' Description:Convert / Merge Multiple PDF documents into a single PDF Document '...

Thanks Bob, Wish this was easier. I'm not a pro at VBA. I know enough to be very dangerious. How would I set up an "Array" Humbled Rich1968

Hey Bob, Thanks for the code. I am trying to take 8 pdf files and combining them into one. I finally came back to your code after I relized the code I posted will only combine 2 pdf's not 8. I tried your code and got the following error "Type Mismatch". Here's the inputs. MergeThePDFs...

I have a piece of code that i'm trying to use to combine 8 "PDF" files. I run the code and it will not create the new file. I've been at this for 2 weeks and i'm close but no cigar.... HELP! Rich1968 Here's the code. I use access 2003 and Acrobat 6.0 Function MergePDF() 'Relies on the Adobe...

I'm trying to put together a code that will take 7 pdf files and combine them into to one. The files are in a single directory, and I can email all 7 as attachments, However it would be better to send in one file. Any help would be appreciated. Thanks Rich

Thanks PBaldy, Now I need to bone up on Variables and exporting. I tried to output in a macro to a file in rich text but all I get is junk Thanks for the help Rich

I have been trying to set up a routine that makes reports based on a form. I have a macro that ques the reports. This works great for printing, but not for emailing With the reports I want to email them to a customer. This works fine with one report but when I have more then one it only sends...

I use Access 2003. I have several reports that are printed with a Macro. The account data is provided from a query. This works fine for printing but now I want to save these reports to a directory and use them as attachments for an email. When I use output in the macro I get garbage. It should...

This is a DUH!!!!!!!!!! Moment....Attachment works....Many Thanks ;>

Yes It's a PDF File

Hey All, Trying to send an email with an attachment. I keep getting this error "Can't find this file. Make sure the path and file name are correct" They are correct I am using a code sample I found on the forum. I'm stumped. HELP Thanks Rich Here's the code. Option Compare Database Option...

You guys are GREAT! Thanks Rich1968

You guys are GREAT! Thanks Rich1968

Hey All! I have a form called messages. Staff take messages when im out and record them on the DB. What I would like to do is the following: Set the on timmer event to run a query called qryMessages every 5 min. If there are any messages the buttom for the form "Messages" on my switchbord...

Operators tools I finally figured this out. Using Pats suggestions. I could not get this to work with requery. So I set up the following. Create a Macro. Call it Next Record 1. Set warning to "NO" 2. Close form 3. Run query 4. Open form 5. Close query Create a button. Set to "Next...

I wonder why everyone in the world wants to come to this oppressive place? Makes you wonder..Hummmmmmmmmmmmmmmmmmmmmmmmmm