Search results for query: *

I did find a very simple solution yesterday and it works perfectly. (with no programming required) If you do an archive on the entire PST and set the "archive before" date to a date too far in the past to actually move any emails, then the PST is re-created with all the folders and subfolders...

Hi kjv1611 Thank you for the response. I did find a very simple solution yesterday and it works perfectly. (with no programming required) If you do an archive on the entire PST and set the "archive before" date to a date too far in the past to actually move any emails, then the PST is...

Hi All I am looking for some VBA code to copy all folders (no emails) to a new pst file. i.e. copy entire folder structure and subfolders to a new pst file with no data. I have a user with a very complex folder/subfolder structure in a 16GB PST. I want to start this user with exactly the same...

Hi All I am looking for some code to copy all folders (no emails) to a new pst file. i.e. copy entire folder structure and subfolders to a new pst file with no data. I have a user with a very complex folder/subfolder structure in a 16GB PST. I want to start this user with the same structure in...

Hi All Does anybody know the command to change the sheet name. I have a csv file which i convert to an excel file with the following code but I specifically require the sheet name to be "Sheet1" for sql import purposes Dim oEx oEx = CreateObject("Excel.Application")...

Hi All (this is a small excerpt of what i'm trying to do) rs = oData.OpenRecordset("select convert(nvarchar(4000),substring(FREE_TEXT,1,15000)) from tblTable") oExcel = CreateObject("Excel.Application") oBook = oExcel.Workbooks.Add oSheet = oBook.Worksheets(1)...

Hi All I have a bulk email process that Saves all of the messages to Drafts. I prefer it like that because I can spot check a few of the files before I send them. When the mail items are moved to Outbox, Send/Receive does not send the items because they are not marked in Italics and ready to...

Hi All Does anybody have any idea how to send each page of a report (as a snapshot attachment) to bulk email recipients. I have a report of 500+ pages (1 page per client), each with an individual report and specific email address, and I would like to send all in one routine. Is anybody...

Hi all I've been trying to execute a FOR...NEXT for a an AccRef field in the tblBuildingdetails table but it won't work. The min and max range of the AccRef is 0005 to 9999 but only about 300 of the AccRef's are in the table. I managed to export 9994 txt files when I only want the 300 that...

Thanks, you're forgiven for the 1st post The 2nd one however is just what I was looking for, cheers for that, All the best, Paul

Thanks, must be comma delim but Text Qualifier of none, i.e, This is the standard access format: "STATIONERY","OFFICE SUPPLIES","256376.23","SHIP" This is the way I need it for another import process: STATIONERY,OFFICE SUPPLIES,256376.23,SHIP Regards, Paul

Hi All I have been trying to code a Delimited Export of a query with TransferText but I specifically need that Export with a Text Qualifier of <none>. If I do a manual export, I can release the file as I need it but a macro or coded version defaults the Text Qualifier to "". My code currently...

Hi All We have to produce a Hash total at the end of a banking export that sums strings but not carry 10 on any digits. i.e. +444444 (A1) +190807 (A2) =534241 (Result A3) I need to create a VBA function that can run down the column, using a NEXT function. The strings are actually all 32...

Thanks, that works great.

Hi Roy-Vidar I am not sure what strString is referring to, do i need to Dim strstring? I am not doing something right as my result is always a #Name? on my controlsource on my form in [Text103], I have got =charcount([Text101])

Hi all I would like to know how to count instances of a character within a string. The character is always ">" The way i did it in excel that worked for me was: =LEN(A1)-LEN(SUBSTITUTE(A1,">","")) I need something similar (or better) for Access. thanks

thanks, Instr() has given me a few ideas, its all i've got at the moment. it will solve the problem in about 80% of the cases where a prior BA does not appear. P.S. Yes, its always, [BA][3 letters][3 or 4 numbers]

Hi Simon, No, there is no fixed structure, it is the download of the company bank statement and the field is very random depending on what clients have entered as references. Basically I need a way to isolate only the "BA" and the characters after that. This "new field" will be linked to our...

Hi All I would like to know how to isolate cetain text within a long string. e.g. If my full field is: "CHEQUE DEPOSIT J C BLOGGS BAWGE123" All I need to isolate in the query is the "BA" and the characters after that. All of our references start with a "BA" and the remaining is a definate...

Hi All What criteria do I use in a delete query if I want to keep a stock of 2 years and delete anything that is 25 Months+. Field name is Month I can get it right in days but not in months. Thanks