Search results

Thank you for replying so quickly. But I don't know how to configure the Mapi Client. Our "tech" did say that he tried re-installing this, but I solved a different problem on another occasion that he could'nt. I looked up the problem. How do you configure the Mapi Client? Judy

Hi; I supervise a small group of people at a college. I connect to their computers through their ip addresses to share databases and files. Four out of the six people in my group have Windows 2000 and I and one other person have Windows XP. Now this is the problem. I volunteered one of...

Open Explorer Window I don’t understand exactly what you mean. Did you mean you want to open a window where you can choose what file you want to import? This would mean you do not know the name of the file or the extension? I am sorry I haven’t figured out how to just open a window, but I...

Hi, again; I thought I did give you an option with Pat Hartman's answer. See below. ********************************************************** #7 01-19-2003, 07:55 PM Pat Hartman Registered User Join Date: Feb 2002 Location: Stratford,Ct USA Posts: 13,498 fasternu, an update...

renaming files I had the same problem a while back, and the answer is in this link. http://www.access-programmers.co.uk/forums/showthread.php?t=38797 I currently use filecopy to rename the files, this way i always have original, and for huge masses of files I had help in creating an array...

Hi: With the help of my son (who is a VB fanatic) I had been able to rename files, import them and copy the name of the file into the table with the file records, but I still needed the file creation date. He suggested I go to VBcode.com and do a search, well I found code that lets me choose...

Hi; I have a function that I created with a lot of help. It creates an array from files in a specified directory, dumps these filenames into an Access table, renames each file with the correct extension and then imports each file. After this I have some cleanup queries. The original goal of...

Thank You ghudson!! It worked perfectly. I almost had the statement, but my quoutation marks were off. Judy

Hi; I would like to be able to enter the name of a file I need renamed (through filecopy) in an Access form, so that the filename (E102E557B.REC) gets renamed to E102E557B.TXT. There are quite a few files and renaming through the copy command one by one would be tedious. Example: FILECOPY...

Did you open the properties box in the query for that particular field? You should choose currency again and make sure you pick 2 places for decimals. Sometimes when one field has more than one kind of data you might have to use the format function to designate currency. Example...

How did you get the running sum? I tested this with a report I needed a running sum in and added a line with an amount of -0- and it still calculated the right totals. The steps I followed were these; 1) Open the report in design view. 2) Add a text box control to the detail section of the...