Recent content by cheekybuddha

  1. cheekybuddha

    Filter a subform combo based on data from the main form

    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...
  2. cheekybuddha

    Filter a subform combo based on data from the main form

    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...
  3. cheekybuddha

    Filter a subform combo based on data from the main form

    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 ?
  4. cheekybuddha

    Solved Get the last value from a query using VBA

    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...
  5. cheekybuddha

    Solved Get the last value from a query using VBA

    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
  6. cheekybuddha

    Solved Grand Total of a total field from 25 tabbed pages

    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)
  7. cheekybuddha

    Solved Access Pass-Through MariaDB

    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...
  8. cheekybuddha

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    @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.
  9. cheekybuddha

    Solved Access Pass-Through MariaDB

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

    Solved Access Pass-Through MariaDB

    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...
  11. cheekybuddha

    Solved Access Pass-Through MariaDB

    ummm... Did you try it?
  12. cheekybuddha

    Solved Access Pass-Through MariaDB

    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...
  13. cheekybuddha

    Solved Access Pass-Through MariaDB

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