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

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

ahhh, figured it out!!! In case this helps anyone. I've got a access db with linked tables to an oracle db. Because of this some fieldnames had to be changed because they were oracle reserved words. What I needed to do to fix the problem was go to the properties of the problem combo boxes and...

Found this article on the microsoft knowledge base but it didn't fully answer my question. http://support.microsoft.com/default.aspx?scid=kb;en-us;209485

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

looks like there has been a lot of dialogue about this question since I've been gone. Not sure I've got a clear answer though. Thank you for contributing to this thread.

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?