Recent content by vandel212

thank you all very much I got the results that I wanted. I appreciate your help very much. Once Mike375 showed me his mdb and I got to see what I was doing, everything fell into place. So here is how I did it: DIMENSION|X1: InStr([Dimension],"x")|X2: InStr([X1]+1,[Dimension],"x")|Length...

So am I doing all this coding in the query window or am I doing this in the module window? becaue I don't really know how to make a query the way you discribed. thank you and sorry for my ingnorance.

So how do I get the numbers from the dimensions column to the height width and depth column. I guess I'm asking how do I "paste" them (I know I'm not pasting anything)? ADDITION: I'm getting this error ([Dimension] is highlighted): ----------------------------------------- compile error...

Well, what I need to do is take a set of demsions (ex 21 x 5 x 40 [Width x Depth x Height) and put them into three seperate columns of Width, Depth, and Height. I have almost 200 rows of these so it would take a very long time to do it manually. Probably about as long as it would take me to...

Hi, I'm kind of new to VBA but I do have some programming experience. I'm not sure if it matters but I'm using Access 2007. What I am trying to do is to copy 4 characters of a cell and paste them into a different cell. I will need to do this 3 times for each cell and copy different sections of...