Search results

I would expect to get the value visible when we load the webpage wich is 265898211 Can I not retrieve that value because it's not text , but an Image ? anyway to do it ? thanks

I mean, right after this line : ie.navigate "https://portalnacional.com.pt/empresa/florensis-portugal-producao-floricola-sociedade-unipessoal-lda-289251/" I have a breakpoint, where I wait for the page to load completely. Of course after I can solv this I will set a waiting time.

Pisorsisaac, It is not the lack of a waiting time, as I have runned the code stepping through code MickJav, I have read the link you sent, but I cant figure out how it can help me. I noticed that HTML of the elements I can succesefully get data from is: <div class="value">Florensis Portugal...

Hello, I am beginner with extracting data via VBA from webpages, and still I could not find a solution to this : my code gets all the values that I need except for this one : <div class="value"><img src="/images/text.php?type=empresa&amp;field=telefone&amp;id_empresa=289251"></div> Dim ie...

I built two identical queries to the other fields where I wanted to have same procedure, and it worked just fine thanks a lot for your help

Plog and cheekybuddha, I have tested your queries with my data and they return the exact same correct result I might go with cheekybuddha query, but let me ask you, can I adapt this query so that 2 more columns would be added with the same calculation (diff2 and diff) ? the fact is that besides...

hi, I would use the iff() function , but (Plaganha where bookie = pinnacle) is on one record and (plaganha where bookie=1xBet) is on another record. How to make it a calculated field in a query ? thanks

Good morning, I wonder if there is a way to achieve this : I have a table with 4 fields ( id, jogoPla,Plaganha, bookie). id jogoPla Plaganha bookie 20 item 1 1,42 pinnacle 47 item 1 1,43 1xbet 10 item 2 2,08 1xbet 21 item 3 2,56 1xbet 36 item 3 2,71 pinnacle...

It works great. Thanks a lot

hello, I wonder if it is posible to build a join query with two tables, and repeat one of the tables . something like this : SELECT tblA.name, tblA.score FROM tblA UNION SELECT tblB.name, tblB.score FROM tblB UNION SELECT tblB.name, tblB.score FROM tblB; so, I would join the data in tableB...

Hi Plog, I understand that my table is not correctly designed, actually I changed its structure in order to split my data into columns so that I could define the source data for a line chart in excel. Originaly my table was structured like this : id jogoPla pladataScrap win draw lose...

your query works great , except for the query field "marathonw"

Hello , I wonder if it is posible in case the value in a query is null to assume by default the previous value. this is how the output of my query looks like : id jogoPla pladataScrap PinnacleW marathonW 1xbetW 7594 Genk - Club Bruges 27/02/2020 02:30:50 4.03 3.94 3.90 7989 Genk - Club...

hi Bob, What you suggested plus setting the default value of the text box to "00:00" worked just great Thanks a lot

Hi I have an unbound control in my form to enter a string in time format, for that I set the input mask of the control to 00:00;0;_ Is there a way to just enter the hours part of the string in case it is the top of the hour ? 18:30 In this case I would have to enter the 4 characters of the...

Hi again, I ended up following plog's advice , and since Anum is consecutive, and no deletions are allowded, I created the two queries : SELECT tblLastW_Pinn.jogoPla, Max([Anum])-4 AS AnumBase FROM tblLastW_Pinn GROUP BY tblLastW_Pinn.jogoPla; SELECT tblLastW_Pinn.jogoPla...

Hello, I ve been struggling with this for a while now. i wonder if someone can help. I have a table with the following data : id jogoPla pw ANum 252784 Almere City Fc - Telstar 0,437538461 0 250939 Almere City Fc - Telstar 0,427038079 1 248979 Almere City Fc - Telstar 0,435046625 2...

It works great Thanks a lot

Hello I set the order of by subform data by clicking on a subform label : Me.OrderBy = "[data] Asc" Me.OrderByOn = True but, I would prefer to do it, from the main form by clicking on a command button. Like this, wich does not work : Me.OrderBy = "Forms!frmMyMain.frmMySub.Form![data] Asc"...

It works great, thanks a lot for your help:):)