Search results

Thanks for this, I been having this problem on invoices for months and never been able to correct it even with complex formulas.:cool:

That would be the easiest way as the later versions of Access can read a 97 database. I have had to do this with 97 & 2000 and found it works OK.:rolleyes:

I cannot do this as when trying to connect through ODBC Databases it comes up with the error. I have found out that 1 app uses a different type of Oracle Runtime to all our other apps. The only option that I can see is to get our 'Unusual' app supplier to try and use the same runtime as...

I don't think so as it is falling over when the system asks for the User ID & Password. I have been told that there is a conflict between the 2 applications and they both use ODBC.:(

I have had a look at these but they are not what I require. If a user scrolls through the records, I want the combo box to show the current record.

I am trying to open a form in Acc2000 that has a field connected to an Oracle Table. I think the problem is to do with the ODBC Drivers. I am currently using Oracle73 Ver2.5 ODBC Drivers. The error message is 'Reserved Error (-7709); there is no message for this error' Please help as the...

If you are using an input mask, than this should be OK. Is the input mask like this 00/00/0000;0;_ The 0 means that a number is required.

Was the form OK for you.

I've forgotten how to sychronise a combo box to display the same record as the main form when scrolling through the records. Does anyone know how to do this.

It's on it's way.

I have created a search screen before. I will send it to you.

You could try setting the correct field as the default field usin the On Open property. This will have to be written in VBA Code. DoCmd.GoToControl "<Field Name>"

Try creating a seperate search screen and then using the search criteria in a Query.

I am using a Passthrough query in Access 97 and converted it to Access 2000. I keep getting the error "Invalid Precision for Decimal Data Type". I have found that it is to do with the number fields on the Oracle Tables. How can I correct this.