Search results for query: *

Can I run the display utility command and capture the results from a VB application with an ODBC connection? I am running DB2 V7 on the mainframe and accessing it via DB2 Connect V7. Thanks in advance! Scott

Thank you, that helps very much!!!!!

I'm new to DB2 so if this is obvious please forgive me... I have several .NET application that will be accessing our DB2 v7 mainframe database (more specifically a view). I have the authorized application names stored in another table. I need to see if it is possible to capture the calling...

That works great jsteph, THANKS!!! now.... is there a way to pass in a parameter value to the query in that same code?

I will give that a shot in just a few minutes jsteph. Thanks for your help.

...= new adodb.recordset rs.open("SELECT DISTINCT Address FROM tblYourTableName"), conn MyArray = rs.getrows() rs.close rs.open("SELECT * FROM tblYourTableName ORDER BY Address"), conn with rs for i = 0 to ubound(MyArray, 2) if MyArray(0,i) = !Address then...

The reason I'm trying to use the saved query name is because it is a very large SQL statement and I am trying to keep my code as clean as possible. Any overhead associated with ADO would not be an issue as this is a smaller system with few users.

Try adding .value to the end of RippedName If Not Isnull(Me!RippedName.value) Then AppName.BackColor = 12632256 Else AppName.BackColor = "some other color code" End If

...adodb.recordset set conn = currentproject.connection set rs = new adodb.recordset 'normally I would do something like this 'rs.open "SELECT * FROM tblTest", conn 'however I want to use a query saved in my database rs.open qryMyQuery, conn 'this doesn't seem to work as I'm...

Me.Controls() works perfectly!!! Thanks!!! I'm still looking at the Eval function to figure out what I did wrong. I know I used that before but it was Access 2002 and I wasn't sure if there was something different there or not.. Thanks for all your help!!!!

Since there are no control arrays in VBA (that I know of...) I'm using a for loop with the eval function to try to clear out some labels... for whatever reason, I get an error message stating "Microsoft Access can't find the name lblFname0 you entered in the expression" however...

I need to have an Access report that is viewable and printable from an ASP page. I also need the report to be dynamic so each time a user ran the report Access would re-export the report to a snapshot. Any help or comments would be greatly appreciated. Thanks, Hopper

I might be confusing DAO and ADO here, but would it be faster to do a connection.execute instead going through the Recordset? something like: Dim ConstDb As DAO.Database Set ConstDb = CurrentDb() ConstDb.Execute "UPDATE AllFlatFile SET PriceType = 'USD'" Set ConstDb = nothing...

I am trying to find a way to have MS Access reports available to users through my ASP web-app. Is there some way to either publish these reports in an ASP or HTML page so the server would pull fresh data every time the page is requested? Or is there a way to have the application spit out the...

That's perfect!!!! Thank you! Scott

I'm sure this is an easy one, but I need some help. I need to find out if any one radio button in a group has been checked where the number of radio buttons isn't known until run time. I was using if (form.radio1[0].checked = true || form.radio1[1].checked = true...) but now the number of...

That worked!!! Thanks so much!!! Scott

I'm working on a online questionare. The site reads in the questions from a text file so the number of questions and radio button groups is unknown until the asp page runs. I need to validate that the user answered all the questions before the onclick event of the submit button. I am trying...

Sorry, I'm using an ODBC system DSN

set conn=Server.CreateObject("ADODB.Connection") conn.Open("SiteVisit") set RS = Server.CreateObject("ADODB.recordset") strSQL = "SQL string..." RS.Open (strSQL), conn 'Read RS into an array RS.Close set RS=nothing conn.Close set conn=nothing then...