Can someone help me how is VBA code for append all records from a
access table into in other access table like Select All Record, Copy
and Paste Append in Edit menu.
Thanks very much.

I am aware that this may not be possible in Access but thought that it would
be worth finding out.
I have a large database of pupil records and would like to be able to run a
query that rolls over the school year groups automatically.  

Access XP database with a FrontEnd separate from the B/e (Tables).  The B/E
file is stored on a server and the multiple users (about 20) have individual
copies of the F/E file stored on the local PC.  At any point in time, there
may be up to 10 users accessing the B/E but it's ...

I need to send a notification email when a report is printed to a specific
printer. I'm not sure how to determine when something is printed to a
specific printer. I'm doing this in vba in access 97 and I'm thinking API
will be needed, but I'm not sure what and the search terms ...

Access Xp DB - On a form I have a macro executed AFTERUPDATE on a check box
field - the macro checks to see if the check box is checked or unchecked.  If
checked, it populates other fileds on the same form using the setvalue
command.  If unchecked, it should delete values in ...

I would like to set the value of a control on a form based on weather another
control is null or not. Im trying to use a before update conditional macro to
check if a control has a date, if it does then I want the value in another
control to be empty (null). Could I use the setvalue ...

Using a macro which utilises the SENDKEYS Action produces the error message:
SendKeys action requires Microsoft Office Access Utility Add-in to be loaded
I have tried completely re-installing Access 2003 with no effect.  Can
anyone suggest where I find the Access Utility Add-in.

I have a form (showing one record at a time) that asks the user for input.  
After the user puts in the information, they click on a button that starts a
macro.  That macro sets a true/false box which removes the current record
from the select query criteria.  The macro then ...

I have a subform (datasheet  view) that collects information about different
products. The left part of the data sheet has columns concerning the first
part of a process. The Right part has fields concenring the second part of
the process.

Before I ask my question, let me admit up front that I am VBA ignorant. I've
done programming in other languages, and I am trying to grasp the concepts of
VBA. I've looked all over this website, and Googled what I'm trying to do,
and I'm still just not quite getting it.

I have set up a macro using the send object function, to send a report by
email, which works fine ater I enter a email address in the To: section -
however I would the recipient to be a field on my report.
Thanks

I have done a lot of "digging" through posts to try to find the answers I
need.....
I am setting up an export to excel.  I have read in the Access help File,
TransferSpreadsheet Action, that it is not possible to export to Excel

I've got a form which allows users to select a value from a combo box then
run a report based on their selection.  However when the report opens it
minimizes despite the macro including a maximise setting.
Any ideas why this is happening?

I have the following validation rule attached to a field in a table.
[HRA Directory]<>"CLI"
Is there a way to add more criteria to it, such as in addition to CLI ( or
"ABC")? I was not able to get it to work.

So, I've realized that coding command buttons in VB gives you more control.  
To that end, I'm trying to set up a VB command button that will populate the
Subject line with data from an autonumber field value that is displayed on
the form where the new button will be.  I can get ...