Search results

looks perfect thanks :) the only problem is that when I try to query using the right format, the query doesnt' give me any results, for example I put 01/01/2014 but I dont get any results, eventhough the funcation has made it look like 01/01/2014, any tips , thanks.

Hi, I have linked ms access to orcale to run a query, the date in orcale is in this format 20140101, i have tried to convert the date in the query like that but it's not working. format(mydate,"yyyy/mm/dd". Does anyone know how to do it. Thanks.

Is there a way i can convert the weekend days into working days for example. 5/4/13 1:30 PM is on saturday what function can I use to make this day read 5/6/13 8:00 Am which is monday. Same thing for holidays. Thanks.

Hi, Once I upgraded access to 2010 my frmcalendar doesn't work anymore, anybody has experienced this issue. It's still working fine for ms access 2007. Here is the function i'm using. Public gtxtCalTarget As TextBox 'Text box to return the date from the calendar to. Public Function...

Perfect :)

Brian, I tested it's working perfect, except there is one condition, it's also pulling any words that are 10 characters long, in your code i know you are specifying only 10 characters that include numbers right? if this is the case it shouldnt' pull 10 characters that dont include numbers! Am I...

Brian, your the best thanks Sir :)

Sorry for the delay, here is an attachment highlighted in red : thanks sir.

vbaInet please do you have a solution :)

I mean it would serve my needs for now to just extract all strings with 10 charactrs long from column A. Please help if you can.

Hi, here is an example in the attachment. Please forgive me I meant to say 10 characters long. Now I know this is not the best approach to count 10 characters because there might be other strings that don't match model ID's but I just wanted to get a start first. Can you please help?

I tried the function but it's not working, i gives me blank results and sometimes keep looping, i have to kill the process. :(

Thanks Sir God bless you and your Wife :)

Well the easiet way is to look for all words with 8 characters long and extract them into a seperate field. Then if i run into problems i have to approach it in a different way for example start at teh first three characters to see if they match a list of models then extract. But first I would...

Ok lets assume that the model id starts with either ABC or DDC or FMC ect. in this case we have two ways to recognise it by either the first 3 starting character or by the character lenght of the whole text.

Can't we recognise it by the text lenght, like anything that is 8 characters move it to a different column? I'm still trying to find another way to recognise it maybe my the first 3 characters or something but the first 3 characters are never the same!! man this is not easy. :)

Hi I have a memo field that contains model ID and model description and blank spaces ect... the data doesnt have the same formate in each raw, it's kind of messy, I'm trying to extract the model ID it's 8 characters long. Can anybody suggest a way? if possible do you guys know the function in...

HI Brain, Thank you so much for your help, what you are saying makes sense thanks yes it is addding 540 minutes, I think it's probably adding a whole day which i shouldnt', what makes me confused is that this is working perfectly on a different database. Regarding your question if this is...

I know it's a late response but that's a lot it worked :)

Well I agree with what your saying but here is what I'm getting when i run the networkminutes fucntion between two dates. Please dont assume that I have to divide by 10 because it might work for some numbers but not the others. Thanks. As i mentioned before could it be my dates's fomrate...