Search results for query: *

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

I have a text box with an EXIT event that will check for null value. If null, a message to user is displayed and the focus is set to the text box. Well, that's not what it is doing. It displays message but it goes to next control... See code below: If Isnull(Me!DOB) Then MsgBox...

Would like to get references to the best DTS manuals. I have a couple from this forum's FAQs but am interested in additional ones. Thanks.

I need to identify all DLL references made from the MSCOMCTL.OCX. Is it possible to get code? If yes, where? If not, what can I do to accomplish what I need? Thanks for your time.

1. What is the maximum number of layouts allowed in one report? 2. I need to have 7 layouts on same report containing different data from same table. Would it be more efficient to generate one query or multiple queries? Thanks in advance for your help.

Try API calls WAITFORSINGLEOBJECT and GETEXITCODEPROCESS...