I hope this will make sense.  Please bear with me. :)
I have two firlds in one table, ModelMun and Cost.  Cost is going to be
conditional on ModelNum.  In the past in a situation like this, I've just
used two combo boxes on a form and used VBA to assign the value of Cost based

Is there any alternative to
"DoCmd.RunCommand acCmdMakeMDEFile"
for creating an mde file.
Above statement opens the dialogue box. However the

I designed this database were the information in certain fields of a record
would need to stay the same and I would like to create a button to copy the
current record and append it to the same table, then clear certain fields.
For example:

I've found posts that describe this exact situation, but I can't get the
solutions to work.  I know I'm missing something really simple, but I've
spent more than an hour on it and need to move on.
On a lookup form, the user can type in all or part of a Client's Name into

I would like to write some code that will open a database using the
OpenCurrentDatabase method.  However the database I am opening has an
autoexec macro that opens a form.  
My questions is how can I bypass the autoexec using the OpenCurrentDatabase

I am trying to export a report with a dlookup in the outputname string.
strOutputName = "\\L:\Daily Reports\Brokerage Comb Report " & DLookup("[End
Date]", "Daily Criteria") & ".rtf"
The following error message appears when the report is exported:

I have a query that subtracts one date from another, returning the
number of days.  The field is certainly numeric.  But when I bring this
field into another query, Access interprets it as a text field.  There
are no possibilities of any of the records being null or having text.

what is the correct syntax for using mulitple criteria for the Find method?
I tried:
sTemp = "[FirstName] = '" & Me!First & "' AND [LastName] = '" & Me!Last & "'
rst.Find (sTemp)

Is there a way to display the results of a query when doing a count?  
vSql = "SELECT distinctrow Count(WORK_REQ_ID) AS CountOfWORK_REQ_ID FROM
VIAWARE_WCS_TO_VIA_T WHERE (((DTIMEMOD) Between [cal1] And [cal2]))"
DoCmd.RunSQL (vSql)

is it possible to time a persons inactivity and boot them off a databse after
a certain amount of time?

I'm trying to change the NumericScale property for a column but am receiving
errors.  Here's the code I'm using:
Dim m_adox_Catalog As ADOX.Catalog
Dim adox_Table As ADOX.Table

Is it possible to execute a string variable as a VB statement?

I've done this in a macro and then saved it as a module. Basically I've got a
query that prompts you to enter a date for it's criteria. My Macro it
SendObject for this query to a mailing list. However, if there are no records
for the date entered I do not want the email to be sent.

I'm an advanced user of Excel VBA, but a newbie to Access VBA, and I'm still
trying to figure out the method of specifying objects to perform actions
against them, etc. (for instance, I've already learned that, unlike Excel, in
Access you don't "select" the object you're about to ...

I want to copy objects (eg, forms, queries, modules, etc.) from an external
database (clients.mdb) to the current database: I do want the external
objects to replace the current database's objects of the same name and to do
this without user involvement.