How can one FTP to one's site via VBA (or built in Access control)? Examples
of required funtions would be: file upload, download, delete, rename, move,
and director listing.
Thanks in advance

I would like to be able to look up any 5-digit ZIP in a table
that would show the correct time zone for the area. For
example, I would like to look up 91915 in the table and
see something that indicates Pacific Time Zone or 27615\

I have a very large data set where I have to do considerable regrouping
of values and would like to know how you would suggest doing the
following regrouping?  
The structure of the data set is the following (heading fields in first

I'm using Access 2002, as front-end and back-end as well:
1) I faced database corrupted problems, when more than 1 user edit
concurrently.
  I'm using All-records Locking, and open-exclusively as default.

I have a report with the Priority field is used as sort order and
grouping.  The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium.  How could I sort it as:
Low, Medium, High?

This is very strange and disturbing. Last night I opened the FE of my
development version of an A97 database and immediately received a
Windows-level error message titled "msaccess.exe Application Error".
The message body was along the lines of "... instruction 0x6517daaa

my first post so please be gentle...
I want to put the following prescribed content into an access
database:
TS:16

We have put a calendar control on a form.  The form is for employee
time off.  The user chooses the employee and the type of time off
(sick, comp, vacation, etc)...then clicks on the calendar to enter the
days off....as it is now we can add new records when the calendar is

I've inherited my pet hate, which is an ADP.
Original developers have coded themselves into a corner with this, and I
need to make lots of changes to many dozens of screens. With DAO I could
walk the collections and make changes to the properties of the forms

On another newsgroup an Access knowledgable party posted:

I'm using Access 2000.  I have a subreport control which loads a
report in the detail section of a main report.  I need to keep a count
of each item price in the subreport and place it in the Report footer
of the main report.  Each post i've read on this seems to not work

I create a table in MS access:
CREATE TABLE TABLE1
(_ID COUNTER PRIMARY KEY,
SESSION_ID INTEGER REFERENCES SESSIONS (SESSION_ID),

A friend's unix application produces various reports daily as  flat
text files.
I link these files as tables in an Access (2000) database.
After linking, all of these reports begin with a blank row; no

There is an MS-SQL table named Bugs_Comments_and_Suggestions.
There is a form named Bugs_Comments_and_Suggestions.
To allow John Doe to use this form, we GRANT him LOGIN and ACCESS permissions
to the db and SELECT permissions on the stored procedure which is the record

I have a filenane defined in a table in my database.  This filename
field is also displayed on my form.  I have place a print button on my
form.  I would like to be abel to click the Print button on the form
and print out the file defined in the filename field.  How can I do