Recent content by OraMs

Yes. Both of them...

In attempting to open an ODBC connection from Access 97 to Oracle databases, I get the above error. This occurs during an OPENCONNECTION and an OPENDATABASE. Below is the code I'm using: Function AddRows() ' Declare Variables Dim wrkODBC As Workspace Dim dbConn1 As Connection...

In attempting to open an ODBC connection from Access 97 to Oracle databases, I get the above error. This occurs during an OPENCONNECTION and an OPENDATABASE. Below is the code I'm using: Function AddRows() ' Declare Variables Dim wrkODBC As Workspace Dim dbConn1 As Connection...

In attempting to open an ODBC connection from Access 97 to Oracle databases, I get the above error. This occurs during an OPENCONNECTION and an OPENDATABASE. Below is the code I'm using: Function AddRows() ' Declare Variables Dim wrkODBC As Workspace Dim dbConn1 As Connection...

While attempting to register a SQL server using Enterprise Manager, I get the following error: A connection could not be established to LLSQL - Specified SQL server not found. ConnectionOpen (CreateFile()).. Please verify SQL Server is running and check your SQL Server registration properties...

Mike, please disregard previous message. I got it. Thanks.

Thanks Mike. Now, what if I only want certain columns from the TOP 25 rows?

In ORACLE, you can use ROWNUM to select only a given number of rows. Is there something like this is Access? What is it? Thanks in advance.

When I trigger a report from a form, REPORTS SERVER form opens and remains opened even after I've exited the report and the form. Is this normal behaviour? How do I force the form to close? Thanks

We have an Access application that we would like multiple developers to work on while maintaining source control such as SourceSafe. Here are my questions: is this possible with Access? if so, how? NOTE: We do not want to "split" the database and then import/export new or...

Hi Steve, Thanks for your suggestion. There is no other code because I removed the macro and I did not get any errors. I solved by capturing the err.number where I'm calling the report. If not zero, display message, close report, exit. Again, thanks.

I have a macro that triggeres from a report's On No Data event. The only action on the macro is a msgbox advising user that "No data was found." My problem is that the message is being displayed twice in consecutive order. Any thoughts?

I have two identical forms, developed using Access97, that display existing data and allow user modifications. The only difference between these two forms is the record source. Every property on every control on both forms is identical. Every event within their respective class module is also...

Yes, I know an object cannot be a constant. However, I need some way of having a "constant" form. Here's my scenerio. I call a function from multiple controls and I pass the form and the control name. The function is declared as follows: Function CtrlNavigation(frmName As Form...

Hi Terry, Thanks a lot. It works perfect..