Recent content by hopper

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.

you could do something like this, but the time taken to run this will be high. If it is a one time shot or something you only run occasionally it might not be an issue. Something like this: dim MyArray as variant dim conn as adodb.connection set conn = currentproject.connection dim rs as...

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

I'm sure this is simple, but I'm having a heck of a time trying to open an ADO recordset based off of a stored query. I am using access 2002 Code looks something like this. dim conn as adodb.connection dim rs as adodb.recordset set conn = currentproject.connection set rs = new adodb.recordset...

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