Recent content by james_halliwell

Many thanks, I think I miss understood the MSN website Appreciate you taking the time to help

Hi All, Trolled the internet but didn't find anything that would help, I would like to count the characters before the "-" for example 12345678-1 (this would be a count of 8 as its 8 characters long taking off the -1 9876541-1 (this would be a count of 7 characters long taking off the...

managed to sort it, for anyone looking throught the threads i managed it by KeyDown If KeyCode = vbKeyDown Then KeyCode = 0 KeyCode = vbKeyTab Many thanks arnelgp!!!!! just slightly changed it and it worked

just tested and the focus still moves down instead of across :-(

HI, Please can someone advise on how i can canel the a carriage return and replace with a tab or stop it moving down my subform and make it move the the next field instad of going to a new line im using the Keydown but dont know how to cancel it, it just bring an message but it stops it moving...

Hi all, We have a spreadsheet that i upload onto a table, i use on of the fields to build a file path but if there is a special character it causes problems, i need to replace the below with spaces if they are in my field called path • < (less than) • > (greater than) • : (colon) • "...

figured it :cool: Function tryslash(rec As String) As String Dim x() As String x() = Split(rec, "/") tryslash = x(2) End Function love the function will definatly use this again

Great help guys many thanks learned split today :p!!!!!! worked like a charm :D @jdarw if i wanted to get the second occurrence after / to put out below x1 = "REP/1349/999/426066/XX/9 " x2 = "REP/UDKBS01N/1/448174/XX/" x1 = 999 x2 = 1 how could i amend x() = Split(rec, "/") to look after...

Hi all, first thanks for taking the time to read my post and help me out with my query :) i have a need to strip of letters from a string but i needs to look for / as the lebght would change, below is an example of the data im working with record 1 example ) REP/1349/999/426066/XX/9 record...

Mate thats great many thanks, i can use this, using " instead of ' the run a replace " with ' to get me desirded format, greatly apperciate your hand helpfull links :):):):)

Hi All, After some help, i have a text box that i get a user to fill in some criteria for the sql to run Private Sub Text192_AfterUpdate() Dim LResponse As Integer LResponse = MsgBox("WARNING: this will affect the Import, do you want to change it ? ", vbYesNo, "Continue") If LResponse =...

Hi, after extensive googling im still struggling an hoping someone can help me out :-) I have a query that has a pivot chart, i need to be able to svae this as an image so i can insert it into a html email but i cannot find anything, im using access 2010 Please can someone help me out...

Hi all, i would like to copy a database from my desktop to to a sharepoint document libairy, i tried the below but it fails bad file name, im a novice at vba so could someone point me in the right direction please Dim fs As Object Dim oldPath As String, newPath As String oldPath =...

First thanks for taking the time to help me out, do you have an example format of HTML so I can start to play around Many thanks

Hi, need some help, i have created some code to get the records of a query and it puts them in the body of the emaiil but it doesnt format it well for examlpe the email looks like James | halliwell | 31 Leanne | smith |27 Alexis | smith |8 i would like it to be in a table is this possible...