Search results

June, Thanks for your help. i added this to the current event of the form, wich did the trick Me.concelhoid.Requery: Me.freguesiaid.Requery

i started with a new form and controls, just in case something else was interfiering, but the problem persists. I attached a sample

, Somehow my bound comboboxes, do not dispaly the field content after navigating to another record. it seems to be a control level design problem, since the table data exists I have done this so many times , and now i ve been dealing with this for hours, with no results --------------- combo...

Thank you that works great !!! (y)

Actually I was trying to set a filter where the field "dataFim" is greater than now() + 1 hour strfilter = strfilter & " And dataFim > Now()+1" this will set the limit to one more day, any ideas as to how to set it to one more hour ?

Cj_London I see it now, strFilter is not supposed to return records, it's just a string It worked just fine as you suggested. Thanks

Hello I am having a hard time setting multiple filters to my main form the following went just fine : strfilter = "[distritoID] = " & Me.searchDist & " And concelhoid = " & Me.searchConc & " And freguesiaid = " & Me.searchFreg Me.FilterOn = True Me.Filter = strfilter Now i am trying...

I the meantime I found a way that works as intended Dim strGPS As String Dim strURL As String If IsNull(Me.gps) Then 'Ensure we have a gps code to get a map from MsgBox "This record does not have a gps code", vbCritical Exit Sub End If...

Hello, I am wondering if the following is posible? while opening a googlemaps address with the code : strCode="40.116260, -8.243384" strURL = "http://maps.google.com/maps?hl=en&q=" & strCode Application.FollowHyperlink strURL Is it posible to open the map zooming into the location in...

Thank you, it works great (y)

Hello, Is there a simple way to get the minimum value in a query except for the zero values ? (without changing the query) the result of my query is: 25,18,6,13,0,40,0 I am using : DMin("cot", "qryline") wich returns the value 0(zero) but I want the minimum, except for zero values...

Thanks conception_nati, that works nicely

Is there a way to mute sound on my computer inmediatly beforeI use the command docmd.Quit and also when loading my start up form I would like to unMute sound again Many Thanks

Thank you so much, it worked great : SELECT tblMaq.maqId, tblMaq.descMaq FROM tblMaq WHERE ((([tblMaq].[descMaq] & ' ') Like 'komatsu *' And ([tblMaq].[descMaq] & ' ') Like '* pc *' And ([tblMaq].[descMaq] & ' ') Like '* 30 *'));

Hello, I appreciate your your help on this : I have a table that looks like the following : maqId descMaq 1 komatsu PC 30 3 komatsu PC 30 MR 4 komatsu PC 300 5 komatsu PC 300 8 6 komatsu PC 301 8 komatsu PC 130 9 komatsu TC 31 KL 10 komatsu PC 33 11 komatsu PC 30 MR 3...

Not sure this is the right way , but it worked for me Thanks for your help Do While not .EOF If !rabat > ate Then Exit Do If Not !vendido = -1 Then If URLExists(!linkMaq) = False Then .Edit...

I was hoping that I there was another way rather than if Then, to switch between loops that are equal, except for the first line Forms!frmMagicCont!frmB.Form.OrderBy = "[rabat]" Forms!frmMagicCont!frmB.Form.OrderByOn = True Me.Recalc Set rstV =...

Is there a way to set the condtions for a loop while, like this : if a = - 1 then ate= me.valor end if in case the variable (ate) is not null the first line of the line would be ---> Do While !rabat < ate and in case (ate) is null the first line would be ----->...

yes, you are right CJ_London in my example if I change the dot to a comma , I get the same result i realize now that 0.003771 is the same as 3.7711E-3 Thanks for helping

Humm, I still dont get it. how can it be the same number, with diferent format or rounding? after all : ?3,77107364685004E-03 > 3 returns True ?0.003771073 > 3 returns False Hence diferent number ?