I have an Access 2000 database that contains six tables. They all
contain the same fields (Object, Name, Desc, CodeNo). I want to copy all
the data from each table into one big table in another database file
(mdb). Is that possible?

I am trying to determine the actions that exist within a macro group.  When
I view the macro in design view, there are three RunMacro commands listed in
the action column.  Is there anyway I can determine the actions that are
within each individual RunMacro action?

I have a form/subform where the form is used for record entry and I want the
record to immediately roll into the subform after user hits a button.  The
button has these macro steps:
1.  SaveRecord

Thanks in advance.
Does anybody know how I can loop through a combo box on a form.
For Example, I have a combo box on a form name "Test" with value
(1,2,3,4). Now I need a VB code that can help me loop through this

I posted this message originally
developers.toolkitnewsgroup, i think this is the bet
suited group.
I have a macro that has 2 sendobject actions. since I have

My macro for a message box to appear when the form opens only works when it's
being tested. What am I doing wrong?

I'm learning macros at the moment and thought I'd venture to write one which
I needed myself but I could do with some help, since I spent hours today
trying everything that occured to me and searching the internet when I
should be studying since I've an exam on macros tomorrow.

I wrote several macros in Word 95 and 97 which were searching for files with
specific words in the file text, but I cannot convert them into Word 2003 or
write new macro in Word 2003 of this type. I cannot insert words for search
into the "text or property" property in the ...

We use Access for the front-end linked to SQL tables to store data.  We have
a "random selection" process that has been written as a SQL stored procedure
on the SQL Server.  I'd like to use criteria from text boxes in a form to
pass to the stored procedure and run the stored ...

Hi.  I'm pretty this question might be accomplished with a macro, or perhaps
some other kind of Access Language.  If this was an Excel program, I would
know how to do it lickety split with a macro!
This is what I want to do (I have seen it done before but don't have access