HELP Javascript causing issues

10-26-2004

I copied the code from another HTML script that someone before me had
written. I have no Javascript experience (I'm a VB Programmer/DBA) at
all.

The code below works to a certain extent. There are two things I need
to get rid of though. One, this code keeps the calling window open
(i.e., when you click on the URL, a new IE window opens--which is
fine--but I can't seem to get the code right to close it. This is the
Javascript I have so far:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">

<html>
<head>

<script language = "javascript">

function GetArg()

{

arg = (unescape(location.href)).split("?");
arg = arg[1];

return arg;

}

</script>

<title></title>

</head>

<body bgcolor="#000080">

<p align="center"><font size="5" color="#800000"><b><span
style="background-color: #FFFFFF">Opening
Database</span></b></font>
</p>

</body>

<script language = "javascript">

{

window.navigate("file:///C:/avail.bat");
parent.window.close;

}

</script>

</html>

Avail.bat is simply the following:

cmd /c start msaccess "C:\Jomar Based Availability with WIP.mdb"

If you follow the URL that calls this Javascript, you get a file open
confirmation message, which I would like to override (this URL is only
on an intranet, so it's only going to people I know) or simply stop.

How can I:

1. Close the IE window that calls this Javascript once the Access
database is open (i.e., the batch has run)?

2. Override the confirmation message that pops up?

10-26-2004

In article < >,
enlightened us with...
> The code below works to a certain extent. There are two things I need
> to get rid of though. One, this code keeps the calling window open
> (i.e., when you click on the URL, a new IE window opens--which is
> fine--but I can't seem to get the code right to close it. This is the
> Javascript I have so far:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">

Um, we're up to 4.01 these days, and with no URL, it uses quirks mode. That's
bad. However, it's also very much OT in this group.

>
> <html>
> <head>
>
> <script language = "javascript">
The language attribute is deprecated. Use type.
<script type="text/javascript">

> </head>
>
> <body bgcolor="#000080">
>
> <p align="center"><font size="5" color="#800000"><b><span
> style="background-color: #FFFFFF">Opening
> Database</span></b></font>
> </p>

This is an old page, isn't it?
CSS is your friend. *g*

>
> </body>
>
> <script language = "javascript">
>
> {
>
> window.navigate("file:///C:/avail.bat");

window.navigate?
Is this for IE only? I hope so...because that's all it will work in!! *heh*

> parent.window.close;
um, what's that for?
To close the IE window?
But you can't do that without confirmation. It isn't nice to close people's
windows and javascript is made to be used for the internet. It doesn't know
you're using it for an intranet app. Unless you use an HTA. See below.

>
>
>
> If you follow the URL that calls this Javascript, you get a file open
> confirmation message, which I would like to override (this URL is only
> on an intranet, so it's only going to people I know) or simply stop.
>
> How can I:
>
> 1. Close the IE window that calls this Javascript once the Access
> database is open (i.e., the batch has run)?
>
> 2. Override the confirmation message that pops up?
>

IMO...You're going about this ALL wrong.
You want to have something that your users (who all have windows and MSIE)
can use to open an Access file, then it closes itself with no confirmation?
You want an HTA.

Have a looky-see here. This just opens Excel and closes the HTA window (NOT
the IE window that opened the HTA, just so we're clear).
It can be opened from IE with a url or file->open or it can just be double-
clicked or file->open from windows explorer or whatever.

test.hta:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD>
<TITLE>Run Executable HTA</TITLE>
</HEAD>
<body bgcolor=#565656>
<script language="javascript" type="text/javascript">
var oShell = new ActiveXObject("WScript.Shell");
var prog = "C:\\Program Files\\Microsoft Office\\Office\\Excel.exe";
oShell.run ('"'+prog+'"',1);
window.close();
</script>
</BODY>
</HTML>

--
--
~kaeli~
User: The word computer professionals use when they mean
'idiot'.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

10-26-2004

What is an HTA? This sounds intriguing.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

10-26-2004

"Brent White" <> wrote in message
news:417eb341$0$24917$.. .
> What is an HTA? This sounds intriguing.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Basically, an HTM file with an HTA extension.

Strat by simply renaming any Web page.

Next look up "HTML Application" via Google.

http://msdn.microsoft.com/workshop/a...taoverview.asp

10-27-2004

By the way, thank you for your help. You're talking to a VB programmer,
not a web developer, so, as you probably figured, my experience in HTML
is very limited.

Okay, that HTA sounds pretty neat and the Excel example seems to do
exactly what I need. I don't mind the original window staying open,
because the calling program is a Java program, as long as no EXTRA
windows (which was what I was finding in my example above) stay open.

Unfortunately, I still don't have something quite right. I took your
code and modified it to point to Microsoft Access.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD>
<TITLE>Run Executable hta</title>
</HEAD>
<body bgcolor=#565656>
<script language="javascript" type="text/javascript">
var oShell = new ActiveXObject("WScript.Shell");
var prog = "C:\\Program Files\\Microsoft Office\\Office\\msaccess.exe";
oShell.run ('"'+prog+'"'+'C:\JomarBasedAvailabilityWithWIP.md b',1);
window.close();
</script>
</BODY>
</HTML>

When I open the .hta file, it says it can not find the .mdb file, even
though I checked the spelling, and the permissions are allowing everyone
to access the file.

I'd post this on Google, but it takes a long time to get a response and
I thought Developersdex might be faster.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

10-27-2004

Cancel that. I think I got it straight.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

10-27-2004

In article <417fa24e$0$24902$>,
enlightened us with...
> Cancel that. I think I got it straight.
>

Cool.
(hta = hypertext application, by the way, and they can be standalone as well
as web)

If you wasnt to learn more, see
http://msdn.microsoft.com/workshop/a...taoverview.asp

HTA's are also cool for VB programmers because you don't have to use
javascript. They support VBScript just fine. Since it's IE only anyway, you
can use either language.

HTH

--
--
~kaeli~
Support your local medical examiner: die strangely!
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

10-27-2004

Yeah, we use IE 6 at this office, though I'm really more of a Mozilla
fan.

That's good to know about VBScript. I've never programmed Java in my
life and, though I want to learn, it's a learning process.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wireless network dropped at logoff causing issues with roaming pro	Stephen Liffen	Wireless Networking	3	09-15-2008 02:00 PM
2 Routers in Network, causing issues	Jim G	Wireless Networking	5	12-21-2007 09:36 PM
Issues with Typed Dataset and dropdown lists causing duplicate cal	=?Utf-8?B?TUNVU0E=?=	ASP .Net	0	02-15-2007 12:10 AM
control-c and threads, signals in 2.3 causing all sorts of issues	Srikanth Mandava	Python	1	02-19-2004 12:41 PM
XML-Stylesheet declaration in DTD causing issues	Sarah Haskins	XML	3	01-15-2004 09:37 AM