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

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

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

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

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

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

I have a query that is made up of 3 tables. One of these tables has a compound key of 3 fields, two of which are linked to the primary key in the other two tables. It is a select query, yet whenever I run it, I get a message telling me that it cannot lock one of the tables because another user...

I am trying to setup remote access on a Merlin Legend 3.0 system. I have very limited understanding of how these systems work, but from the users manual I am gathering that I need to assign a number that people will dial to access the system remotely. According to the manual this is setup...