Search results

Thanks guys I got it.

i tried RTrim(Mid([model],1,InStr([model]," ")-1)) it's not working it's only parsing the first section. all i want is to extract field after the #sign for example mmmddd#44 i want to get 44,but I can't count cuz each field has different lenght. thanks for trying to help.

Ok i'm back, i want all characters after the # sign I tried the expressions no luck please help.

I have a field in a table that looks like this for example MNJUIIII#33, mnnn#2, i want to parse the number in the query in a new column like 33, 2 how do I do that? Thanks.

has anyone fiqured out how to do it, I have the same problem!!!!!

:) Thank you so much, I'm sorry for the delay but I used it one more time LOL.

Thanks I ended up doing what you suggested, I put the pic in the header of the form and I displayed it on click even of each record.

I have designed a form that displays the photo thru a photo path, the problem is that when I change the form to continous form, only the first images shows for all records, until i click on the second record it displays the second photo for all records. I know this is happening because of the...

Grid Lines Did anyone fiqure that out, i'm trying the same thing.

Thank you so much for your help in this matter.

Still waiting for help. thanks.

I'm trying to create a global holiday database, can someone help me to get the global holiday in an excel sheet then i will put it in an access table. thanks.

Thanks man your the best.

Last Parentathies thanks guys, there is only one iusse if a record has more than one Parentheses, i only want to extract the last Parentheses at the end of the line, example, abddkc(100),ddkkdkdk(900). I want to extract the 900 since it's at the end of the line. what is showing me now is...

thanks Doug, Thanks everybody.

can someone help can you guys help I still get the ")" at the end example (1234) i still get 1234) i want to only see 1234. Thanks.

Thank you so much, but it still shows the right ) example 123) i want to remove the right ) thanks.

I"m sorry but what is vbTextCompare? thanks

Hi, I hope that some one can help. I have column that ends with (1232) how can i extract only the 1232 for example,moved car to blablabla(1232) I want to create a new column and insert only what's in Parentheses. thanks in advance.

there is about 10,000, but still a problem, I am showing the duplicates, but i'm showing extra records, for example if a tag # is showing twice or more for different device #, then this is a problem and i want to show it, but if i have more than one tag # that belong to more than one device with...