This doesn't compile on this line:
      Dim appExcel As excel.Application
and I don't know why?
Also, do I need to declare the function with the library kernel32?  I don't

I'm trying to write code to send an outlook message automatically.  I need to
set the From: to a mailbox other than the sender.  Does anyone know how to
set that property?

I have a question. How can i merge these codes:
CurrentDb.Execute "DELETE * FROM Table 1"
CurrentDb.Execute "DELETE * FROM Table 2"
CurrentDb.Execute "DELETE * FROM Table 3"

This one line of untidy code works....
CurrentDb.TableDefs("TableName").Fields.Append
CurrentDb.TableDefs("TableName").CreateField("New_Field", dbDouble)
=======================

I was wondering if someone can look over the code below. My main form has a
control command (buttom) for a subform. I am trying to have the control
display the message below if three fields are left blank (TeamName, Incident#,
Incident_Date). If data is entered then I would like the ...

I have 2 questions about this function.  I changed it from DAO.DAtabase,
DAO.Recordset to ADO.Database and ADO.Recordset.  The reason was I am on a
borrowed computer and DAO is missing from references.  I just have to finish
writing this program and then buy my own computer.  I ...

I create one UDF and it working perfect in access form but one I try to used
in access query it give me this message (run time error ‘424’: object
required”, so what problem if you can help in this matter
Thanks

On my Supplier Info Form I want the user to be able to select Equipment Types
and Manufacturers that they carry.  I want to display what they currently
carry and allow the user to add, change or delete the equipment types and
manufacturers.

an info box pops up intermittently with the error: "The data has been
changed. Another user edited this record and saved the changes before you
attempted to save your changes. Re-edit the record."  the lookup box is the
first control on the form, the user is to start entering the ...

I have the following issue. I have a subform where data from a query is
shown following the selection made on my main form.
The data shown on my subform has been rearranged to have a certain layout,
different from the one in the source query.

I would like to automatically delete all of the records in a table that meet
a certain criteria in a specific field of a specific column. Example, delete
all records that have 2008 in the fields of the Year Column.
Thank you for any info that would  point me in the right ...

Not exits the program frontpage 2007 or are on new suite microsoft..

Access 2002, SP3
MDAC 2.8
Is there something about the Add, Edit and/or Update methods using DAO
recordsets that I should know about.  From my understanding and what I have

how can i use the click event of a command button to save info. from a field
on a form to another table besides the record source table? I guess it should
be simple, but i can't figure it out.
Thanks in Advance

I have a database with one catagory labeled "Keywords".  A single entry may
have a string such as "Rodeo; Gary; Magazine" (identifiers that we use to
catalog projects).  Is there a way to create a search feature that would
allow me to search for "Magazine" so that all entries ...