Recent content by cheekybuddha

Hi, Apologies for the delay in getting back. You don't appear to have linked the subform ProductReceiveSF to the mainform via LinkMasterFields/LinkChildFields. What is the RecordSource for ProductReceiveSF? If it is just a table name, what are the fields in the table? This code seems off...

OK, Are the procedures in 1 and 2 for different controls? (The first is for ClientID, the second for cboClientID) When referring to subforms you must make sure you reference the name of the subform control. Confusingly, depending on how you added the subform to your form, this may or may not...

Hi and welcome to AWF! In number 2 you have: ... WHERE ClientID=" & Me!cboProduct Is that what you mean? Should it be: ... WHERE ClientID=" & Me.Parent.cboClientID ?

This is so wrong

No problem! As long as you know what you want. I just suggested that because in your original post you said: Perhaps you were closer originally than you thought. You could probably also use: Nz(DLookup("Registro", "CProximasCitas", "Fecha>=#" & Format(Date, "yyyy-mm-dd") & "#"), 0) (Notice...

You can optimise a bit: ' ... StrQuery = "SELECT TOP 1 Fecha, Registro" _ ' ... Also, are you sure you don't want: ' ... & " ORDER BY Fecha DESC, Registro" ' ... That should help if you have more than one entry on the same date at different times. hth, d

(y)

What happens if you just add them without Sum()? It might be prudent to handle possible Nulls too =Nz([TotalAerosolsSubform].[Form]![Cost], 0) + Nz([TotalBoltsSubform].[Form]![Cost], 0) + Nz([TotalNutsSubform].[Form]![Cost], 0) + Nz([TotalWashersSubform].[Form]![Cost], 0)

currentdb does not permit multiple values. Yeah, my mistake! :eek: I meant pass-through QueryDef.Execute, like in my example to Adelina_RO. Apologies, I thought you were complaining about the syntax of the SQL and made the caffeine-deficient typo in trying to explain the example. Definitely...

@Pat Hartman From the OP I chose Now() specifically. But no need to get your knickers in a twist, Date() contains a time element anyway even if it has a value of .0. But you're right, it's all moot anyway since using DateDiff("d") will return the same in either instance.

While you're here, Uncle G, Adelina_RO posted their password again in Post # 16. Can you remove it?

MySQL >  localhost   5.7.33-log  SQL  USE testbed; Default schema set to `testbed`. Fetching table and column names from `testbed` for auto-completion... Press ^C to stop. MySQL >  localhost   5.7.33-log   testbed  SQL > CREATE TABLE t1 ( > ID INT(11) NOT NULL AUTO_INCREMENT...

ummm... Did you try it?

Are you sure you are not getting Resources error because you are calling this sub recursively? I think you are missing my point about the multiple INSERTS. Instead of executing an INSERT statement for each recor in the local table, MariaBD/MySQL allow the ability to make multiple INSERT's at...

https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html