i have two tables.  Both tables have the same column headers but in different
order.  
Sample headers are:
Rep number

I am new to access and I am trying to figure out if and how I can email a
complete inventory db including the record for each item. I have a car
dealership with an inventory of their cars and a seperate record for each
vehicle. I would like to know if I can email the inventory ...

In my form, I would like the table field to populate based on the selection
from a combobox in another field.  The two colums are Area and Task.  On my
form I would like to choose my task and the area populates in my table.  I
presently have a task box [Area]based on the the ...

I have repair records which list Repair Date,Repair Order number, VIN
Number (Vehicle ID) and a part number.  Each repair order may contain up
to 100 part numbers and the part number variations number in the tens of
thousands.  I am trying to create a report in which the first 10 ...

I've checked out some posts related to my problem but I'm just not getting it.
I've created two tables to record non conformances of parts made at our
company.  The main table (tbl_NCMain) stores the basic job info such as
customer, PO #, part number, qty made, qty rejected, etc.  ...

I'm altering the Contact Management template to better suit my needs.  I'v
added several new fields and queries, forms, reports etc. with out any
problems. However I am having difficulty changing the show/hide field
"button"on the "Contact List" form.  When go to show/hide fields ...

Question regarding both 2003 and 2007 - it seems like in 2003 it was
important to have no spaces in the field name but that doesn't appear to be
the case in 2007, at least based on the field names I see from the field
templates. What's the recommendation?

I have AllSales table with following fields:
Product
FiscalQuarter
FiscalYear

Just took over a database and I am very new to Access.  I have a table of
Account Numbers, Names, and cycle group #s.  Users want to update the cycle
groups by entering the account number. I implemented a switchboard that calls
a form that uses a query (criteria [Enter account #] ...

I need to simply read one record from a single table in Access using VBA.
Is there an alternative to using a RecordSet?  
Is there a simpler method that doesn't require as many lines of code?
Thanks,

Hi!  I have linked copied databases before, but somehow I am having trouble.  
I have my datbase (front and back end) on our S drive.  Ok, so I need to do
some modifications, so I copied and pasted the front end and back end
database to a Flash Drive.  I open the front end of the ...

how do I add fields to the order management access database. This would
include the buttons also.  I like the order management data base found in the
templates, but i want to add a few fields ; catalog number, item number,
campaign number, and how man returned (inventory on hand) ...

I am currently using Excel to keep track of numerous projects and variables
for a growing branch. Would Access be a better fit for this? If so, how do I
start? I have been reading up and making small tables but I need a larger
database. Any help would be appreciated.

Good Afternoon,
I have a database with one table called Referring Providers. I have a
control, "referring provider id" which I defined as an autonumber and primary
key.

I just created a simple macro that runs a query in MS Access 2003. Is
there a way that I can create a keyboard shortcut for this macro? I
tried using ^o in the macro name field and that did not seem to work.
Thank you.