Search:

Type: Posts; User: tatendatiffany

Page 1 of 2 1 2

Search: Search took 0.03 seconds.

  1. Re: VB code not picking up two other columns :s

    hie,

    thank you very much that was what was missing. Thanks again you saved me a lot of time.

    Regards
  2. VB code not picking up two other columns :s

    Hie,

    So by now i think i am a board regular, i have finally managed to complete my code, so my code picks up thwe sql queries in column AK,AE and AQ and it runs these and displays the results in...
  3. Re: Duplicate part of data twice...any ideas ??

    ok so the sql queries are on the excel sheet in one column (AG2:AG39) and the code i executes the sql query and display them in the sheet on different columns. So now i want to replicate the same...
  4. Duplicate part of data twice...any ideas ??

    So i have this piece of code that runs the sql queries in the excel sheet and returns the value onto column Z to AD on the sheet now i want it to do the same with 2 other columns of sql queries so...
  5. Replies
    6
    Views
    10,102

    Re: ADODB.Recordset error '800a0e7d'

    Hie,

    Sorry that part of the code i mean to delete the right format is the modules getresults. I cant seem to identify the problem.(which has the array) :(
  6. Replies
    6
    Views
    10,102

    Re: ADODB.Recordset error '800a0e7d'

    wait i am getting the exact same error and i have checked but my connection is open and i am connected can some one please please help me.
    Public Function ConnectToDB(username As String, password...
  7. Replies
    11
    Views
    732

    Re: Login message

    thank you both for your help i will try it out and see if it works :):wave:
  8. Re: Error message: An unexpected token "

    Actually i think that could be the problem i have been double checking the sql and i had to add ' and "" but it doesnt seem to be updating these e.g. when i login to log they sql queries dont have ""...
  9. Replies
    11
    Views
    732

    Re: Login message

    So after login, some of the sql queries that are executed have errors then i have to fix then when i run it again it asks me login again. So for provision I wanted to add something that only allows...
  10. Replies
    11
    Views
    732

    Re: Login message

    Sorry for a not so clear description of my problem, so the form appears again when i stop running the code in the middle e.g. because of an error and it runs again from the start it prompts me to...
  11. Re: Error message: An unexpected token "

    ok sorry for not mentioning all the other information so the get results goes to the excel sheet and run sql and here is more of the code:




    Public Function ConnectToDB(username As String,...
  12. Re: Error message: An unexpected token "

    the database it is connecting to is db2 an it doesnt seem to accept my sql statements "Use dbname" doesnt seem to be an acceptable format. The connection is working , successfully connected into the...
  13. Error message: An unexpected token "

    I am getting this error message when i run my getresults loop
    "SQL0104N An unexpected token "<END OF STATEMENT>" was found following "".Expected tokens may include "IS".



    Sub getresults()
    ...
  14. Replies
    11
    Views
    732

    Login message

    Hi,

    Can anyone help me i need a code that allows only the user to login in once, and if they are logged in but the logged form is displayed(instead a message, restricting need to log in again when...
  15. Re: Code no longer working: Method select of object worksheet failed.

    Never mind i have fixed the code its now working.

    I had to remove dim worksheet
    and and add activeworkbook


    Thanks again
  16. Replies
    5
    Views
    1,950

    Re: CountA Macro not working :(

    it is not erroring at all which is weird. I probably made a mistake somewhere or the whole code is messed up, let me double check and see if i should change it completely,


    Thanks
  17. Re: Code no longer working: Method select of object worksheet failed.

    Nothing has changed apart from copying the code onto another identical worksheet just a different version. and the columns in which the results are to be displayed.

    So I should not even have...
  18. Code no longer working: Method select of object worksheet failed.

    my code was working before but now i am getting this error message "Method select of object worksheet failed": on the line in bold anyone know why??


    Sub CountIF()
    Dim x As Long
    Dim ws As...
  19. Replies
    5
    Views
    1,950

    Re: CountA Macro not working :(

    I need it to be dynamic and I want the result to be displayed in sheet 1 column y2, I have modified this code

    Sub COUNTA()
    With ThisWorkbook.Sheets("TABF10").Range("F:F")
    With...
  20. Replies
    5
    Views
    1,950

    CountA Macro not working :(

    I am trying to turn this counta query into a macro does anyone have an idea of how to do it:

    =COUNTA(TABF10!F:F)-2
    and also this sum into a macro
    =SUMPRODUCT(KTPT81T!G:G)

    this is what i...
  21. Re: Why is it not working but there are no errors

    At Bill thanks for the pointer I am implementing you changes now and from stepping into the code i am going to encounter another error "application defined object not defined " . so from my code...
  22. Re: Why is it not working but there are no errors

    yes i do and currently there are no errors the logfile.
  23. Re: Why is it not working but there are no errors

    hi,

    nothing is being outputted or displayed in the immediate window :confused:

    so no records are being retrieved :(
  24. Re: Why is it not working but there are no errors

    thanks so much for you response at Bill Crawley what do you mean which leg?? does it step into and westconn1 i have added you suggestion and also this line to my code: but still nothing i am sure it...
  25. Why is it not working but there are no errors

    Hi

    I am having a minor problem with my code it connects to the database but when i click the retrieve button to run the sql queries it doesnt return anything. but there are no errors when i...
  26. Re: HELP: VBA errror in my loop not working.

    no they are not on the same line which is baffling me i think i wil go have a look at the whole code maybe there is something in there aming this error trigger :confused::confused:


    Thank you
  27. Re: HELP: VBA errror in my loop not working.

    Hi

    ok so i know my problem has been ongoing but i left it for a while to do more work in addition to this. now i am getting the error message : "application or object defined error" on the line in...
  28. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    ok so a simple empty recordset is what i need to rectify and also change the db to my connection.
    Thank you
  29. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    hi,

    thank you for getting back at me well i substituted the addition for a minus sign because i have added more columns to the sheet so the column location has changed slightly.

    with your code...
  30. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    So i have been looking around and this is what i have so far the changes are in bold: any help or assistance will be very much appreciated: but currently it is giving me the "method or data member...
  31. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    I'm back and i hate always coming back with more confusion and questions but could i ask from my understanding the loop icks up the string from the excel cells and passed to the function...
  32. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    Nevermind about the question Steve I have looked around a lot more about recordsets and now it is starting to make more sense :)
  33. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    thank you for you detaile explanation now i am starting to get the hang of it all but can i ask one more question please. the actual recordset i am struggling to understand, i mean i get the concept...
  34. Re: HELP: VBA errror in my loop not working.

    Sorry I have just made a comment on the pther post to have eveyone refer to this one from now on.
    sorry again for posting two threads on similar question
  35. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    Anyone facing similar issue please refer to this thread, as u had mistakenly posted two different posts on similar issue
    http://www.vbforums.com/showthread.php?p=3996596#post3996596


    Thanks
  36. Re: HELP: VBA errror in my loop not working.

    Thank you for you help i but when i used it i am getting an errror "obejct required" on one of the lines:
    could it not be easier to use the code i showed earlier because it is almost complete all i...
  37. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    hi sparbag can i ask 1 more question actually something i came across when i was trying to make more changes to this code and make it work why did you use getrecordset is it not standard vba function...
  38. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    Thank you again i am going to work on the coding today and hopefully tomorrow i will be posting the working code.

    Thanks again:)
  39. Re: HELP: VBA errror in my loop not working.

    Sorry for not explaining in greater detail this is an example of what i want to do:
    i wanted the codes to stay on the excel sheet. i have 5 different columns A2:39-E2:39 they each have sql queries...
  40. Replies
    23
    Views
    1,785

    Re: Recordset confusion and stuck

    :)thank you so much for your help and the explanation, I am going to modify it and make it work for me.

    Thank you again
Results 1 to 40 of 66
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width