Search results for query: *

I'm using an access database with linked tables to oracle, this application has been in production for over 6 months. Have started to have a problem recently when attempting to open a connection (rst.open ...). I'm able to view the data in the linked tables but when trying to open a recordset in...

I'm using an access database with linked tables to oracle. Have started to have a problem recently when attempting to connect to the oracle database to do a select or even to open a connection. I'm able to view the data in the linked tables but when trying to connect via VBA code the connection...

I've got a commissions calculation system that has an option that allows users to send out emails. In the system vba code generates html code that is used as emails to be sent out by the system. My new challenge is to allow users to edit the html code, but the approaches I'm trying cause the...

If anybody has any ideas I'd sure appreciate some help. I'm including code that is in form1 and the code for the stored procedures/package/table. This code is from microsofts site. The error I'm getting is: run-time error'-21564645(1654e65)': ORA-06550:line 1, column 28: PLS-00201:identifer...

I'm totally stumped....when trying to call my oracle stored procedure within my vba code, example below. I've gotten this code example below and not having any luck with it. Does anybode see any problems???? In general I'm not finding much info out there regarding oracle stored procedures and...

I'm having problems with using the truncate command in a pass through query in access, it dosn't seem to like it. I've got a pass through query that sends the truncate command to delete values from an oracle database. Here is some of the code. Anybody done anything like this before? Thanks for...

Does anybody know if there is a way to import data from an excel file into a table that is linked to an oracle db. My code imported the file into an access db previously and now the table to import into is a linked table to an oracle db. So the problem is that oracle dosn't have autonumbers so...

I'm trying to find out if I can have a field, AdjustmentType which is in a table called Opportunities, as part of a primary key and also a foreign key. For example: Opp_ID VARCHAR2 (255), AdjustmentType NUMBER, CONSTRAINT OPPORTUNITIES_PK PRIMARY KEY(Opp_ID, AdjustmentType)...

Could someone help me with this newbie question? I've got a combo box on a form and the combobox is full of the right data in its drop down list. But, #Name? is visible prior to clicking on the drop down list and I'm not sure why. Also, I can't select any of the values that I can see in the drop...

I've got a form that has vertical scroll bars because it is quite long. Is there a way to allow my users to use their mouse wheel to scroll down my form?

I'm wondering how to find with a sql statement the max count for a table, in other words what the next autonumber would be.

Can I get all my db's tablenames from a module, if so how do I do it? I've looked through FAQ's and and searched other forums and only found something about sysobj and metadata but it wasn't a clear solution that I could understand. Can somebody help please? Thanks in advance.

Does anybody see the error in the following sql statement? Some of the lines below have been moved to the line below because of the width limit of this text input. 'Add Quota sqlString = "INSERT INTO Quota ( Quota_Key, Comp_Plan_Key, Category, " & _ "QuotaPeriod, TargetPeriod...

I've got an array of strings which have numerous instances of the same strings, and would like to find the top 3 strings and their associated count. I'm sure this has been done before so if you know of a quick and efficient way of accomplishing this I'd be very grateful. Thanks in advance for...

I've got a listbox that requeries after a user chooses a value from a combo box. In my sql statement I'm using LIKE in my WHERE clause because the records have a field with multiple values so I'm needing to search for a string within the field like 'CP'. My question is can I use a variable in...

I've got a combo box change event that requeries a listbox. My problem is the sql statement works fine to display all records that match the combo box value when the records field is a single value (like that in the combo box). My problem is I've inherited a database that has records with fields...

I've looked through the other forums and FAQ with their suggestions not working....I'm not sure why. I've got a combo box that was filled by ..AddItem from an array. I need to empty, all the values, when a value from another combo box is chosen. I've tried the techniques below with only the...

Could someone with experience with using vba and oracle PLEASE HELP. I keep getting numerous errors when trying to open a connection to my oracle db from within a vba module. I'm including part of a function below that accesses an oracle db to retrieve the next value, because no autonumber...

I've got a project that pulls out tables, fields, indexed fields, and primary keys from a chosen database. I've got most working but am having some problems with my primary keys. I'm not sure how to access my primary key. One example is in my table CheckRequest the primary key is CheckReqKey. In...

Is it possible to get and use TableDefs from a database other than the CurrentDB. My application accepts a database name from the user and displays info about that database...tables and associated fields, indexed, primary keys, etc. Is there a way to use TableDefs where db is referencing a table...