Search results

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

HI Folks, How possible is it to use VBA to create a report from top to bottom? I don't want to deal with wizards or "drag and drop". I want to create the report entirely from VBA. Any ideas? Anyone have an app that shows me how to do this? Thanks, Jason

Hi Folks, I have a table that has Student_ID, Course, and Grade. So each student has multiple records, one for each course they took. But what I want to return is only those people who have All F's. If I just put "F" as a criteria on the grade field then it will pump out those records that...

I don't want to sound like an idiot, but i'm not too able to follow that code, where are you assigning the information to xlstore? Maybe I need an sample app with minimal capabilities to better guide me on my quest.

Hi Folks, I want to export a query that I have to an excel document. That is the easy part though. My client also wants it exported to where each particular buildings schedule is on it's own worksheet within the 1 workbook. Example Of what I'm working with is below Select tblCalendar.date...

Hi Yall, I want to be able to have my users press a button and have it relink the linked tables to a specified mde (which has the same table names...just new information) (I want to specify the path to the .mde in the code). Any ideas? Code is helpful! :-) Thanks!