<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>Pure
VB codes almost exactly the same as VBA. The syntax is identical, there
are just a few minor changes in functions (such as AddressOf is a default
ability in VB, and Eval is only available in VBA).</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>As far
as the NT Service OCX, let me explain....</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>A
service is something that runs on your machine whether you are logged onto it or
not. (Once Windows has loaded it's device driver's, etc., then it starts
the services). In 9x, services are just a registry entry
(HKLM\Software\Microsoft\Windows\CurrentVersion\RunService) (That may be
RunAsService...don't remember, and it's not on NT machines, which is what I am
using now...) Any program can be placed there in the registry, and it is
run by windows as soon as it comes up....regardless of whether a desktop is
loaded or not.</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>Now,
an NT service is similar, however, it's not a normal registry entry.
Services is part of the Administrative control panel. (Control Panel
--> Administrative Tools). That lists every service running on your
machine. From that panel, you can start and stop services, you can set
whether they can interact with the desktop, or what NT account is used to run
the service as. Pretty flexible. However, to 'build' an NT service,
requires callback capability, since the system has to 'holler' at the service to
start or stop, etc. The NT service OCX (ActiveX control) provides that
callback capability to VB.</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Software Design &
Solutions Pty Ltd. [mailto:SDSSoftware@Optusnet.com.au]<BR><B>Sent:</B>
Friday, May 09, 2003 3:46 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Scheduling an
mdb to run using AT<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Hi drew - this is an mdb - the
basic process it performs is to log on to an external system, read in some
data, manipulate that data and export it out to an external txt
file.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I have done it in vba only because
I do not know pure vb (and don't own it). There's no requirement to change it
as it does the job - just need it automated. They are running Windows NT. You
lost me on the NT service OCX. What is that?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Rgds</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=DWUTKA@marlow.com href="mailto:DWUTKA@marlow.com">Drew Wutka</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=AccessD@databaseadvisors.com
href="mailto:'AccessD@databaseadvisors.com '">'AccessD@databaseadvisors.com
'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 09, 2003 5:25
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Scheduling an
mdb to run using AT</DIV>
<DIV><BR></DIV>What are you trying to run. Is it just a data routine,
or is it running<BR>reports? If it's just a data routine, I personally
recommend using the NT<BR>service OCX, which allows a VB .exe to run as an
NT service. Much easier to<BR>deal with, shows up in the list of
services, the ocx has an easy method to<BR>dump information in the event
viewer, etc.<BR><BR>Running reports can be done this way too, but it needs
to use Automation. <BR><BR>>From what I understand, VB.Net has the
NT Service capability built in.<BR><BR>Drew<BR><BR>-----Original
Message-----<BR>From: Software Design & Solutions Pty Ltd.<BR>To: <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>Sent:
5/8/03 10:08 PM<BR>Subject: [AccessD] Scheduling an mdb to run using
AT<BR><BR>Have any of you had much experience with scheduling applications
to run<BR>(ie. mdb files) using the AT command?<BR> <BR>I am trying to
get a job to run overnight for a client using the<BR>following
syntax:<BR> <BR>at 14:26 /interactive /Every:M,T,W,Th,F cmd /c
D:\Prices\Priceload.bat<BR> <BR>where the files Priceload.bat contains
the following:<BR> _____ <BR><BR>@ECHO OFF<BR>REM Daily Price
File Load<BR>TITLE GBST PRICE LOAD<BR> <BR>M:<BR>cd \Price<BR>echo
ENTER PRICE FOLDER<BR>ntsleep 2 > nul<BR> <BR>Call
Price.mdb<BR><BR> _____ <BR><BR> <BR>I then get the message
'M:\Price\Price.mdb file not found'.<BR> <BR>Because it is real PITN to
keep mucking around with this syntax in DOS,<BR>I am also having a play with
some shareware(?) the client had called<BR>WINAT. It seems good, but when I
use it at my client site to edit the<BR>paremeters of the AT command, extra
characters appear at the end of the<BR>command, so I am not sure whether the
command will work or not.<BR>Characters are things like pipes and @symbols.
<BR> <BR>So my question for anyone using AT is: do you have any tips to
share?<BR>What is the most reliable way you have found to schedule an mdb to
run?<BR> <BR>TIA<BR>Kath<BR> <BR> <BR>Kath
Pelletti<BR>Software Design & Solutions Pty Ltd.<BR>Ph:
9505-6714<BR>Fax: 9505-6430<BR><A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A>
<<A
href="mailto:SDSSoftware@Optusnet.com.au">mailto:SDSSoftware@Optusnet.com.au</A>>
<BR> <<ATT11462.txt>>
<BR>_______________________________________________<BR>AccessD mailing
list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>