Search results for query: *

Sounds okay, but is there any way to do it without cutting and pasting?

This is to have a way doing some documentation.;.. Basically, it all has to do with when someone makes a link from Excel to a query, and that link is then broken... What we want is to be able to bring all the SQL code to the spreadsheet, so that we can duplicate it if the .mdb disappears...

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...

Where do I use this from? I am pretty new with Excel and I know very little (as in next to nothing) about VBA... I was looking through the online help books, but there was nothing about this kind of stuff there... Could you please be a bit more explicit in what I need to do? Thank you very much

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...

We get the information for Transformer using cem files that are packages that we made with cognos Architect. To build levels and categories, go into Transformer and then choose what you want for each dimension, then inside the dimensions u can choose the levels that are required...

Well, I think that before you connect to Transformer, you have to make some sort of package for it. Thus do something along the lines of connecting through through architect, or you can make a catalog in Impromptu, then make an iqd...

Hi, Well we are using Cognos Architect to build the required packages for Transformer. While just creating a cube in Transformer is simple, it is quite difficult to specify exactly what you want it to show, and the documentation that Cognos has is deplorable. Personally, I think that you need...

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...