Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. UWTechie

    How do I use a string as output in a form???? PLEASE HELP!!!!!!!!

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

    How do I use a string as output in a form???? PLEASE HELP!!!!!!!!

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

    How do I use a string as output in a form???? PLEASE HELP!!!!!!!!

    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)...
  4. UWTechie

    Using the string in a Macro as output in an MS Access Form.... HELP!!

    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)...
  5. UWTechie

    How do I use a string as output in a form???? PLEASE HELP!!!!!!!!

    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)...
  6. UWTechie

    FAT32 Fragmentation....URGENT!!!!!!!!!!!!!!!!!!!!!!

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

    Transporting Access SQL code to Excel

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

    Getting the raw SQL from an access query to excel

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

    Getting the raw SQL from an access query to excel

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

    Cognos User Ratings

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

    Getting PowerCubes on the net

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

    I need help... URGENT PROBLEM WITH ODBC TRANDFERS!!!

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

    I am not sure what is causing this ERROR.... URGENT, PLEASE CHECK

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

    Does anybody know what kind of error this is??? URGENT!!!!!!!!!!!!!!!

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

    Best Tool To Build A Cube??

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

    how to connect Oracleto PT

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

    Hi Need Some Information On Cognos (Very Very Urgent)

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

    I need some serious help with Transformer

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

Part and Inventory Search

Back
Top