Recent content by appealdenied

I am trying to write a couple of vba procedures that do the following: 1) Procedure 1 in Workbook 1 creates Workbook 2 2) Procedure 1 then Calls on Procedure 2 (also in Workbook 1). I am trying to pass through all variables. However, I'm having trouble passing a few of them. 3) Procedure 2...

Well, as I found out, ODBC does not support inline views. That is why the query didn't work. I did manage to get a hold of TOAD to continue working on the problem. All the query needed was an alias for the date_acquired column in the inline view. The query as it stands now looks like this...

the AND clause should read a.counterparty_name = b.counterparty_name Not that it changes anything. "Life is like a purple antelope walking through a sea of dead tuna."

Well...at initial inspection it might do exactly what I want. However, I am (restricted to) using MS Query and Excel 2000 for reporting. I get the same result when using either of the Microsoft Oracle ODBC and Oracle ODBC (8.1.7) Drivers Just to make sure that the query is correct, here it...

While that was a very good answer, I need to change the scenario slightly. So how would I build this query if I needed to grab the company name, earliest date and the task assigned with the most recent date? When I try adding an AND clause to the main query it greatly restricts the number of...

(Of course DATE is reserved, this is in pseudocode ;) ) Excellent answer! I don't think I ever recall being able to pass multiple parameters to IN subqueries. That piece of code made the difference. Thank you. :) "Life is like a purple antelope walking through a sea of dead tuna."

I have a table with a list of companies. Each company has multiple task names associated with it and dates at which time the task was completed. I am trying to write a query that will provide the name of the company and the task name for the most recent date posted. The data below should...

What settings with in that need to be changed? All this is is a simple HTML page. No scripting or anything. I don't see why it would be locked down. "Life is like a purple antelope walking through a sea of dead tuna."

In Tools > Internet Options > Address field, I have: http://mymachine/mypage.htm "Life is like a purple antelope walking through a sea of dead tuna."

I sure can. I have no problems browsing to it normally through IE explorer. Its only when I use it as a web page that it doesnt show. I have something similar on my Windows 2000 machine but all I did with that one is drop the file in and turn on PWS. Everything worked there. Either there is...

I wrote my own HTML start page and stuck it in the wwwroot folder. IIS is turned on and my default home page is set to that file. However, I get a 404 error when I try to open it. I am running XP SP2 (with Windows Firewall off) and McAfee Security Suite Version 7. Does anyone have any ideas...

I have written a script that essentially creates a machine name and then uses NETDOM.exe to create a machine account and then join the machine to the domain. The script runs using the RunOnce setting in the registry after the Windows Security Dialog has been compromised (I wrote another script...

Okay, here's a crazy scenario: I have written a VB/WSH script that breaks down the Windows Security logon. It Disables CAD and automatically logs on a user. However, I am wanting this script to execute as the machine is booting up AND before the Welcome to Windows screen appears. Is such a...

Actually, I consulted with a programmer and was told that I would have to get the file signed using some sort of certifying authority (Verisign, etc.). By this time it was more than I was willing to do for that script set. The actual solution I used was to write a VB script at startup using...

I have run the Syspre setup application more than once and seen a list appear at the bottom of the .inf file. Could this be used as a list? If not, what's it there for? "Life is like a purple antelope walking through a sea of dead tuna."