Search results

Hello I am downloading data from the the web, and sometimes I get an error, I suppose from the browser when clicking a button : ie.Document.getElementById("btn-search-header").Click the alert box error says : "error submitting form" is there a way to disable this message error . If I manually...

The function works great, thank you all for the help

Hi, I am trying to extract the email address from webpage source code, that I previously passed into a string variable (webStr) : I am only pasting part of the string wich is way too long : inc38_columns1_col_bg_2" rel="inc38_container1"></div><div class="wp_column inc38_columns1_col_1"><div...

Now I got it . my form, and my code are competing to edit/save records. No sql server or bit fields but, Isaac's idea works like a charm Thanks for the great help

Dim db As Database Set db = CurrentDb() strSQL = "UPDATE tblEmpresas " _ & " SET ActividadeID = " & zz & ", categoriaID =" & z2 _ & " WHERE metadados = '" & meta & "'" db.Execute strSQL Me.Form.Requery After I run the query a messagebox "This...

I will probably have to store in a table, the characters that my function cannot deal with,and do match with ChrW(). Thanks for your help

Hi, I ve been using the following function to remove special characters, specific to some languages: Public Function TiraAcento(sTexto As String) As String 'Retorna o texto sem acentuação Dim Carac_esp, C_especial, C_subst As String Dim F_tam As Integer, F_pos As Integer Dim conta_letra As...

you are right the single quotes were not the correct character, and also the extra quote after the second AND now everything is working fine Many thanks

Hello, I do have this Dlookup function that works, in case that [win] is a control in my form : =Nz(Dlookup("[apostaid]";"tblApostasTemp";"[bookieID]=" & [Forms]![frmApostas]![bookerID] & " AND [jogo]= '" & [jogo] & "'" & " AND [resultado]= '" & [win] & "'");"X") I want to change it because...

the query is not read only, so I did what you suggested and ... it works great, thanks a lot !!!

Hi, I want to run a delete query like this : DELETE tblApostasTemp.*, tblDatasJogos.data FROM tblApostasTemp INNER JOIN tblDatasJogos ON tblApostasTemp.jogo = tblDatasJogos.jogo WHERE (((tblDatasJogos.data)<Now())); None of the joining fields are primary keys in each table...

the DMáx is correct, wich is automaticaly corrected by Access according to the portuguese version of Ms Access I am working with the issue was realy what Mickjav mentioned, wich were the spaces before and after tblPlacardTodosAvg I.E. " tblPlacardTodosAvg " that is what happens when I choose...

hello, I would like to retrieve a value with the DMax function , from a form, a cant figure out the right syntax =DMáx("[plaganha]";" tblPlacardTodosAvg ";"[bookieID]=" & [Forms]![frmApostas]![bookerID] & " AND [jogopla]= """ & [jogo] & """") the field [bookieID] is an integer the field...

Thank you all for your help, everything is working fine ;)

thanks for your code. I was trying to avoid the DAO. recordset, mainly because by finding the first match would be just fine. I just cant find out how to do it with dlookup DLookup("[distritoID]", "myTable", "left([cPostal],4) = """ & fString & """")

so, dlookup wont find any records ?

myTable has a field called cPostal with these records : 2560-999 2399-142 2870-182 2999-600 I do have a dlookup that finds a match, but in case there is no match I would like to find a partial match for the first 4 characters, so let ´s say I am looking for the string 2870-000 since there is...

Definetly your suggestion would be my first choice if posible. I ll check into that Thanks a lot for your help

by the way, another possibility, would be to download the image and store it in my database, so instead of having the field PhoneNumber as a string it would be an image, plus the phone number is not relevant as a search string do you believe this would be a solution ? taking into account that my...

humm, bad luck Thanks anyway