I have two tables with the same structure and much of the same information.  
There is a history as to why these tables exist the way they do but the
bottom line is I need them to be identical.  One table will always have the
most current records and I need to copy only the "new" ...

I'm new to programming Access (and to programming in general) What I'm trying
to do is the following and I'm not exactly sure what is the best way to go
about doing it.
I have a querry that I need to export each record of as a seperate text

Thanks for taking the time to read my question.
What is the value of w in this case?
       For Each w In Worksheets
           If DataSheet = w.Name Then

I have 2 tables, namely Despatches and Stock.
On the click of the Despatch button on the form, I want to read each
transaction line on the despatch and write them out to the stock table.
Can anyone help me with the coding for this or point me to a good example of

hi everybody in this most wonderful access user group
ive got this problem
i have a module which opens up a word document and then iterates through
each paragraph gleaning certain information.

When I pull this up in excel it shows the primary fax number in the first
column but it appears it concantantes the ContactName and AccountName the
second column.
I am trying to get this to write 3 seperate columns.

I have
Dim wdApp As Word.Application
   Set wdApp = New Word.Application
   With wdApp

I received this info from Programming Data Acess Pages (Microsoft Acess 2000
Technical Articles)
http://msdn.microsoft.com/library/en-us/dnacc2k/html/programdap.asp?frame=true
. It is not working using Access 2003! Can anyone suggest how to do this?

Can someone help with the following problem;
1. copy files from one folder to another.
2. be able to select one or more files.
3. be able to select destination.

   I have the situation where I need to read a table field value, which can
be of any data type, and convert that to a string. To do this I pass the
field value to a function expecting a Variant parameter and decide on the
best string conversion function after testing the ...

The following sub returns syntax error in the last line. Please, advise the
correct syntax.
Private Sub TextBox_AfterUpdate()
   Dim branchID As Integer

Sometime ago I set up a module to open an Excel Template, refresh the sheets
and save the book to a share. Now I need to stick a password on the file  to
be saved.  Would anyone know the syntax?  Here is the current code:
Dim xcelapp As Object

During the execution of a program I use the following to display the step the
programs is on the status line:
 DoCmd.Echo -1, "Create Actual Data for Branch Ranking Total."
When the program executes a query, the message is covered by the following:

In a macro, how do you retreive the parameter value from the menu item that
called it.
Amiga1200

Hello.  I'm looking for a way to check and see if a user is a member of a
particular domain group.  I have the code to enumerate the current Windows
user, but I don't know how to check it against a domain group.
Thanks.