Search results for query: *

Having improved my usage of the Hyperlinks, I have now hit an unexpected showstopper ! Having already made entries directly into various tables, I have now created Data Access Pages to display the contents of those tables. That all appeared to be working correctly (i.e. all entries in the tables...

I have an existing Access database where one table contains a field with a data type defined as Hyperlink. I have now moved that database to SQL Server (using the stndard conversion facility) which has now given that field the data type of Ntext. When I view that data, the field contents are...

Our environment has recently changed to XP and I am now trying to upgrade an Access system from 97 to 2002. My problem is that originally (under 97) I found that if I limited the form size in Design I would get the same size in Form view; however I now find that when I open it, under 2002, the...

I have described in previous threads how I have built a 'mechanism' whereby I am able to extract details from the Object Definition created by the Documentor facility. In particular, under Access 97, I was able to store the online output as the table 'Object Definition' and then use Queries to...

Having built a new system with a variety of forms, I have been presented with a particular user request and I am unsure how best to solve it. This area of functionality involves the user supply certain information which will be turned into SQL instructions. these include the use of the terms...

Being a firm believer in the use of metadata, I try to ensure that all table columns in my Access databases are provided with suitable descriptions. I have now written suitable queries to extract relevant detail from the 'Object Definition' table (created when I 'save the table' after I have...

I have a Form with 2 pulldown lists. I wish to limit the output from the 2nd list, dependant upon the selection made from the 1st list (there is a one-to-many dependence between the 1st data item and the 2nd data item, where both items are present within the single table from which the form has...

From time to time I have 'imported' a new table, based upon the contents of an existing table but using a query to modify that data (all in the one Access database). I use the Options in the Import Objects subscreen, setting 'Import Queries' to 'As Tables' - driving the whole process manually. I...

I have created a number of different (simple) merge instructions without problem but I now have hit a difficulty which is affecting several others. To isolate the problem I have simplified one of those but still have the same error condition (i.e. ERROR at line 7: ORA-00904...

-* Edit Tool -* Created by Report Assistant -* FF Line do not change this line! Field Name -* FF Line do not change this line! Alias -* FF Line do not change this line! Format -* FF Line do not change this line! Segment DYNAM ALLOC FILE TRANSFER DA WINFO.EUCWPD.WXXF008 SHR REUSE SET HOLDATTR=OFF...

Resulting from a business decision, I am now looking at the feasibility of moving our current mainframe based data (i.e. flat files and FOCUS databases) into an Oracle database. Then new reports will be developed, using the Cognos products, to replace those currently being generated. Has anyone...

This week I have had considerable problems generating the various data cubes when running Powerplay Transformer - I was encountering error code TR1901 ("The PowerCube can't be opened"). It subsequently transpired that the .mdc file had a lock set on it (i.e. it appeared that it was being shared...

We have a data warehouse system which uses the Cognos tools with an Oracle database. We also have WebFOCUS which is being used to process data held on our mainframe. Before we consider purchasing the relevant WebFOCUS driver, I want to see an example of an MFD created from the Oracle catalog...

I am trying to run a new report using a macro (based upon one that is in regular use) and I get the above message when I run it. The offending instruction would appear to be :- Set impReport= impApp.OpenReport( "e:\CognosReports\Live\Reports Imp\W004i - Market Goodwill Spending Analysis.imr" ...

I am responsible for the batch running of a number of Impromptu reports created by an external company. Following the creation of each report, a Snapshot is taken of the output and a PDF file is also created. As the size of the database has increased, I am now finding that it is impossible to...

I am interested to know what sort of IT staffing set-up companies have created to cope with their data warehouse requirements. We run a data warehouse system developed by our parent company (utilising Oracle and Cognos) - currently this is limited to two business modules/areas but we are...

We have a requirement for a particular Impromptu report whereby the number of columns of information is variable. These columns hold values relevant to a Service Type. Currently there are 11 Service Types but the number could well increase over time (in fact we already know that another one is...

As someone who has just started writing modules in VB, I would like to see an example of code which will read the existing contents of a table and then modify certain values in one of the fields (i.e. the table has to be used in update mode). HELP Has anyone got a sample they can provide (would...

We have a short term requirement (e.g. next 6 months) to periodically move some data held in an Access database into an Oracle database. Although other solutions may well be available (e.g. ODBC links, etc.), my intention was to generate the appropriate SQL code (to embrace the required data)...

We run a data warehouse system supplied by our parent company (based upon the Oracle and Cognos products). Due to local business needs, it is necessary to extend the content of the database, i.e. add a number of additional tables containing 'local' business information. Because the information...