Search results

Thanks for your replies: theDBguy, I ve tried moving the control to the detail section, still empty bobFitz, I will add a demo on my next message

The result is the same with those two options , nothing appears, i suppose the result is empty A few monthes ago I had this form working properly, so i guess I have changed something that Is causing this. I just cant figure out how to find it

Can somebody help me with something that I thought should be simple in the first place: I have a continous form with a footer with a control "D", that sums the field debito, wich is a numeric field =Sum([debito]) Instead of the sum of the numeric fields, the returned result is blank. I noticed...

theDBguy, I ended up changing the report to "popup", and it gets rid of the ribbon thanks

Hello, I am hidding the report ribbon with : DoCmd.ShowToolbar "Ribbon", acToolbarNo , on the load event of the report that opens in preview mode The problem is that when I want to close the report I do not have a close report button. Anyway to solv this ? thanks

Sorry my fault, I had already chaged it to date(), but I copy/pasted the wrong syntax from a previous text

Gasman, I am including it like this : Public Function media(dias As Integer) As Double Dim sd As Integer, d As Date d = DateAdd("d", -dias, Now()) sd = tiraFS(d) dias = dias + sd media = DAvg("[pLast]", "qryCurrent", "dataCot BETWEEN Date() AND DateAdd('d'," & -dias & ", Date())") End...

yes I am adding the non working days with the above Function tiraFS, on post 12,

Working fine Thank you all ;)

by the way now that I try to set the numbers as a variable, I get a syntax error : dim dias as integer dias =10 vMedia=DAvg("[pLast]", "qryCurrent", "dataCot BETWEEN Now() AND DateAdd('d'," & -dias & ", Now())" without the integer variable it works : vMedia=DAvg("[pLast]", "qryCurrent"...

hehe, that was 1 not 8 :ROFLMAO:

Thanks Gasman, it worked fine Public Function tiraFS(inicial As Date) As Integer Dim n As Integer, a As Date For a = inicial To Date If Weekday(a) = 7 Or Weekday(a) = 8 Then n = n + 1 Next tiraFS = n End Function

Thank you all for the help solving this issue I ended up using the syntax provided by CJ_London, that worked just fine. the only thing I hadnt tought about was that when subtracting days from the current date, I wanted to exclude saturdays and sundays, so I guess I will have to find a function...

I noticed that the following returns the correct result: Davg("[pLast]", "qryCurrent", "dataCot > #" & DateAdd("d", -10, Now())& "#") so why would the following return Null ? davg("[pLast]", "qryCurrent", "dataCot >= #" & DateAdd("d", -10, Now()) & "# AND dataCot <= #" & now() & "#")

Unfortunatly date() and now() produce the same error

Hello, I have been struggling with this function wich returns the wrong result (25,25), when I should get (23,32) : DAvg("[pLast]", "qryCurrent", "dataCot BETWEEN #" & Now() & "# AND #" & DateAdd("d", -10, Now()) & "#") if i paste the date parameter ( BETWEEN #04/10/2021 09:10:45# AND...

Arnelgp, i followed the suggestion in your link that seems tork fine: UPDATE scraped SET scraped.dateC = DateAdd("s",[yahoodate],#1/1/1970#);

ArnelGP and Isladogs, Thanks so much, that worked nicely !!:)

debug.print s returns (part of the string)...

hello, I am trying to retrieve quotes from into my database, som I ve used the following code that I came across online, but it returns error 424 (object requiered) Public Sub GetYahooData() '< VBE > Tools > References > Microsoft Scripting Runtime Dim json As Object, re As Object, s...