I've been studying samples of code from your web site to improve my skill
level.  In the fragment below, why do you declare varDOB as Variant, only to
later validate it as a Date in the If IsDate statement?  Why not just declare
varDOB as Date?  For that matter, why not declare ...

I have been trying to use the code for calculating working days that i placed
in a module but have not had much success. How does one utilize or insert the
module in a query so the function will work? I have two fields in the query ,
one for enter date and another recvd date but ...

I have hit a dead end with exporting a worksheet out of excel as a tab
deliminated text file. I am just new with Excel Automation
My code looks like this
Private Sub Export_Click()

I'm trying to copy data to a new table.
My command botton code grabs the data, creates a new record in the
destination table and dumps it in. It reads a public function called
"GetNewID" to create a new record.

My code loops through a recordset and creates a PDF file from a report on
each pass.  It is necessary to rename the file before the next loop.  It
takes about 4-5 secs before file creation is finished.  
The rename line will fail until the file creation is complete.  Currently I

I need help with a function called CompAgeGrp that determine's a student
athlete's competitive age group given his date of birth and the current date.
From Jul 01 to the following Jun 30, the student's competitive age is
defined as his/her age on the January 1 occuring in that ...

Is it possible to show a list of currently open excel files that the user
can then choose from which one to import information?
David

I am tring to format a field so it will autonumber, but I need the first to
digets to be the month and the next 6 digets to start at 1 and count up by
one. I format like that but can't figure out hoe to make it autochange the
first 2 digets every month so it with look like this

Using Office 2003 and Windows XP;
I have a form with a control that a user may double click to open another
form containing a list of values. Double click this list and it copies some
data back to the original form. This all works great...except...I can't get

I would like to open a form and wait for the form to close before continuing
execution in the code the does the open form.  That works fine in the default
setting such as:
       DoCmd.OpenForm "ProjectManager", , , , , acDialog

Continuous form. I have three controls in question here:
TimeBegin (unbound)
TimeEnd (unbound)
TimeCount

I have a main form (Entry), and a sub form - continuous - (EntryContainer).  
The sub form is a simple table holding 2 pieces of information (container
information) and the EntryID that links on the main form.   When multiple
people are entering container information via an MDE ...

Is there a way to determine if a reference library is installed on the
current computer?  I can't seem to find the proper collection for this type
of query.
Thank you,

I review every post regarding the above subject, but I am not sure any of the
suggestions apply so I will post my issue.
I want my auto number column to format as follows:  200701, 200702,
200703...  Seems easy, but the kicker is that next year, I want it to be

I have included a utility in my development that references to MS
Excel 12.0 Object Library.
How do I package the Object Library to be included in the runtime
version that will run on machines that have Excell 2002 on it.