Search results for query: *

Hi, Currently we are upgrading our Oracle Forms 6i application from client/server model to web model. We use Oracle Reports that can output in a varity of formats. My (internal custom) requires to output a particular report in Excel (not one of the formats supported by 6i). Previously they...

I am trying to write code to alter an MS-Access database when I close a task item in Outlook 2003. I first tried to write some basic code to test the taskitem close event before doing anything more complicated involving Ms-Access. Unfortunately the help files only have an example for the close...

In the atempt to build a dynamic sql string I have run into an interesting yet annoying problem. When I append to the end of a string the concatenation symbol '||' (double pipe) PL/SQL throws an error. A single pipe is ok. Append two single pipes also throws an error. So does the use of CHR(124)...

Is there a way to access from pl/sql, in a in-built report tigger, the report object, as displayed in the object navigator, to read off the properties of selected object without already knowing what those objects are called? (Particularly the user parameters.) What I am wanting to do is write...

I use MS-Access to run various queries for various reports where some of the data is stored on an AS400. I currently make use of the Client Access ODBC driver to get access to the data. As to be expected I am often asked to authenicate my access to the AS400 libraies when I run these queries...

Version: Access 2000 Platform: NT4 I have a form that has a subform on it that shows a table in datasheet view. (Please note that the source object is a table not another form) If I manually re-order the table via the right-click option menu and then close the form, even though I use the...

How can I get the full path of the access database that I am running? The aim of getting this path is to create dynamic linking with a table in another access database that exists in the same directory but the database is stored in different locations on different workstations. CurDir() doesn't...

I have a combo box which contains a list of numbers (1 to 4). On selecting a smaller number I get the Beforeupdate event to count the records in a particular table with a number greater than the new selected number as these records are the ones going to be deleted in the AfterUpdate event. It...

Is there a way to access the text in the internet header of an email message as shown in the View -> Options dialog? Once obtained, is there an easy way to extract particular fields from the header and display them in user-defined fields and hence displayable in the message list pane? I'm...

My office has both Access 97 and Access 2000. The Database in question was developed in 97 and works fine on systems using Access 2000. I have writen a import process to import Excel 97 files that comes from an external company. The import code line is as follows: DoCmd.TransferSpreadsheet...

I can use environ("variable") to read the values from the MS-Dos enviroment variables. The important question is there a way to write to the environment? (ie a "SET" equivalent) Paul Cooper

I am using CreateTableDef method of CurrentDb to dynamically link a chosen table in a set of remote mdb databases. (There is one table in each of databases) This appears to work except the linked table appears to linked exclusively. When someone else using their own copy of my database links to...

Can you, and if you can, how do you write new aggregate functions? If you can there are the following functions that I wish to write: Concat([field], delimiter_string) Mode([field]) Median([field]) Paul Cooper

I am using the following SQL Query: INSERT INTO xx_catchment ( PC1, PC2, PC3, PC4, street, [first odd], [last odd], [first even], [last even] ) SELECT [Catchment List].PCA, [Catchment List].PCB, [Catchment List].PCC, [Catchment List].PCD, customer_potential.add1...

I am using the following SQL Query: INSERT INTO xx_catchment ( PC1, PC2, PC3, PC4, street, [first odd], [last odd], [first even], [last even] ) SELECT [Catchment List].PCA, [Catchment List].PCB, [Catchment List].PCC, [Catchment List].PCD, customer_potential.add1...

A problem I am finding with using UK date formats is with text boxes that are used for date entry. I am using Win NT 4 and the date formats in regional setting are correct for UK ie dd/mm/yyyy. When I put in an unambiguous date into the control eg 13/04/2001 this gets entered correctly into the...