Is it possible to run a command that you would run at a dos prompt and get
the response back within Access?
Thank you,
Judy

If this is the incorrect forum for this question, please let me know the
better place to post, but...
In Excel, I wish to build a dynamic table of criteria in memory and ==>
somehow make available to Access, to join against another table, via an

I've successfully used this code in several db's, but for whatever reason,
the db I'm working on now is have a problem inserting the "EditTo" records.  
It just won't create EditTo records in the audit table.
I've determined the problem is in the append query.  Here's the SQL the

vName = Nz(DLookup("UserName", "Users", "Order = " & UserClearedItem), "")
If UserClearedItem is Null it will error.
How do I fix that?
Thank you,

I have two text fields storing part numbers.  One stores a stripped number
and the other stores a spaced number. Example: (12345 and 12 34 5).  I have a
Search text box that I currently type a stripped number into and the record
is retrieved. I need help on the following:

Access 2000 SP3
When I use the date() as a default in a date field for default I get an
error when I save the table.  Unknown function'Date' in validation expression
or default value in <table name>. Any ideas???

Using Office 2003 and Windows XP;
I'm in the process of working out some code to create a custom toolbar
whenever a user opens a report, mostly to keep the user interface from
becoming compromised;

Is there any way you can have VB create .lnk files (shortcut files) on a
user's desktop or a network folder?
This sounds like a wild question, but let me elaborate...
We decided to 'clean up' our network drives.  I obtained lists of

I have a multiselect box that has a number of choices, one of which is "None"
I would like to program the box to trigger a  Msgbox if "None" is selected
in addition to other choices, as they are incompatible.
One option would be to leave "none" as the default text box data, but I

The following code returns not the first, but the last record:
Set db = CurrentDb()
Set tblspec = db.OpenRecordset("tblPIDspec")
tblspec.MoveFirst

I have an application that requires a matrix of option buttons that changes
based on a table.
So far, I have a method of creating a collection that identifies each item,
but have not been able to make the item into an option button. Is this

Using Office 2003 and Windows XP;
If a text box control on a form contains a string, is it best practice to
use TEXT as in:    sData = Me.MyControl.Text
Then, if it contains a value to use VALUE as in:    iData = Me.MyControl.Value

I am still using Access '97 and I am trying to change the field type
programatically from a number to text field in a table.
I have searched and found a DDL method but this is for Access 2000 an beyond.
Is there a solution for Access '97?

I have three databases that collect and process information. One generates
cost center usage percentages that are used in the other two. One of those
processes print services data collected from a mainframe source, the other
processes other mainframe collected information. I ...

I have a form that is based off of a query.  the query gathers its
information from a single table.  i have a seperate (custome MFC) program
that adds records to the table.
is there a way to get a current count of records in the table?