I need some help with a query.  I believe that a Union Query is
appropriate, but I am unsure.  I have two make table queries.  One
makes a table called QTY_RECEIVED that has the following field names:
Part#, Fiscal_Week, Fiscal_Year, and Receipts.

This has probably been ascked and answered before but my searches have
turned up blank so here goes...
I have an existing database system that requires 3 fields updated in
one table (hardware) from another(clients) when creating a new record

I created a form to input data into several different tables. I am unable to
add new records in the form view. I cannot even edit records in the form.
Whenever I'm in the form view and try to edit a record it seems as if it were
locked. I have checked the properties of the form ...

I am designing a database keeping track of books.  Books are stored in a
box.  Tables in the database are designed to keep track of books individually
per box, which means I have a field for Box # and book #.  Depending on the #
of books in each box, the records are varied in the ...

How do I change the field list from one table to another??
Any suggestions??

I am attempting to create form that has all the same base information in all
data bases but upon a selection from a combo box a different subform pops up
to complete the specific request they are inputing.

I have data in a table, I'm using a combo box to select the individual I want
to enter or edit data in the sub form table.  Each record in the subform
table as a unique id number, when I select that IDnumber from the combo box
on the master form the subform doesn't show the data ...

I have a listbox with 9 columns, I can set the width of all but the ninth
column.  I've set it in the property box and through VBA, but it never stays
set.  On the form, it goes way beyond the set width.  How can I fix it?
Thanks

I have a switchboard and a main client form.  On the main client form I used
the combo box wizard to create a searching combo box-the user selects the
client name from the box and is taken to the first match (no filter, uses the
FindFind method).

I found a query/form for opening reports.  
It is =[Forms]![View Reports]![lstReports]
I love it!  It works wonderfully!
So, I thought I would use it to open a form instead of  a report.  I thought

I am a completly new user to Access and I have been asked to create a
database for a big project we are working on. I am creating a form where a
user would have to select a catagory and after they select a drop down box,
below the radio button, would show a list associated with ...

I have a form to delete records (using a delete query) from a table.  Below
is a sample code that I use to append the records to another table, delete
them and refresh the form to remove the deleted records off the form when the
user click on the button on the form.  

I'm using Access 2003.  I have a form with a tab control and a horizontal
scroll bar.  One of the tabs is very wide, and scrolling far to the right is
necessary to see all of the data.  I don't mind this, but when I click on
this particular tab, the scroll bar automatically ...

I am trying to make a form using Word and I have everything set up and I want
to use textboxes.  However, I want to move from textbox to textbox using the
Tab key..how do I do this?  I can't use the Text Field Form because of the
gray (my boss doesn't like it and wants the actual ...

Here is the code I compiled from several posts:
'Private Sub Project_Summary_AfterUpdate()
'   With Me.Project_Summary
'      .SetFocus