Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mwheads

    Copy / Re-Create Outlook PST with folder / subfolder structure only

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

    Copy / Re-Create Outlook PST folder structure only

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

    Copy / Re-Create Outlook PST with folder / subfolder structure only

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

    Copy / Re-Create Outlook PST folder structure only

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

    Change excel sheet name programmatically

    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")...
  6. mwheads

    Exporting an ntext field to excel

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

    Activate all items in Outbox in "send mode"

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

    Mass emailing of snapshot reports

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

    For Each...Next query

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

    No Text Qualifier for Delimited Export

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

    No Text Qualifier for Delimited Export

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

    No Text Qualifier for Delimited Export

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

    Modulus 10 question (sum strings, don't carry 10)

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

    Count instances of a character in a string

    Thanks, that works great.
  15. mwheads

    Count instances of a character in a string

    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])
  16. mwheads

    Count instances of a character in a string

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

    Isolate text within a string

    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]
  18. mwheads

    Isolate text within a string

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

    Isolate text within a string

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

    delete query (delete months that are &gt;=25 months old)

    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

Part and Inventory Search

Back
Top