I am presently using forms to write to one table. I would like to duplicate
that table, give it a different name and have a form write to both of them at
the same time. This would mean I can have both tables saved in different
locations giving me a backup of the data. Obviously ...

Hiya!
I'm trying to set something up to help one of our folks track our shipments,
and I would like it to look on another subform to see what's going on, but I
keep getting errors.

I have what looks like it is a many-to-many relationship that I need help with.
I have a main table that has a team name, wins (#) and losses (#).  I have a
second table that will have the team name, and every team on their schedule
w/ wins and losses.  I'd like to avoid having to ...

On a form and report I am trying to make the one days ending balance appear
as the following days beginning balance (e.g)
Day     Beginning Balance     Income       Expenses      Ending Balance
Mon               10                  15                5                    

I've created a "start up" form where the end user can navigate to do data
entry, update tables, pull reports or do a record search based on specific
criteria - all by using the associated command button.  However, I am unable
to get the record search button(s) to work.  The goal ...

this should be very simple, but it's not always obvious.
I have a form, with a subform. I want to select all the records in the
subform and paste into an Excel worksheet.
I've got the Excel bit okay - but it's the Access part of copying the

I?m having a little trouble with re-connecting the front end of a database  
with the back end using code in a hidden start-up form.
I got this code from one the users of this forum (Thanks Mike) and then  
modified it to suit my database.  But I can?t get it work properly and  

Hi Arvin,
I have used your ShellExecute api function
(http://www.mvps.org/access/api/api0018.htm) for my document control
database. It works fine in that it will open any windows-registered

I am working on a database to track employee absenses and I am having a
problem with the points not updating the table. Would it help if I designed a
subform? And how would I design that?

I have the following Select statament in VBA which is returning a Run-Time
error 3061.  The final intent is to populate a continuous form with the
records set however, for now I just need help getting the Select statement to
execute.  

Does anyone know how to populate a subforms textboxes from some certain
criteria initiated in the parent form. I have a DAO.Recordset so i want
to tie that into the sub form to. Please if anyone can help please do.
thankyou.

I'm new to programming Access, and I'm having a problem with giving
focus to a row. What is happening is that I click an OK button in a
form and this opens a new form, which happens without a problem. Next,
the newly opened form is populated from a query which returns all the

I have two forms. One if the main form and the other is a subform.
How do i make the subform change its information based on a change in the
value in the combo box.
For example:

I have some required fields on a form.  I'm checking these fields in the
Form_BeforeUpdate sub.  When just clicking on the fields and then trying to
go to the next record by clicking on the little arrow at the bottom of the
form it works as intended (A message box pops up telling ...

I need to be able to populate a subform with the parent forms data. the
subform has about 7 textboxes and is in datasheet view. does anyone
know how to do that at all?
harborTemp = Replace(cboHarborClient, " ", "")