Recent content by mike2000

Thanks for the reply, ill give it a go and let you know how i get on.

I found this great bit of code on here. It copies the 1st item (column) of a list box to another list box. The problem is i need it to copy more than one of the columns, about 4 or 5. I'm not VB literate, so i woundered if someone could help me out, if its possible to do it. Many Thanks in...

JCA, thanks very much. That's solved my problem.

Somebody kindly helped me with a DLookup Function, it works but sometimes a code (string) will get entered and a space will appear in it, which stops the DLookup from working. eg SL6K6 may get entered as SL 6K6. The code is scanned in so i can't uses a filter. Is there any way around this...

Milo thanks for that it works great, i had to remove the Not from IsNumeric as it was leaving me with only the text and i actually wanted to remove this and keep the numbers. Raskew thanks for your function havn't had time to play with it yet but ill try it out later. Thanks for your help...

help calling the function I'm having a bit of difficulty as im new to functions. How do i call it? I need to apply the function to the string on the Before update of a text box. Thanks for your patience.

Thanks for the reply, i'll try it out and let you know how i get on.

Could someone please help me put together some code to check a string for non integer characters, and delete them if present. Thanks

I'm copying the contents of the subform to another subform. This is happening, which is confusing why it comes back with an error.

Its the contents of the whole subform im copying, i thought that was the control?. The subform is based on a query, i tried that name , but i guess it was wrong as it also came up with the same error message. I'm a little confused as to what the control is if i'm copying the subform. :confused:

I wonder if someone could spare a minute to help me with my syntax error, i have tried all the variations i can think of, but i still get a 'runtime error 2465' access can't find the field 'forms' refered to in your expression. the code still copies the data over, so would it be ok to just...

Got it Thats worked, thanks very much.

still notworking Thanks for the reply, but its still coming up with the same error. Do i requery the subform name or the query it is based on?

I wonder if someone could spare me a moment to help me with a syntax ( i think) error. I have a text box on a subform, which it's after update event will requery a subform on the same form. The main form is called Orders the subform is called Order details. The data that has been entered in the...

how to select sub form items to be copied over I have a similar problem, however i need to be able to select various items from the sub form to be copied over, is this possible?. I was thinking of using a combo but can you copy from a combo to a sub form?