Recent content by Analyst2004

I am new to VB and I have a simple requirement - I have a directory which has 3 excel sheets and I need to combine them programatically into one workbook so that each sheet is on different tabs(wksheets) within that. I want to do this via Access/Vb when user pushes a button. Directory...

I have a requirement to get the IP's stored in a table in a standard format. The IP's are as below. I'm just taking into consideration the first Octant currently. 010. 011. 167. 001. 065. 170. I need to change these in the format below and remove the zero padding.As there are millions of such...

A very basic question about SQL , about Temporary Substitution Variable that is '&' Ampersand Whenever I use '&' to accept input from user before running a sql statement, I get a standard prompt. See Eg. below. SQL> Select * from Emp where empno = '&eno' ; 'Enter value for eno:' Is...

ok foolio12 & PHV I tried your advice and in the query design - properties saved the ODBC info (which appended few things to my string as below.) So, on copying this in my Code, I was able to avoid the prompting of server & user info and was able to run it Successfully. THANKS A TON...

Thanks friends for your suggestions.... I used ORACLE ODBC Driver instead.I created a System Data source and tried to run the code. It is ABLE to connect. However each time it asks for the Service name and User name (pwd already populated). Even though I am supplying the connection service...

I need to query Oracle database while I am in Access. I am able to programatically create a passthrough query and change its definition as required. My problem is that my query gives ODBC error and can't connect first time. However, if I manually do a sample passthrough query and then come...

I am trying to run a query select id, subid, brand from xyz where code = 'A' and (id,subid ) NOT IN (select substr(z_id,1,3) , substr(z_id,4,3) from ABC where model = 'P') My problem here is that the "NOT IN" does not work as expected and returns all rows which meet the condition...

Ya, plus80 -s works... I am not getting the sqlplus window now. thanks

I am running a Batch file (.bat) from Windows 2000. This Batch file invokes sqlplus and calls a sql script.Once the script is executed, I get a dmp file in the specific location in C Drive as coded. However, when I execute the batch file which invokes a sqlplus -s session, I get two windows 1...

Order by Input - Here means that I want to arrange the rows as per the data supplied by the user. I just want the output to be just as the user entered the input values, and not sort it any default order. I cannot use union all as I have multiple OR-conditions and Union will make the stmt too long.

Thanks Turkbear for the suggestion, but with each DECODE stmt, you notice a new variable, (which however represents the same column in the table). BUT - since I want the user inputS in same SQL stmt, I have to use multiple input variables, SO the QUESTION still remains unanswered. more...

I take 4 pair of inputs from user in a SQL query with '&Variable'. The input is part of DECODE statement(in the Where -Clause) and it pulls the data from the Table as per the DECODE condition. However, my result set is not in the order of the user-input. I want to sort it as per the data user...