Recent content by cpampas

  1. C

    Read stock prices from webpage

    Arnel, That works pretty well, until now with no issues Many Thanks
  2. C

    Read stock prices from webpage

    Gasman, Interesting the www.alphavantage.co API, it might be the solution for me, in the meantime ArnelGP, yes the search string is not working with the symbol i mentioned, I think BA would work https://www.google.com/finance/quote/BA:NYSE if i use MSXML2.ServerXMLHTTP i can avoid the error...
  3. C

    Read stock prices from webpage

    dim url As String Dim xmlhttp As Object Dim st As Integer Dim Content As String Dim searchString As String Dim position As Long, exchange as string url="MMM" exchange="NYSE" url = "https://www.google.com/finance/quote/" & UCase(symbol) & ":" & exchange Set xmlhttp =...
  4. C

    split string by "."

    Thank you all for you kind help I followed Mark's idea . genious ! It works like a charm
  5. C

    split string by "."

    I ve been trying this for hours with no results, I wonder if someone can give me a hand. Ihave a string: str=" On Monday, 13th Nov 2023, Baxter International Inc stock price gained 2.71%, going from $32.82 to $33.71. Volume increased on the last day and 5 million more shares were traded than the...
  6. C

    continuous form event to hide line

    the idMov gotfocus event will notwork for me since records are not being populated manualy. I ended up updating the field txtPrevious, on opening the form, and after that a conditional format of the textbox that looks like a line Thanks for your help Private Sub Form_Open(Cancel As Integer)...
  7. C

    continuous form event to hide line

    ArnelGH , in the details paint event i cannot set the value of the textbox Cj_London, the approach of mimic a line with a textbox is great, but i still dont know what event i put txtCurrent =idMov
  8. C

    continuous form event to hide line

    In a continous form is it posible to make visible a line, everytime IDMov changes ? something like this, but I am not clear on what event of the form, where the code would be triggered If Nz(Me.txtPreviousid, "") = Me.idMov Then Me.Line5.Visible = False Else Me.Line5.Visible...
  9. C

    Conditional format takes too long

    Attached rules of conditional formatting, and result with delay and without delay this is the syntax of the query qryMatchPosibleSCNB_P , the other one is similar: UPDATE tblSBNC_P SET tblSBNC_P.cor = 7000 WHERE (((tblSBNC_P.valor) In (SELECT qryMatchPosible.valor FROM qryMatchPosible ))...
  10. C

    Conditional format takes too long

    the database is not splitted, would that increase performance ? I am doing an accounting bank reconciliation of data, so the records where bcor=7000 have a debt sum equal to a credit value in another table Typically i would have between 60 to 150 records in this table, and one record in the...
  11. C

    Conditional format takes too long

    the conditional format rule is : [bcor]=7000, wich is a text field, if true it sets the color of another text box in the table to a yellow color bcor is bound to an indexed field How would rich text increase speed ? i suspect thaat this is so slow because I have a continous form, and the format...
  12. C

    Conditional format takes too long

    One Requery only wont work form me, because in between requeries the user edits data based in the control colors.
  13. C

    Conditional format takes too long

    Hello, I wonder what I could do to speed up this code : DoCmd.OpenQuery "qryMatchPosibleSCNB_P" [frmSContNBanco_P].Form.Requery 'pause the code for 1 second DoCmd.OpenQuery "qryMatchPosibleSBNC_P" [frmSBancoNCont_P].Form.Requery 'pause the code for 1 second After running each query, I have to...
  14. C

    Change background color of button

    Gasman, That worked great. Many thanks for your kind help Cheers
  15. C

    Change background color of button

    yes there is a property to change the back color
Top Bottom