Search results

Hello, I am trying to split a string into words, with the condition that each word has at least 3 characters, something like this : str= "AAAAA BB CCC D" sWords = Split(str, " ") I am looking for this result : sWords(0)="AAAAA" sWords(1)="CCC" Any thoughts ?

that worked just great Thanks a lot for helping

somehow, to me it returns the first record in the recordset wich does not contain " > "

I understand that the issue here is with these quotes ">", Eventhough I was experimenting with the default value of a text box, my purpose was to .findFirst string in my recordset wich was equal to Spain" > "Primera División 2019/2020 I ve been trying with no sucess to include in my variable...

Hello, I am struggling with asigning this text to the dafault value of a text box Spain" > "Primera División 2019/2020 the result is a True False instead of the string, so I tryed in the inmediate window : ?""Spain" > "Primera División 2019/2020"" > 0,99950495049505 ?"""Spain" > "Primera...

You have been so helpful thanks a lot

so, I guess there is no way to replicate the use of date delimeters in a variable , and afterwards to format the string Format(fj,"dd/mm/yyyy hh:nn")

that does not work either returning a type mismatch error , but it pointed me into the right direction.I forgot to tell you that I am from Portugal, and here the month of February abreviates to "Fev" (Fevereiro) so, if the variable is like the following, it works correctly : fj = "Fev 18, 2020...

Gasman, This is very strange : I have the variable fj defined as a string, and from the inmediate window I get : ?fj Feb 18, 2020 20:00 ?Format(fj,"dd/mm/yyyy hh:nn") Feb 18, 2020 20:00

hi again, i was trying to incorporate it in my code, but it seems it´s not posible to pass that string as a variable

thanks a lot It works like a charm

Hello, I am trying to convert this string : Feb 18, 2020 20:00 into this date in this format : 18/02/2020 20:00 I guess I can get day and year easily with the mid function, but what about the month ? thanks

it worked like like this, after the page has been loaded to the webbrowser control :

hi, In myForm I have a webbrowser control that loads a webpage, with a main image the full page is loaded into the webbrowser control, but I would like to get the image slide show, obtained by clicking the main image, instead of the hole page. I have tried, with no sucess : Any thoughts ...

Paul, Thanks a lot for your help, it works fine Carlos

Hello Set rstNotDatas = db.OpenRecordset("SELECT * FROM tblDatasRec " & _ "WHERE DataRec=" & (Date)) I am trying to create a recordset in wich the field DataREc (data type) is equal to the present day. It returs zero records, but I hace 15 records in my table with todays date Something to do...

Hi, Could someone help me with this, I think it should be something easy, but I cant make it work : I am running Dev Ashish s function fHandlefile to open a pdf I have in my domain when the connection is established to open the pdf file , a dialog box pops up, for the user to enter login and...

Hi, I have been using the AcroPDF(Pdf Reader), to access pdf files located in my hard disk, and visualize them in one of my form controls, and it has worked just fine. dim p as string p = "c:\MeuPDF.pdf" AcroPDF1.LoadFile p Now that I have moved these files to a WEB server, it is not...

Hello, I am connected to A Goddday server, that has a 60 seconds timeout, after what the connection is lost and the only way to recconect is to exit Access and enter again. I have been trying to solve this problem, follwing some of the advice I found in Ms Access forums, but I have not been...

Hi, Sorry, when I said that my query was returning 1.000, I should have said 1.500 tblB id tblB.valor 1 1.000 2 5.000 3 5.000 4 1.500 5 1.000 tblC id tblc.valor 1 3.600 2 2.000...