Search results for query: *

Hey all, I have an application that is running on a server using a Citrix solution to distribute to users. The app is a VB application that runs the engine for a data transformation program called Business Integrator. It has a function in it that is activated by a button push, which allows...

One more thing to mention...I believe there are some system dll files that are being accessed in the code that might have something to do with the permission issue. The only strange thing is that if I set the project to a standard EXE it will compile and run (Though incorrectly) without a...

I am getting a "permission denied" error when I attempt to run an activeX exe project. The program runs when I am logged in as a power user, but when I am logged in as a regular user, the program does not work. My first thought was that some permissions weren't set right on the folders, but we...

Hey all, I'm trying to get the name of my default printer so I can save it into a string variable to use later. I am basically switching back and forth between Adobe PDF and my customer printer, and I don't want to hardcode the name of the printer because I want this to work for people that...

That's the problem, my database is Access 2000. Do you know how to do it in 2000? Erich

Thanks for the response PHV. Unfortunately I'm still getting a "method or data member not found" error. Do you know if I need to set a reference to use this? Erich

I'm using an access database where I would like to use this same concept (Applications.ActivePrinter), but I don't think I have the proper references set to use this. Does anyone know what reference is necessary to retrieve the name of the default system printer in Access VBA? Thanks, Erich

Hi all, Does anyone know if it is possible to set the OnDeactivate event property of a report inside VB code? I am trying to set a report's OnDeactivate event to close the report, but only in certain cases. Any Ideas? Erich

I am getting ORA-00904 Error when running the below expression : DECODE(CEXRPTSUMMARYDETAIL,0,False,True) AS ExceptionSummary Does anyone know what the correct identifier is for a boolean expression like this? Erich

I figured out what my problem was. Basically, the Oracle tables are named "METASTORM.GI_TRACKER_V3" and "EWORK.EFOLDER" but Access cannot represent the periods in its table viewer. Because we have these tables linked to the Access database, they appear as "METASTORM_GI_TRACKER_V3", as a result...

I think part of the confusion with this is that I am working in Microsoft Access, attempting to write a passthrough query in Oracle SQL WITHOUT having access to the oracle server through any other querying application. This means that I cannot use SQL *Plus to use the Describe function. What...

The version of Oracle that our database is on is 9i.

I understand your reaction to my naming convention, but according to some information I found online, Oracle SQL uses periods (.) to represent underscores (_). Have you heard this? It doesn't seem to like the "DESCRIBE" command. I have to be honest that I am not sure what version of Oracle...

Thanks for making it look nicer. By the way, how do you get it inside that code box? Yeah, I've tried it without the semicolon. I am writing the pass-through query in Access. The database that it is accessing is an Oracle database, which requires that I use Oracle SQL as opposed to Jet SQL...

Ok, I am getting the ORA-00933 error. "SQL command not properly ended (#933)" I believe you are probably right about the join. This query does require a join, however, when I previously had the join in there, it was giving me the same error. Does this look right: SELECT...

Hello, I am writing a pass-through query for an Oracle database and am having trouble with some simple SQL. Even after all of the research I have done, I am clueless as to why I am getting this error. Below is the code. Does anyone know what's going on? SELECT EWORK.EFOLDER.EFOLDERNAME...

That is going to help, I think. Thanks!

I am writing code that pulls from an external Oracle database. In order to use the code, I am trying to setup the connection to the oracle database using ADODB connection. Does anyone know what the provider would be for an oracle database? The statement I am wanting to fill is: dbConn.Open...

Jerry, you are right, I do need to take the "LIKE" out... but this doesn't seem to be speeding it up much. Crowley, that might be an option. I will look into it. Thanks both of you!

We have an access database frontend for reporting purposes that is pulling from an oracle backend. I am trying to speed up the reporting time. Currently, we have a query that looks like this: SELECT CDate(DateForDayInGivenWeek(1,Format$(IIf(IsDate([EEVENTTIME])...