Search results for query: *

Hi, We use and Oracle client-server application based on Oracle forms 6i with a 10g database. The application is starting to have a lot of problems. First, in one form the user must enter a number, then press enter to execute a trigger that will bring up a new form. This function has stopped...

Hi, After running a report in MS access and then clicking the button icon to export it into Excel, I get an error that says, "The format in which you are attempting to output the current object is not available....the formats that enable you to output the data as MS Excel are missing from the...

I was able to scroll through records in a MS Access form, using the buttons down at the bottom of the form. I then added a new field to the form and can no longer do this. When I try to move to the next record after populating this new field, it gives my a "Calculating..." message and stalls

I was able to scroll through records in a MS Access form, using the buttons down at the bottom of the form. I then added a new field to the form and can no longer do this. When I try to move to the next record after populating this new field, it gives my a "Calculating..." message and stalls

I am developing an Oracle form and would like to display an item so that it is equal to a the value in a database field plus 100. Also, when the user enters a value in this field, I would like to subtract 100 before storing it in the database. For example: select colvalue +100 from x going into...

I have an Excel table and would like to convert it to an Access table and from that to an Oracle table. In Excel, I don't have the button that says "Convert to Access". So, I do an OPEN WITH and I select Access. All columns, except one - the last name column-- get converted. Could you tell me...

Hi, I have an Access front-end that connects to a backend that includes linked Oracle tables. The problem is that whenever I click on a function that uses one of the Oracle tables, I am promted for the Oracle login. It seems as if there is a way to store this userid and password information...

I am creating quarterly report using SQL Reporting Services and I am trying to display the start date of the previous quarter in a text box using the following expression: =DATEADD(qq, DATEDIFF(qq,0,getdate())-1, 0), 100). However, I get an error. When I use this expression in a SQL server...

Hi, I am creating a Crystal report that is based on a query that groups two types of individuals by region and quarter (group by region, quarter clause). I can easily create the report with my query: the columns of individual type A and individual type are displayed grouped by region then...

Hi, I have a MS Access application that runs a query that selects fields from a table linked to an Oracle database table. When I click the form button that runs the query I am prompted for the Oracle username/password. How can I code for this do it does not prompt me?

For a range, say H1:H35, I would like to use a COUNTIF function. However, the last row is determined within the application, so is not known in advance. How do I put this type of range in a COUNTIF function, i.e. when the range is H1 to H, LastRow+1.

I have an Excel app that populates some cells using Microsoft query to get data from an Oracle database. The problem is that when I run the macro that uses the query, I am always prompted for the Oracle database userid and password. How do I code that in the application so I am not asked for...

I have an Excel app that populates some cells using Microsoft query to get data from an Oracle database. The problem is that when I run the macro that uses the query, I am always prompted for the Oracle database userid and password. How do I code that in the application so I am not asked for...

I create a complex query in Microsoft Query within Excel and get the message "SQL Query can’t be represented graphically" I think this means that I can't add a parameter criteria to the query (I need the user to select the year). Is there any way around this?

I use the following SQL statement in an Access query: SELECT tblWWS_sch.* FROM tblWWS_sch WHERE (((tblWWS_sch.Archive)=0)); This work fine in one copy of the database with 13576 records. In another copy of the database with 14000+ reocrds, the query no longer works unless I omit the where...

I am trying to create an Excel file from a macro in MS OUTLOOK using basically the following code: Dim objXL As Object Dim objWB As Object Dim sXLSFile As String 'Create excel object Set objXL = CreateObject("Excel.Application") 'Open existing workbook sXLSFile =...