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

I guess that would be SP2

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

Thank you. It seems to have worked. I had code in both the BeforeUpdate and AfterUpdate procedures. I put it in only the BeforeUpdate procedure and it works. Thanks

Yes, I did add a new field that is associated with a Form_AfterUpdate procedure. I use this to show the last time the record was updated.

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

Ok, I got the provider right, but am still being prompted for the userid and password. Can you tell me why?

Thanks. When I try the first, I get an error message "Provider not found -- may not be properly installed..." Can you help? I am using a Microsoft ODBC for Oracle driver.

Hi, Thanks, but I did not find the "corresponding TableDef.Connect property".

Thanks, but the Mircosoft ODBC for Oracle doesn't let me store the password. And, I didn't see the remember password box. None of my other databases user code for this connection, so I think there has to be a simpler way.

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

I'm sorry. I just don't see it. I am looking under the 'System DSN' tab.

Thanks, but I don't see where I can enter a password there; I can only enter the user name.

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?

Yes. Actually the VBA program is in Outlook and is manipulating an Excel file. Should I try something else in place of the word Application?