Search:

Type: Posts; User: daveramsey

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    https://drive.google.com/file/d/1-2guxmL3RbWiyP6H1eIA1N3XqzvD4I_P/view?usp=sharing
    file for download
  2. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    compile error variable not define
    Set fnd = Rng.Find(.Cells(d, 1))
  3. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    compiler error variable not define on line Set Rng = Range("a:a")

    Option Explicit
    Sub Insertdata()
    Dim src As Workbook
    Dim iAge As...
  4. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    comiler error syntax error

    Option Explicit
    Sub Insertdata()
    Dim src As Workbook
    Dim iAge As Integer
    Dim t As Integer
    ...
  5. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    why my program does not work right?The program do not copy all values from age.xlsm age column to another age column in shchool.xlsm file according to name column. Name is key in tables.
  6. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    Option Explicit
    Sub Insertdata()
    Dim src As Workbook
    Dim iAge As Integer
    Dim t As Integer
    Dim d As Integer
    ...
  7. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    new version why program does not work Run-time error '1004' application-defined or object defined error on line If Cells(d, "A") = iName Then

    Sub Insertdata()
    Dim iAge As Integer
    Set src...
  8. MsOf13 How do we remake the program to copy not one value value but with range in column age

    How do we remake the program to copy not one value value but with range in column age? We need copy all values from age.xlsm age column to another age column in shchool.xlsm file

    school.xlsm
    ...
  9. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    where do i read about left outer join
    and how do i make it with visual basic for 20000 records very slow
    https://www.vbforums.com/images/ieimages/2021/04/16.png
  10. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    why does the insert so slow can we remake with visual basic the same?
  11. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    why we can not use right join in access like in Oracle finance istead of insert?
    UPDATE schoolmark RIGHT JOIN NEWschoolmark ON schoolmark.field1 = NEWschoolmark.field1 SET schoolmark.field3 =...
  12. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    is it right?

    INSERT INTO table1 (field1,field2,field3)
    Select
    field1,
    field2,
    field3
    From table2 t2
    WHERE t2.field1 NOT IN (Select field1 from table1)
  13. Re: how do we fill in school table age column from age table using age column with vi

    but try to do the same task in excel by importing
    is it possible to usa visual basic to automate?
  14. Re: how do we fill in school table age column from age table using age column with vi

    access
  15. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    Why don't work
    UPDATE schoolmark RIGHT JOIN NEWschoolmark ON schoolmark.field1 = NEWschoolmark.field1 SET schoolmark.field3 = [NEWschoolmark].field3;
  16. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    what is insert we can make for table schoolmark insert values from Newschoolmark that absent in table schoolmark ?
    booth table have the same three fields fields1 fields2 fields3 and key is field1
  17. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    ms access 2016 in database yes support merge
  18. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    how do i make insert with descreat?
  19. How do we change our update statment? we want to add rows from NEWschoolmark table th

    How do we change our update statment? we want to add rows from NEWschoolmark table that does not existed in schoolmark table
    UPDATE schoolmark INNER JOIN NEWschoolmark ON schoolmark.field1 =...
  20. Re: how do we fill in school.xlsx file age column from age.xlsx file by using name co

    how can we use in vba this line
    =ЕСЛИОШИБКА(ВПР(A10;'D:\school\[age.xlsx]Sheet1'!$A$2:$C$26000;3;0);"Not found")
    and instead of Not found the value that do not change
  21. how do we fill in school table age column from age table using age column with visual

    how do we fill in school table age column from age table using age column with visual basic access using update? Tables have variable length and have more than 10000 rows.

    school table

    |A | B |...
  22. how do we fill in school.xlsx file age column from age.xlsx file by using name column

    *how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual basic in excel? Tables have variable length and have more than 10000 rows.

    school.xlsx

    |A | B...
  23. i have an excel file with table of values. I need to find all cells with name and low

    i have an excel file with table of values. I need to find all cells with name and lower marks in row and other rows with the same name and higher marks must be removed. Can i use bulid in excel vba...
  24. Re: how can i in visual basic console track date that is being inserted in table usin

    how do we do it? instruction
  25. Re: how can i in visual basic console track date that is being inserted in table usin

    according to instruction do not run

    picture previewer
    https://drive.google.com/file/d/1EMeBZQmdV-ZVbEF4TRONsnPWM0F1w2yC/view
  26. Re: how can i in visual basic console track date that is being inserted in table usin

    no output? empty field
    170443
  27. Re: how can i in visual basic console track date that is being inserted in table usin

    this line do not return any output
    sSQL = "SELECT Поле3 FROM TOYOTA_1_2011 INNER JOIN Итого WHERE (TOYOTA_1_2011.Поле1 = Итого.Артикул) AND (TOYOTA_1_2011.Поле2 = Итого.Фирма)"
  28. Re: how can i in visual basic console track date that is being inserted in table usin

    we have access program how do i find where it takes values from which table to insert into result file field 0.02 from which table for element PT92542130



    tb_table is table that contain list of...
  29. Re: how can i in visual basic console track date that is being inserted in table usin

    we have access program how do i find where it takes values to insert in fild 0.02 from which table for element PT92542130
    tb_table is table that contain list of tables
    170441170441
  30. Re: how can i in visual basic console track date that is being inserted in table usin

    this query gave the list of tables but how do we get values that where selected by the query?

    TOYOTA_1_2011
    TOYOTA_2_2012
    TOYOTA_3_800
    TOYOTA_4_AUTODUBAI
    TOYOTA_5_AUTOPITER
    TOYOTA_6_BASE2014...
  31. Re: how can i in visual basic console track date that is being inserted in table usin

    but can i find what values and where taken and inserted in what table?
    can i use this method

    Dim MyVar
    MyVar = "Come see me in the Immediate pane."
    Debug.Print MyVar

    for example i want to...
  32. Re: what does this code do? Can you explain? Can you give me manual in internet?

    how do i make output from these lines below using Debug.Print for !nm_tabl variable? we need also values Total.weght , & !nm_tabl & ".Поле2 , Total.Артикул in immdiate windows for ever cicle of the...
  33. Re: how can i in visual basic console track date that is being inserted in table usin

    how to make output from this lines below using Debug.Print?
    we need values Итого.Вес in immdiate windows for ever cicle of the program.

    Do While Not .EOF
    SysCmd...
  34. how can i in visual basic console track date that is being inserted in table using co

    how can i in visual basic console track date that is being inserted in table using compiler?
    how to set up Debug.Print to watch what date take from what tables?
    give me instracrion
  35. Re: what does this code do? Can you explain? Can you give me manual in internet?

    how to set up Debug.Print to watch what date take from what tables?
  36. Re: what does this code do? Can you explain? Can you give me manual in internet?

    how can i in visual basic console track date that is being inserted in table using compiler?
  37. what does this code do? Can you explain? Can you give me manual in internet?

    what does this code do? Can you explain? Can you give me manual in internet?

    Private Sub Вес_Click()
    Dim rs As ADODB.Recordset, Фирма1 As String
    Фирма1 = Nz(DLookup("Фирма1", "Итого"))
    Set rs =...
  38. the program doesn't work right. it must took values from file Avto_a.accdb from third

    the program doesn't work right. it must took values from file Avto_a.accdb from third colums from table TOYOTA_95_TS18.csv for example value PT92542130 give 20 and in result file must be 20 but we...
  39. Re: When pressing button to run procedure Кнопка7_Click(), the program works for 5 ho

    we have 574845 rows in CSV file.
  40. Re: When pressing button to run procedure Кнопка7_Click(), the program works for 5 ho

    please download source code files
    inside you can easy read code
Results 1 to 40 of 51
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width