Recent content by CGill

Yes on both counts

Below shows how the data is held at present..... Field1 c blakeman blake2c 12/01/05 4556 see e mail recvd see e mail recvd see e mail recvd John.Heffer Email see e mail recvd see e mail recvd see e mail recvd The data needs to be 11 Fields accross and 1 record down Field1 | Field2 |...

I basically have 3000 emails which contain text I need to import in to access and store in fields, I have done the intial part of this by converting them into text fields and importing them into one large table.....the problem is I have one field with about 45000 records which I need to convert...

MS Access I would guess it would need to be a select rst! type query in VBA or somthing ??

Can you explain how I do this please

This is a one off so the fact it pulls the table apart is not a problem I do need to create a new table with the re formated data.

I have a table with one field containing 11 records. I need to seperate these records out into fields therefore ending up with a table containing 11 fields and one record. I sumise I need to step through each record and assign the value to a field but I lack the knowledge to do this. Any help...

Thanks for the reply I hadn't notice the division method have changed that now, the reason for declaring Calc as integer is that it is a variable number from 16 - 37. How should I declare the value ?

Using the below piece of code I need to return an answer of 31.45 which is the literal translation of my calculation. Due to MS Access rounding this answer is intepreted as 32. Me.Hours_Week = 37 Me.TotalTaken2 = 39 -------------------------------------------------------- Const Year As...

The above will also step through but does not allow for a second,third click etc....it would parse the same date [original one] to every field.

Thanks for reply however me("fieldname" & knt) does not CONCATENATE correctly. I understand the principle behind your code but the method of pulling the field name and knt together will not work....any ideas ?

I would like to utilise a calender to insert dates in to a range of fields 6 in total. I need the calender to work in such a way that on the 1st click it completes field 1, second click field 2 and so on.... I've got an idea of how to do it but not the coding skills to put this down. A finger...

Saanich Code looks like it will do the job but having set the reference I am still recieving a compile error relating to the use of 'replace' as per below varGetString = Replace(varGetString, ",0,", ", False ,") varGetString = Replace(varGetString, ",-1,", ", True ,") varGetString =...

I have written a piece of code which allows the user to import Outlook form designed mails from inbox and insert the data in the fields of the mail into a table within Access.....Using the onboard readme's I was able to determine how to grab the inbox as your source but does anyone have any...

I've looked at the code on these pages but with no luck you may notice that they are designed primarly for gathering contacts. What I need to do is go into an email which has been created in design view (they look identical to a Access form, with individual fields etc) I need to extract the...