I was all happy because thru some tutelage of others I created this
array to find the newest file in a directory.  However, I then
realized its great that I now know the latest file, but I need to know
the name of the file.  Unfortunately, I am only passing the date into

Hi Everyone --
I have two tables, one has a list of Items and one a list of Bidders.
I'm creating a Form to allow the user to select the Bidder Name from a
dropdown list.  I want the Bidder Name to appear in the dropdown but

How can you get the contents of a text box to change after for click
out of it. Eg I have a text box on a form called Ownername. If some
one enters a name in lower case that it automatically changes it to
sentence case ie john smith goes to John Smith

I am trying to create two custom menu bars for my application, one for
read-only users (without delete record), and one for update-access
users (with delete record).
I only need File and Edit options.  File will be the same on both, but

Question... Is there any way to put a wrapper on a raw string going
through SQL, or should I bite the bullet and use a recordset method
instead?
Situation:

I need my Date field to possess the following format:  Jan-05-1999
How do I change the Date Format/Input Mask to accomplish this?
Thanks!
John

I need to import (or link to) some SAP R/3 report exported to a .txt file,
for further processing.
The problem is that the file is not normalized. Instead of columns and rows,
it has hierarchical nesting of data.

I keep my data in an array and using TextMatrix property for filling
the control cells. I am not using recordset.
Is there any way for creating bands programmatically in a Hierarchical
GridView Control for expanding and collapsing rows ?

Can someone see why this does not work?  I am trying to get some text from a
tab delimited text file called staff.txt into a table called tblStaff,  The
actual path to the text file will vary, so I am trying to do a simple
DLookup in a table that gives the path part then, ...

I want to have a prompt a text box on a form so that clears once you
click on it to enter information. eg Ownername field to display "Enter
Surname then First Name" until you click on it.
Thanks

I want to do a database of horses and owners, owners change so what I
want to know how to do is in the report pull the horse and current
owner only,
All help appreciated.

I have a form for registration (frmRegistration) whereby i have two
buttons. One is Save which saves record using the OnClick property. I
used wizard to create the save button. The other one is Next button
which i created to open another form "frmSummary" which displays back

I am using a treeview control as a sort of swithboard / menu for a large db
(in terms of forms and reports), rather than in terms of data.
Code and samples largely "nicked" from Alex Dybenko from Point Ltd. Thanks
for that

I was reading and modifying some VB code needed to import all of the
excel files in a directory into one table in Access and ended up with
the following which works.
Public Sub ImportAllExcelFilestoTable()

I have some text fields in several linked SQL Server 2000 tables that
intermittantly have either a zero length string placed in the field or
a null value.  My desire is to have null values when there isn't any
data entered into the field from an Access 2003 form (Access 2000 file ...