Search results

Hello All, I'm Trying to move PDF Files associated with a customer to there specific folder The query gathers the data, Gives me a list of files by account number Now I want to use the results of the query to move those files I have tried to modify code I found on here but I'm not very good...

Hello All, I want to move documents associated with one customer from my main document folder to another. I've looked at some sample code but nothing seems to work I want to run a query to get the document list Run the code to move these files ( PDF Files )To a new folder. and It's done...

Hey There! I am trying to produce a list of e mail addresses from a query. I do not want any blank fields to show up. So I put "Is Not Null" (without the quotes) in the critera section of my query. I still get null values. Any Suggestions? Thanks Rich1968

We are currently running a split access 2003 database. 4 users and it's slow. I am trying to come up with a solution. A friend suggested SQL. My question is there any easy way to this conversion. Will sql increase my speed I know nothing about sql, is it easy to learn? Thanks Rich1968

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...

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...

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

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...

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...

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...

Hello All, I have a call center and Im trying to work out a call que. I have 8 operators. 10000 records that need to be called. I'm trying to create a query that will select the first record avilable from my table. when the next operator has completed his call do the same thing and so on...

Hello All! I am trying to to create entries into a table called tblinvoice for auto loans. If I have a 12 month loan then the re will be 12 entries with the due date and payment amount due. etc. I am using code I got here and I have part of it to work however ther are always problems. My brain...

I just upgraded my operating system to XP from 2000. Lot's of problems with my access 2000 database. Any help would be appreciated. All my controls are not working and functions are hit or miss, Date() function not working at all....................HELP! Rich :confused:

I accept Credit Cards Over the Phone. I send a receipt to the Customer with the entire CC Number xxx Out. I want to set up an Input mask in my receipt report that will only x out the first 12 numbers. Like this: XXXX-XXXX-XXXX-9999 I have try several times to accomplish this. Any help would...

On my Main form I have a drop down box with catagory's that can change for the current record. I want to be able to use this to update the catagory in the Sub form records. There may be 1 to 6 subform records that relate to the main form. Any suggestions? Rich De Gray

I want to be able to drildown thru my data say in a report that totals sales figures for the month to the basic data behind the totals in a report or form. As suggestions? Rich1968

I run A collection Agency. I know i know but someone has to do it! My fee is 40% Example 1000 Owed 400 Fee 1400 Balance Due Thats the easy part! When a payment is made how do I calulate the fee? 1400 Payment *40% Fee Percentage 560 Fee Earned This should be 400 It gets worse when...

I have a data entry form. On this form are a number of fields I would like to populate with information based on the Account type of the Customer. ie. nsf checks, apartment leases, legal claims etc. When I enter the Customer Id I use a combo box to pull down a list and choose the correct...