Search results

  1. C

    Running Public Sub in parent form from child form

    Thanks Galaxiom, that worked nicely
  2. C

    Running Public Sub in parent form from child form

    Yes, I changed it to Public That would work if the button was in the parent form, but (my mistake), Actualy the title in my post is incorrect since the sub to be runned is not in the parent form(frmMagicCont), but rather in the first child ([Procura de Documentos]) form, and i will be calling it...
  3. C

    Running Public Sub in parent form from child form

    I wonder if this is posible ! Can I run a Main form button's Public Sub , from the child form ? str = "AAA" [Forms]![frmMagicCont]![Procura de Documentos].[Form]![Descritivo] = str ' this parts works fine Call Forms([frmMagicCont]![Procura de Documentos]).Command68_Click ' this part does not
  4. C

    build sql search string

    I do have to create the tblManufactors, to make the search more efficient, but in the meantime arnelgp 's string works for both cases "BobCat S 100" and "BobCat S100", excluding other undesired records containing the "S" character Many thanks
  5. C

    build sql search string

    it does find both, but it also finds "bomag s 45", and others containing the "S" character, therefor it might be the best to find the manufactor in each field to exclude all the non-bobcat records Thanks for your help
  6. C

    build sql search string

    This is an ongoing web scraping, so i guess i should clean the current data, and also the code when importing new records
  7. C

    build sql search string

    That is a good idea. I also noticed that the manufacturer always comes first in the string and afterwards the model , so if I find with instr the position of the existing manufacturer, perhaps I could remove all the spaces thereafter Bobcat S 100, would become Bobcat S100 i guess I will have...
  8. C

    build sql search string

    with that syntax I can get all the results matching "Bobcat S 100", but not the "Bobcat S100" i guess it would be better to have two different fields for Manufacture and model, but the data is being added to the table in a non structured way, via webscraping, wich makes it difficult to split...
  9. C

    build sql search string

    hello, i am building a sql setence in order to query records in the field(descMaq) in a table (tblMaq), assuming that my search string is: stTextoLibre= "BobCat S100" i run the code to build this part of the sql statement While fincadena = False i = i + 1 If Mid(stTextoLibre, i, 1)...
  10. C

    recalc subform after orderBy

    😂😂 you are right i hadnt notice that. the brain works in misterious ways
  11. C

    recalc subform after orderBy

    hi theDBguy, i was trying requery, and refresh, but not recalc it solved the problem, many thanks for you r kind help
  12. C

    recalc subform after orderBy

    Hello, Can you help me understand this : I do have in my mainForm a control that gets the value of a control in mySubForm footer: 1 - control [sa], in subforms footer : = Avg(Val([anoMaq])) 2 - control [tAno], in myMainFrom =[frmB].[Form]![sa] it works fine until I run the following code...
  13. C

    delete duplicates from table

    Thank you all for your help I ended up using arnelgp approach wich works great
  14. C

    delete duplicates from table

    i was looking for a way to delete the records where the field horas and the field ano were equal, and not where the field maqID repeats, so I tried this that didnt work : DELETE FROM TableName WHERE maqID IN (SELECT maqID FROM TableName GROUP BY ([horas] & [ano]) HAVING Count(*)>1) I also...
  15. C

    delete duplicates from table

    isladogs, i will give it a try, and let you know how it went thanks
  16. C

    delete duplicates from table

    theDGguy, sorry , you are right i meant 6 and 8
  17. C

    delete duplicates from table

    Hi there, I would appreciate your advice on the right way to do this : i have a recordset, of wich I would like to delete the records where the field horas and the field ano is repeated in one or more records maqID ano horas 1 2002 6300 2 2003 6300 3 2002 6400 4 2015 2530 5 2014...
  18. C

    get part of a string according to delimeter

    thank you guys, the split function works like a charm
  19. C

    get part of a string according to delimeter

    i will try split and let you know thanks for helping
  20. C

    get part of a string according to delimeter

    no, the format is not consistent, the length of each set of numeric characters can go from1 to 6
Back
Top Bottom