Recent content by jawilli1

Thanks for all of the replies! I haven't seen anything specific about the ODBC use in the 11g client having issues like this, both on the general net and on the oracle forums. I think you are right, though, in that something is different. As a side note, I broke down and decided to (for the...

The version is 11gR2

Thanks for the response! No, nothing else has changed. The only change is the drivers. I've tried various versions of the 11g driver and they all give the same response.

Hi Everyone - I have an access database that has linked tables in an Oracle Database. When the user logs into the access app it does a connection to oracle using their username to determine fine grain access privileges. When I had this database using an old Oracle 9i ODBC client it worked fine...

Greetings - I have oracle vpd controlling what is returned and processed from the front access app. The SELECT, UPDATE, and DELETE vpd works without too much issue in access. The problem is with INSERT vpd. It does stop the insert but also then causes access to loose ODBC connection with an end...

Greetings - I have a oracle database that I've inherited that has error handling internal to the database triggers (pre-insert triggers). They issue errors with a raise_application_error(-20001, 'This is an error'); This is all fine and good except that it produces an error in Access that...

Hi folks, I have a query that returns about 3500 records (and runs very well I have to say). the issue comes when I attempt to export that queries results to a comma seperated text file. It gives me the message that the field is too small to accept the amount of data..bla bla bla... I've...

Through alot of testing and screwing up, it appears as if I got it working correctly. I don't think i was cleaning up my strings and such correctly. Below is my final product. One function creates the output, and the other function takes care of escape characters that may need to be put into...

This is my new code: Public Function fExportData22() DoCmd.SetWarnings False Dim strSQL, strSQL1, StrCnt As String Dim rs, rs1 As DAO.Recordset strSQL = "SELECT PeopleGraduating.Graduation_Date, PeopleGraduating.FullName, PeopleGraduating.City, PeopleGraduating.Degree...

any code ideas?

I did something simular to this with VB Script...maybe you can port this over to VBA Sub MapNetworDrive Dim objNetwork Dim strDriveLetter Dim strRemotePath Dim strUserName Dim strPassWord strDriveLetter = "G:" strRemotePath = "\\server\share" Set objNetwork =...

Here is an example of what we used last year (and how they want it this year...last year they did all of this manually...ug) BACHELOR OF ARTS American Studies/Communication Studies: Shauna Lynn White, DeSoto, Texas; John Paul Jones, Daytona, Ohio. American Studies/Sociology: Michael Charles...

It is another degree group and what you displayed I can do and have already done, but they want it to display the name information like this. DEGREE Major: name, city, state; name, city, state; name, city, state; etc... DEGREE Major: name, city, state; name, city, state; etc.... They...

I can group it just fine, the issue I run into is the formatting they want it in. They want it formatted with the names listed as such by major. name, city, state; name, city, state; name, city, state; etc.... Like I had said in my origional post I can pull this information where everythign is...

Hi Folks, I've got a tough one here that I've been trying to work though every which way I can think of. I know i'm getting closer, because the concept is making more sense now, but I don't think I got the code correct. I'm trying to take in everyone who is set to graduate in one of our...