I have files stored as the following fistname_surname dd.mm.yy.tft,
I have a database which sends out emails to relevant people, what I need is
a function which will look through my files and get me the most recent dated
file (not timestamp).

Will someone please explain why the Setfocus in the MIInit sub respnds with
an error can't move the f0ocus to the control MIDate.
The intent is to force the user date to enter a correct date.
Private Sub MIDate_GotFocus()

In a module, I open an excel instance, do some operations, then close the
excel instance.  At least, that's the intent of the module but I cannot get
the excel instance to close.  Below are the relevant pieces of code.  I would
like to know if I reference the objects correctly ...

is there anyway to check if my program is looking correct or if i am
completely wrong. Is there anyway to get it checked by someone who knows
exactly what they are doing?

The following rather simple code:
Option Compare Database
Option Explicit
Sub ParseDrawings()

I'm using Basic to import a simple one row table from Excel into Access.  
Access does fine with non-calculated Excel cells, but seems to want to
memorize the values in calculated fields and use them ever after.  The first
time I import or link a new sheet everything is fine, but ...

I am working in Access 2003.
I am working on importing a TEXT file and then cleaning it up prior to
extracting the data.
Throughout the file, I have the following records:

Novice with Access, have a question about an Insert Into error.  The
following SQL statement is giving me a headache.
SQL = "INSERT INTO COMPANIES ( Shift, Operator, Date, DTCode, Line,
Hours ) " & _

As the subject says, I have a date/time picker control on a form. I want to
update a text box based on the picker date after a user updates it. I've put
a break point in my code so I know the event is not  being triggered. Any
ideas?

I use code similar to the following to iterate through the relations
collection to get a listing of all relationships in a particular Db.
Sub EnumRelation()
'*********************************Test Code

I have a City_State field in my db.  for example Ga,Atlanta.  How could i
seperate the city and state and put them in separate fields.  Is there a way
to do this programmatically?  Thank you!

I use Access 2003. The problem occusrs in mdb and adp as well.
I have an unbound main form and a bound subform in it. (I mean the main form
contains only unbound controls, but the subform has a recordsource and has
bound controls.)

When I try to add the CDC to a form, Access returns a message that I
don't have a license to use it. Is this typical of Office Professional
2003? What do I need to do to get the license?

How can I automatically check and modify, if neccessary, a user's display
settings when they open an Access 2000 DB?
Thanks!

I have the following as a validation subroutine for a form:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me!Box1 = 0 And _
   Me!Box2 = 0 And _