Search results

I wonder why in the inmediate window the calculation : ?68/18032 3,77107364685004E-03 when in fact the correct result is : 0,003771

When following theDBGuy sugestion, to refer to the control rather than the field, I noticed that one of my label names was already in use "country", therefor the field name was not being recognized Thanks for your help

I am sure this shoud be something realy simple , but I cant see it: in a subform i have a control bound to a field [country] another control bound to [city], it works fine but now i want to concatenate both in one control =[country] & "-" & [city] ' the country appears blank why is...

hummmm why didnt I think about that? (y) Thanks Arnelgp

Hello, I would appreciate your help with the folowing : my query returns these records maqId descMaq --------------------------------------------- 10 Komatsu PC 130-7K 25 Komatsu PC 130 LC-8 40 Komatsu PC 30 55 Komatsu PC 230LC-6 60 Komatsu PC 130-7K 85 Komatsu PC 130 LC-8...

me.recalc did the trick thanks

humm, back with the problem again, this is disturbing

Ranman, the query does not return any null values Anyway I changed it to a countinous form, and again the same problem, but I noticed that when opening the form the calculations were displayed correctly, but when changing to design view and again to form view the calculations were not made ( I...

Hello In the footer section of a countinous report I have a calculated field (mpreco) =Sum([precoMaq]) When previewing the report the calculation doesnt show, but if I click on the control it will i've tried on the format event and others to refresh the control Me.mpreco.Requery but still...

CronK, Thanks for your reply Anyway it was my fault, i didnt notice the wrong syntax I had : Debug.Print Me.anoMaq I should : Debug.Print !anoMaq

Any ideas as to why the .moveNext method does not move to next record, it always stays in the first one Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = Me.RecordsetClone With rst Do While Not .EOF Debug.Print Me.anoMaq ' always the first record...

I ended up changing the function, and now I get the status code as 301 ( redirected page), therefor non existing Function URLExists(url As String) As Boolean Dim request As Object Dim ff As Integer Dim rc As Variant Set request = CreateObject("WinHttp.WinHttpRequest.5.1")...

Successful responses (200–299) 'Redirects (300–399) The request's status returns the code 200 wich is a successfull reponse, shouldnt I get a code between 300-399 ? after all the page is not there , and it´s being redirected to another one

I am getting different results here: http://www.google.com returns true , wich is correct my above link returns true, wich is not correct, since after attempting to load the link I am redirected to another url (https://autoline.info/-/mini-excavators--c166), wich is different from the one i...

Hello, I am willing to check if a specific webpage exist, and for that i am trying the function I got in one of previous posts Function URLExists(url As String) As Boolean Dim Request As Object Dim ff As Integer Dim rc As Variant On Error GoTo EndNow Set Request =...

Many thanks, it works great

Hello, I wonder if someone can help me with this: I created a sql string to build a query wich works fine . the end result is that I have a query ( qryBuscaB), that returns 11 records I then want to access every record in the query, like this Dim db As Database Dim rst As Recordset Set db =...

oh my Gosh, why cant I see something so obvious, do I need a neurologist ? Thanks for your help

That was what I was trying to do, I saved the value of the combo into a text box, eventhough it is a string it will be unique in the combobox data Me.lastMV = Me.mais.Column(0) then from another control i am struggling to assing the value to the combo ' set the focus Me.mais.SetFocus '...

Hello, i have an unbound combobox based on a group query, and after chosing one record I would like to have that same record highlighted the next time I setfocus to that combo, wich will happen from another control ( me.mais.setfocus) Anyway to do this?