Search:

Type: Posts; User: daveramsey

Page 1 of 2 1 2

Search: Search took 0.03 seconds.

  1. how do i modify CreateCalcsheet_click() to creat new mounth?

    how do i modify CreateCalcsheet_click() to creat new mounth?
    program attached
  2. Replies
    7
    Views
    1,306

    Re: Excel Macro not starting

    when we start this program we recieve error
  3. Replies
    7
    Views
    1,306

    Re: Excel Macro not starting

    how do i run fill the document with data?
  4. why doesn't markros start in vba excel?

    why doesn't markros start in vba excel?
    Subscribe
    186835
  5. Replies
    7
    Views
    1,306

    Excel Macro not starting

    why doesn't markros start in vba excel?
  6. Re: how do i open my web site? i have the followin error below when i try to open sit

    where is index.php css call for certificate?
  7. how do i open my web site? i have the followin error below when i try to open site ww

    DNS resolves sptravel.su to 195.201.179.80

    HTTP Server Header: openresty/1.21.4.1
    The Certificate is not issued by DigiCert, GeoTrust, Thawte, or RapidSSL

    Make sure the website you want to...
  8. 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
  9. 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))
  10. 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...
  11. 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
    ...
  12. 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.
  13. 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
    ...
  14. 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...
  15. 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
    ...
  16. 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
  17. 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?
  18. 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 =...
  19. 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)
  20. 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?
  21. Re: how do we fill in school table age column from age table using age column with vi

    access
  22. 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;
  23. 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
  24. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

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

    how do i make insert with descreat?
  26. 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 =...
  27. 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
  28. 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 |...
  29. 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...
  30. 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...
  31. Re: how can i in visual basic console track date that is being inserted in table usin

    how do we do it? instruction
  32. 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
  33. Re: how can i in visual basic console track date that is being inserted in table usin

    no output? empty field
    170443
  34. 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 = Итого.Фирма)"
  35. 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...
  36. 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
  37. 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...
  38. 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...
  39. 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...
  40. 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...
Results 1 to 40 of 58
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width