Hello all,
i need a way to replicate the export function from the
table menu item. what i need is a tab delimited, no quotes
and column headers. when i try to create a macro to do

I am trying to create a query that will take a user entered number, add it to an existing number and update the field where the latter number is held. When the query is run, it takes the first number (user-entered) and adds it twice. Ex: 2+6=10. Following is the SQL.
UPDATE ...

When I boot up my database a macro deletes a table and
runs a seperate macro which in turn creates a table of
the same name.  However, there is the rare occasion that
the seperate macro does not create a table.  When this

I need the help of you wizards out there. I am trying to
create an application in Access that tracks production
materials. When we receive a load of semi-finished
products in our place of business, we assign each piece a

I have a database which contains an ID field, Name Field, Percent Field,
Date Field.  The ID field is not unique and contains records which all map
back to a singlar ID.  This information is stored in another table, with the
Fields ID and Group Name.

I'm looking for a way to password protect the excel spreadsheets currently
created in a send object macro w/i access.
Currently, I use a macro to open a report based on a query filter.  Then  I
use send object to send the report in excel via email.

How do I code a Click event to send an email to a
specified party, with a specified subject, and a specified
message? (Include file attachment ability if convenient.)
TIA

How can I transfer this simple Event Procedure..
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
   Dim stDocName As String

I have a macro to filter my data...it sorts the data
fine.  But at the end of the record set, it gives me a
message that says "you can't go to the specified record,
You may be at the end of your record set" (which is

I trying to use the findrecord and findnext routines to
search through my database.
The findrecord action works fine.  On my form I have a
button that is linked to the findnextrecord event

I asked this question at xmas without response...hope
somebody sees it and can help this time:
I created a db in Access 2000. There are several reports
which are each built upon several parameter queries. I use

I have a macro that calls a query containing Parameter criteria.
There are 8 times when I need to input the same pieces of information
(Numerical Month and Year)
I would really like to enter this once and have the answers passed into each

        Hi all
                I have a simple problem I'm using the docmd.sendobject to send a report as an rtf file attachment to email addresses ...  It send the email fine ... But some times it will send Muliple attachments ie 3 rtf's that had quite different data on them.. ...

I'm working on a database and was wondering if it is
possible to open Excel to by running a piece of code in
access?
Thanks

I have a msgbox in a macro whose condition is:
MsgBox("Do Another Package?",4+32+256)=256
If the user chooses the 'yes' button, I am trying to create an action
relating to the yes response: