Search results for query: *

You both have answered my question, thanks again.

I have a private SelectionChange and Change sub routine in my VBA code which works well once initiated, the problem I have is that I am having a hard time triggering these events when clicking on the pull down arrow of a "Data Validation" List. Excel does not seem to recognize clicking a list...

Okay, thanks I'll try it.

If I'd like to access my data from an Access database instead of an Oracle database would I need to change the subject function drastically? Or will I just need to change the connection string?

Thanks again.

In case you were wondering why I was having a difficult time yesterday, it was because there was a "/" in the User Id portion of the connection string which I did not know to exclude. cnn.Open "Driver={Microsoft ODBC for Oracle};" & _ "Server=" & sServer & ";" & _...

WOW, WOW, IT WORKED! Thanks I've learned a lot.

Okay this is starting to look even better, I'm now return the values I wanted except for the column headers.

By auto fill I take it you mean in the cell itself? I looking to hard code this whole process.

Great it worked but it's only export one value instead of the whole column and header. By the way please delete my previous post.

Okay so I've finally got this thing connected to my database. Now how to I modify the Where statement sSQL = sSQL & "WHERE ROUTE_CODE = '" & Trim(sPN) & "'"? I would like to say Where ROUTE_CODE = 'CAL0002'. Also I'm trying to return the value of my query to sheet1 of my workbook by calling...

Thanks for the help, it seems I'm going to have to back track here because I don't know how to use the immediate window, I've never had too. Up until now I've been using VBA to manipulate and compute data in Excel as a result importing to Excel from an Oracle database is foreign to me...

and this is the EXACT code that you are using and that is not workgin for you??????? Common, quit wasting time! Aside from the x's this is the exact code I'm using. It's kinda fustrating know because when I use the Excel wizard to connect to this server with my user name and password it works...

Per your request. Function GetPastDueRQ(sPN As String, Optional sNG As String = "") As Integer 'SkipVought/2007 Sep 06/ '-------------------------------------------------- ' Access: DWPROD.FRH_MRP.READ '-------------------------------------------------- ':this function returns Past Due...

Still getting the forlloing. Run-time '2147217843 (80040e4d)': Automation error I will continue in my attempt to make this work.

Gentlemen I am encountering an error (Run-time error Automation error) as I'm attempting to connect to my server. Did I change all the require variables per the code below. By the way I forgot to mention that I trying to extract the content of serveral colums in orcale and importing it into...

I think I should be fine, I only have read access, basically I'm intending on using the input box as my user interface. Regarding the code Skip wrote, I going to have to study it before I start changing it. I am only trying to return columns, not rows. Thanks all, I learn a lot here.

Thanks this helps a lot. Regarding my question as to whether or not I can use the Input Box method to assign a value to the Where statement, can it be done?

Single value for the "Where" statement and multiple rows/columns for the output.

I'd like to query an Oracle database through my VBA code how would I go about doing that in the simplest way possible? I would also like to assign the Where statement value by means of an Input Box, in other words I'd like to pass the value of the Input Box to be the value of the "Where" query...