I am having problems when using a date value coming from text box in a sql
string.  The date is in the format  mm/dd/yyyy.  If the particular day is
less than 10 (probably the month for that matter), it automatically filters
out that 0 and makes it mm/d/yyyy which disallows me to ...

I have text strings in a field called HRID.  I'm looking for a function that
will examine each item in HRID.  If the length of the string equals 6, then
leave it as is.  If less than 6, then add whatever number of leading zeros is
required to make the text string exactly 6 ...

With this code
           Dim dbs As Database
           Dim rs As Recordset
           Set dbs = CurrentDb

I would like to disable all access to the Database Window
without having to set up security levels or user groups.
Can this be done easily?
Any help appreciated.

I am using Access 97.  For sorting purposes, I would like to sort the
following date types in the same field:
YYYY/MM  and YYYY/MM/DD
I've tried appending a table that has dates in the first format in to a

I am going crazy! Today when I go into visual basic editor and enter a new
line of code it keeps trying to autocorrect. As soon as I type something the
preceding text goes red. The drop down list of options appears for an instant
and then dissapears, eg if I type "Me.Parent. etc" ...

Is there any way to boot uncooperative users.

I have a record I'm reading in:
   Column : Customer ID  ("CXLIB"."UT211AP""UTCSID")
I can grab the 'CXLIB', 'UT211AP' and 'UTCSID' by looking for the double quotes.
But I was wondering of there's an easy way to grab the 'CUSTOMER ID' from the

   I have a access logon form which will first get current logon domain
username and domain name to verify the username against active directory.
   Any points?  Thanks in advanced.

I have two combo boxes and when I select one to filter the
other, the subform always ends up with an extra record
(false data).  Is there a way around this?

I have a master database of employees. What I need to do is to automate the
creation of 50 different databases with only the data for each of those 50
individual managers contained in their private database. They will then fill
out employee reviews. After that they will return ...

Good Evening.
Some strange problem:
From MIME decodifie Mail message i get Time_Data_Reference
as String in this STANDARD way:

I have a Help-Desk form that displays rows of data (called "problems").  The
users want to double-click on a row (Problem to them) and open the form that
shows the many details of that one specific Problem.  I can do that by
opening the EditProblem form this way:

I am using Kill to delete a file; however, I need to bypass the "file does
not exist" messages that is returned if the file does not exists. How can I
check to see if a file exists so that I can just run the Kill if the file
exists?

I've been working with this project to create and delete users with an Access
program.  The command line utility DSADD is how that works for me.
By using:
Shell ("c:\windows\system32\dsadd.exe user """ & "CN=" & LastName & "\, " &