Search results for query: *

This is the code that I have which will get the sql from all the queries in a table, and then put it into a string Sub sqlRetriever Dim qDef As QueryDef Dim sqlString As String Dim qCnt As Integer qCnt = CurrentDb.QueryDefs.Count For i = 0 To (2) Set qDef = CurrentDb.QueryDefs(i)...

This is the code that I have which will get the sql from all the queries in a table, and then put it into a string Sub sqlRetriever Dim qDef As QueryDef Dim sqlString As String Dim qCnt As Integer qCnt = CurrentDb.QueryDefs.Count For i = 0 To (2) Set qDef = CurrentDb.QueryDefs(i)...

This is the code that I have which will get the sql from all the queries in a table, and then put it into a string Sub sqlRetriever Dim qDef As QueryDef Dim sqlString As String Dim qCnt As Integer qCnt = CurrentDb.QueryDefs.Count For i = 0 To (2) Set qDef = CurrentDb.QueryDefs(i)...

I work on a Win2000 professional system that is linked to a network, giving me access to a number of drives. I have been working here for three and a half months, and everything has been fine up till last week. What has been happening is that for some inexplicable reason, I keep on losing the...

When I am in Excel, I can link to an Access Query, and then move the information over to the Excel. What I need to learn is how to get the raw SQL from that Access Query moved to the Excel sheet, thus taking away a bit of the dependency that the excel sheet has on the location of the mdb. I...

When you link an access query to an excel sheet(i.e. using MS Query), is there some way to transport the actual sql over, and put it on another page? I know that I could just copy and paste, but I would like to know if there is some sort of automated way to get it sent over. Also, once it is...

I am currently doing a qualitative/quantitative analysis comparing certain components of Microsoft Office (Excel, Access) with some of the Cognos tools (PowerPlay, PowerPlay Transformer, Architect and Access Manager). What I would really appreciate is some feedback on what you people think of...

I was wondering how I can get interactive powercubes on the net. The purpose of the server that I am setting up is to get some Cubes on the net. So far the best that I can do is get an HTML of the current view that I have on my screen up. What I need is to get something that can allow a user...

I just set up an experimental Cognos server, so that we can do some web based tests. Yesterday I set up the ODBC connection with our Oracle server, which was troublesome because I was given Oracle 8.1.6 Client, whereas the office used to use SQL*net 2.3 and an Oracle 7.3 driver. Eventually I...

I just set up an experimental Cognos server, so that we can do some web based tests. Yesterday I set up the ODBC connection with our Oracle server, which was troublesome because I was given Oracle 8.1.6 Client, whereas the office used to use SQL*net 2.3 and an Oracle 7.3 driver. Eventually I...

I just set up an experimental Cognos server, so that we can do some web based tests. Yesterday I set up the ODBC connection with our Oracle server, which was troublesome because I was given Oracle 8.1.6 Client, whereas the office used to use SQL*net 2.3 and an Oracle 7.3 driver. Eventually I...

Recently I have been working in an office where part of my job description is to implement a cognos based web server... I just set up the server, and have been loading whatever else is required for it. Yesterday I set up the ODBC connection with our Oracle server, which was troublesome because...