I'm shelling out to DOS to run an FTP command, and I'm wondering if
anyone knows if there's a way to log whether or not the FTP session
was successful?  If anyone has any ideas, let me know.
For reference, below is my (edited) commands executed in the shell:

I have recently been trying to determine the best technique to pull the
least amount of info across the LAN link in a slow speed LAN situation
(e.g. < 10 Mbps), where data volume = performance.
After much confusion from reading a lot of info, some of which had

I have 2 tables:
table1
CODE | PRICE
1234 | 20

Is there a general method for detecting that a user has changed the
record currently visible on a form, whether this is by hitting PgUp or
PgDn or clicking on a navigation button, even if no change has been
made in any control?

I currently have 2 reports.  One report shows Transaction History (I
will refer to as "TH") and the other shows Account Summary (I will
refer to as "AS").  I want to combine the reports into one report
using a sub report.  (I still want to view "AS" seperately by itself).

I have a SQL Server database that is connected to a client server
program via ADO.  I want this same program to be able to use JET as
the database back end (to provide a light alternative that doesn't
require a full install of MSDE or SQL Server.) I know that I can't

I'm just recently come to work for an auto brokerage firm.  My
position involves performing mysterious rites, rituals and magick in
order to get information out of their access database.  This is due to
the fact that the "designer" they hired had an unfortunate ability to

I have a large number of records that have an elapsed time in seconds
for each one that I was to have a total time spent. I can sum them up
with query easily enough but I need to be able to display this in a
easier to read format. I was able to do that for individual records by

Having an issue with the VB script to open a form...well not really an
issue just a feature I'm not sure if it is possible.  Th script opens
a form but I would like it to open to a blank record.
Private Sub Entries_Click()

I need to copy records from several different tables into one text file.
Although the tables have many common fields, they also contain several that
are different from table to table. I can copy and paste the dissimilar
records manually into the text file, so it would seem that ...

I have what I think is a little strange...I have to get data from our
payroll system into  a specific format (fixed record length) as a .txt
or .prn file only to upload to our 401k custodian.
I can get the data into Access (from Payroll) and write a query with

Hello.  I have a form with 2 subforms on it, subform1 and subform2.  Is
there some way to requery subform2 from an after update event on one of the
fields on subform1?  What would the syntax of that be?
Me.Form.Subform.subform2.requery does not seem to work.

I need to be able to display a count of records in a message box but
with a criteria of the just ones where there is a yes in a certain
field. so the message box will pop up saying something like "there are
23 forms issued"

I have two tables in sql database as follows.
I need to generate the output given at the end.
=======
Table1

Several years ago I developed an Access 97 runtime application.  I
have rewritten this application using Visual Basic 6 with an Access
2003 database.  When I run the VB application with the database on the
same PC, the performance is good.  When I move the database to a