Recent content by notageek7

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

Thanks fumei for responding. I appologize if my post was not clear, I'm not using word. The tool was built in Access using VBA. The html has been hardcoded in a module using VBA. So the problem is now that a user wants to be able to edit an e-mail when desired, where before it was just a batch...

Please help if you have ideas on where to look. I've done some looking around in the FAQ and existing threads but not finding any definate solutions. Not sure if maco's are a possible solution. Thanks in advance, any help is greatly appreciated!!!

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

thanks for your help again fredericofonseca but i'm getting an error...."can't assign to read only property" for the line that is trying to define the type qdf.type=dbQSQLPassThrough

got pass through query to work in code but now trying to get the same query to work as originally attempted...as per my first comments above.... this code creates the error below: Dim dbs As Database Dim qdf As QueryDef Set dbs = CurrentDb Set qdf = dbs.CreateQueryDef("NewQuery", _...

fredericofonseca thank you for your time....I got it to work by using: DoCmd.SetWarnings False DoCmd.OpenQuery "qrypassthroughTEST" DoCmd.SetWarnings True

Yes fredericofonseca the privileges are okay. This application has been an ongoing project over the last several years, I have been working with it for six months now. It was originally all access/vba now it has an oracle 9i backend. So needless to say there have been many issues that needed to...

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

lasd, there are several ways to accomplish this. One is to do the calculations within a module using sql statements. For example use a SELECT sql statement to retrieve the first two columns, then perform the calculation inside a subroutine, and then use an UPDATE sql statement to add the value...