Is there a way to execute a DOS command (i.e. MD, CD...etc) from a from.  
Thanks,
Fred

Is there a way in Access to have a database read the current username that
has logged into the computer and their password and use that information to
verify the users rights to certain forms, tables, queries, reports and macros?
I know in VB.net I can read the registry for those ...

Is there a simple way to convert a string in the format yyjjj where yy is a
two digit year and jjj is a three digit day of year into the more usual
dd/mm/yy format?
Thanks

I want my code to do what I manually do, but don't know how.  I open up the
table [Names] and run a find/replace; I find this: ^b
and replace it with nothing.  I search all the table, and any part of the
fields.  How do I do this programatically?

Here's the issue...
I have a database that contains records that can be modified by managers
(lets say they were attributed volume that wasn't theirs).  The data can be
changed until the 6th business day of the following month, so if a record was

I need to be able to take a date format (mm/dd/yy) entered on an Access form
and convert it to a Julian date for an AS400 query.  The file on the AS400 is
looking for this format: 1CYYDDD.  For example, 10/15/07 would be 107288.
Can anyone help with this?  I am using Access 2003.

I am trying to deploy a runtime version of a split database to a number of
users. I have employed an error trap to check linkages to the be database and
if not there it opens the "Linked table manager" dialog so that the user can
point to the correct location. This seems to wok ...

We have been using a Access 2K for our application on a LAN.  We want to
convert from using the tables in the mdb file to tables on a sql server.
Is there code, that anyone can recommed, that will automatically log the
user into the sql server and keep a persistent connection.

I have a database on a server that houses a number of departmental tables
linked to separate desktop applications.  Is there a way for me to tell who
is logged onto the server database?
Thanks in advance,

I have a subtable on a form. One of the fields is a combo box. Is there
anyway to code it so that if the 2nd value of the combo box is selected that
the particular record that field is attached is disabled. I still want the
other records in the table to have read/write access. I ...

I have a form with a list box listing values "table 1", "table 2" .... and 2
combo box for year and month selection.  The selected values (year and month)
in the combo are set as criteria to run a query.  
While the query runs from the same data table, the selection in the list ...

Hi, I'm trying to figure out the best way to do this ...
I am building an audit database to record audit details and ISO clauses
attached to each audit.
What I want to do is identify which audits have not had clauses allocated.

I need assistance with the right way to insert records to table.
I'm getting as an input from a user form the number of duplicates and the
identifier that says which record to duplicate. I need add letter (a,b,c...)
according to the counter. For example: the user put identifier ...

We have several Access 2003 databases that link to numerous source files on a
workgroup server at our main location.  Unfortunately, people at some of our
sublocations can't make use of these databases because of bandwidth issues:  
although they can "see" the main location server ...

I am trying to send an email with attachment from Access 2007.  The following
code fails to detect Outlook even though it is open, or even try to create a
new instance.
Dim objApp As Outlook.Application