Search results

yeah - have I done this the "long way#" (Network)

Ah advise is always welcome - and I am not a programmer - more of know what can be done then go and hack the bits together to get it done .. so advise from "proper" folk is gratefully accepted This does seem like a frequent or certainly wanted function and I was surprise that their were no...

I will tinker .... IT doing something - but not what I expected...lol

not in the private Function should I need to ?

Hello the world - hope all is well (It has been some time since I have been on this forum) - Straight to it . I have "pinched/borrowed " some coding to open outlook and then file the sent email - however its being "awkward" and I am not seeing the issue...

thanks for feed back Outlook yes copy email from out sent/inbox that have been selected and insert into network folder (the logic behind this is that everyone can see the emails/trail per case -ie 12345 and all correspondance) I will look at the free utility and digest Cheers G

Left this one a little vague.. If I explain what I kinda want (which may be too much ).. I want to file emails in and sent - in a folder per records so record number 12345 will have a folder on the server "12345" is there a way of selecting the email and copying it from the inbox/sentbox...

This is what i use Private Sub ShowFolder_Click() Dim stFolder As String stFolder = "S:\xxxxx\xxxxxxxx\CLIENTS \" Shell "c:\windows\explorer.exe " & stFolder & Me.QuoteNo, vbNormalFocus End Sub not sure if that helps

Ah Freedom Writers another corker of a film - not everything after the 70's/80 is bad -

Blimey, Colin - you are missing some little gems of films - not Oscars - but there are some really good ones out there Good Will hunting is a good example, as is Finding Forester - solid story great performances and some unsung ones such as Mr Turner one to watch, and some of the more modern...

Thanks for everyone's input . once I have resolved this i will let people know -

Gakiss2 again another train of thought I had also considered and I am using some of this process one of the fields in the fields is earmark for this if A then add to table A and B ( dlookups to add the right fields to the right d/base tablefield names ) and some fields will need to be added...

I had this in the back of my mind - but was trying to stay away from this as if I don't get the data given to me in a usable method it would be a real dogs dinner to sort out - which I can see is how you had to resolve, I may have to take this approach but its a little messy 9 we still have to...

that's great however I am doing . add method to do what I need - as I need the first part of the import goes in one table , and other parts go into other tables (I have this bit all resolved -I tested it on part of the import data - but great ) the headings i am trying to standardise - as the...

That would be great - however, it's never that easy ... not only is it three versions it's in 4 different currencies and some of the data is different in each I have had a moan at them for this - as I should have been involved a little sooner to resolve the raw data files - but that's life ..

Great - you answered my badly phrased question and save me time doing trial and error Kind regards Gary

Yeap - got this bit all resolved with a few if statements If Apples then append to fruit table if Animals append/add to etc . its just the import table - and one of the posters has answered this - once i get this up and running ... I have just asked the data source to put an extra...

csv file one name address etc extra 20 or so fields - say Apples Pears Peaches etc Csv file type 2 name add etc no apples no pears no peaches but Kangeroo Wombat Polar Bear CSV file type 3 no apples/pears peaches might be Kangeroo Wombat Polar bear but also Football/Tennis...

Yes so a staging table and then I can "Dlookup and append/add into the right table - I can do this bit no problem

Hi everyone I have data coming in via a csv file - no problems - want to import into table - I can work this one out no problem - however the csv file will come in three different layouts column 1 name standard etc... version 1 will have x number of fields that are not in 2 or 3 and...