I have a form that pulls data from one file it then has two subforms.  The
data in the main form is updated by a file daily however I would like to know
if it is possible to take the data and move it to another table that would
contain all the informaion to another table if the ...

Running Access 10
I have a form to launch my report.  The form creates a temp table for the
report to use.  When the report closes, I want to delete the temp table.
  DoCmd.DeleteObject acTable, "MyTempTable"

I am coding a form for a database of servers.  The form is bound to the
table "Server Inventory."  I have a combo box (combo35) from which a server
name (ServerName - Primary Key) is selected, and the form populates the text
boxes with all appropriate information.

is there a reliable way to test if a form has been moved to a new record (as
opposed to changing to another, existing record)?
thanks
craig buchanan

I have a msaccess form which was developed based on SQL server tables with a
main form and related subforms. The subforms are also independent forms
created based on queries on sub tables
I modified the master form to accomodate sql server changes by

I am trying to execute a sql server DTS package in MSAccess and the code in
the form goes like this
Private Function RunDTS() As Boolean
On Error GoTo error_

I have a form that already has three drop down menus and the users have
asked for a fourth that has month and year. On the table i have a field that
stores the exact date and time the record was created, using
CurrentTimeAndDate. I was wondering if someone has any suggestions on ...

I have a table containg a tasks list.
Each tasks has a creation date, begin date, end date and duration (days).
Would like to build up a form/report in "calendar" view, alà Outlook
Calendar, looking for any sample.

I need to streamline data entry by duplicating pre-existing records. The task
is to create records for finished goods. The finished goods fall into
families of pack configurations like 2/1 GAL; 4/1 GAL; 8/.5 GAL; etc. Each
pack family has shared as wells as unique records.

1. I'd like to use a button on my form to browse for a file on the network
2. and then once the file is located place the name of the file in the text
box.  
3. I would later need to save and then reference that text field so that the

I'm trying to use the following code to run a query that will return only
the records where Field1 in the query is equal to strField1(a variable I
define).  When I run the code I receive a Item Not Found In Collection error
at the line where I Set the prm. to Field1. I do not ...

I have a report built on a query which is built on a table
In the query, I have a field called [Date]. In the criteria section, I have
a Between [Enter Start Date] And [ Enter End Date] expression so that users
can limit the data to a data range.

I think I may be missing something obvious here but anyway.. (I may also have
posted in the wrong place!)
I have a table of Order Details which are added via a form. Currently when
they are added an autonumber ID field is used to identify them.

....I've been trying to make this UPDATE sql statement work:
       sqlSTRING = "UPDATE tblCLIENTS SET tblCLIENTS.CL_ID =  '" _
                   & Me.txtNEW & "' WHERE ((tlbCLIENTS.CL_ID) =  '" _
                   & Me.txtORIGINAL & "');"

What I am trying to accomplish is allowing users to click on a button from
an access form and activate a mail merge into a protected form field word
document.
(Some of the fields carry the access data, and some need to remain form