I need to delete some files from a FTP location.
What i need is to delete all files that has date older than today minus 2
days.
Is this possible?

I'm currently doing some minor updates on a VBA program. I'm using Access
2003 SP 3 and I'm editing an Access2000 database without upgrading it to
Access 2003 (because most of my users, use Access 2000). The updates I've
done work fine under Access 2003 but when I try to run the ...

Hello,
I need to create a table and add fields.  I tried the following text based
on an example in a book, and receive the error shown below.  What would you
suggest to get the sub running?

I'm executing the code below and when the code is executing the Docmd.
OutPutTo is abend with "Run-time Error 2501".  
Function acManagerReport(acManager)
Select Case acManager

I have a continuous form with 3 text boxes (ID, Tx1,Txt2). I'm trying to
create a script that only allows users to move to another record if Txt1 and
Txt are not null.
ID is unique.

while using an Access 2007 .accdb file I can access the dao. object very
easily.
the following code in VBA works well :
Function getrecordcount(strTableName As String) As Long

I want to change this code so that it will only check the records that I
specify, not every record in the table.  Here is the code, can anyone help?
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

I have two tables in a parts database called "new parts" & "used parts". The
primary keys are "used part number" & "new part number". How do I create a
query so I can have both used and new parts listed together. If you need
additional info please let me know.

I have code that previews several reports. How can I close each report
(pause) before previewing the next report? e.g. the code below opens all
reports at the same time
Sub RunReports()

I'm using Access xp.
I posted earlier, and am having many troubles with the shell function.  All
I'm trying to do is launch the "C:\I386\Scanpst.exe" application to check for
corrupted pst files from an Access module (Actually, I'd like to eventually

I have two tables. On the 1 side is Yr8students and on the many side is
Attendance. Referential Integrity is set.
I have populated the Yr8student table with 30 names and student ids. This
table is linked via its StudentID field to a StudentID field in attendance.

I need to print some mailing labels. I work with an adp Access
frontend and a SQL Server backend.
The problem is this: I need to print address labels for all the people
whose birthday falls within a given month.

We have an attendance database that all of our teaching staff uses. Those who
access it via a mapped drive can see the lock file when the database is in
use and understand to leave it alone. Those who do not have the mapping
access it via a desktop shortcut and do not see the ...

Hello all.  I can't believe how helpful this forum has been to me in the
short time I've been expanding my horizon into VBA, both in asking a
questions and just reading all the posts and learning things that MIGHT apply
at some point.  Thank you.

I'm adding records to a table from a text file and need to verify that
records from this file don't already exist in the table. Insurance against
multiple imports.
A multiple-field index named EERecordIndex (strEEId, strJCID, ShortWrkDate,