Search:
Type: Posts; User: tatendatiffany
Search:
Search took 0.03 seconds.
-
hie,
thank you very much that was what was missing. Thanks again you saved me a lot of time.
Regards
-
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...
-
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...
-
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...
-
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) :(
-
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...
-
thank you both for your help i will try it out and see if it works :):wave:
-
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 ""...
-
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...
-
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...
-
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,...
-
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...
-
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()
...
-
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...
-
Never mind i have fixed the code its now working.
I had to remove dim worksheet
and and add activeworkbook
Thanks again
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
yes i do and currently there are no errors the logfile.
-
hi,
nothing is being outputted or displayed in the immediate window :confused:
so no records are being retrieved :(
-
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...
-
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...
-
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
-
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...
-
ok so a simple empty recordset is what i need to rectify and also change the db to my connection.
Thank you
-
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...
-
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...
-
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...
-
Nevermind about the question Steve I have looked around a lot more about recordsets and now it is starting to make more sense :)
-
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...
-
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
-
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
-
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...
-
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...
-
Thank you again i am going to work on the coding today and hopefully tomorrow i will be posting the working code.
Thanks again:)
-
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...
-
:)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
|
Click Here to Expand Forum to Full Width
|