I have a form and a report, I want to link the form to the report so when the
data in form is the same as the report. I am using the report for printing

I would like to import a single unique record from excel based on a 6 digit
number search and append it to my table. Anyone know the best way to do this?
Thanks

I have a Customer Orders table that includes the following fields as an
example:
customer
product  (socks, gloves, scarves, belts)

Why would the following query copy one record into the history file anywhere
from six to ten times?
INSERT INTO tbl_History ( ID, ADJTrans, DRMOTrans, RECTrans, SHPTrans,
ReceivedDate, ReceiptDoc, TransactionDate, QtyOnHand, UpdatedQty,

I'm trying to set up a New Blank Database (for the first time) and for the
File Name Location my book is telling me to browse to the  
Documents\Microsoft Press\Access2007SBS\ Crete Folder. Then click ok.  Well,
it does not show up in my Browse Folder Location.  I have no idea ...

i have this DCOUNT formula on a text box which counts number of training
sessions in my record. The text box is in my main form.
=DCount("[TSID]","Training Sessions","[TSID]")
how can i make it count the number of training sessions on the current month??

i cant set up my e-mail account on windows mail how do i do it

I am attempting to learn Access via the demos - but still need help - I am
setting up relationship between a Sales, Supplier & Customer tables.  When I
create a foreign field in these tables - do I need to populate this new field
manually? If the Access issued ID numbers for each ...

How much does it cost?

There is some need in our organisation for databases. Users are expecting to
see "nice" web pages to query databases and display results. They may also be
expecting to add and edit information in the database through some kind of
web-based view. Is Microsoft Access a solution we ...

I have two tables and a form:
Table 1
Id      products   pkg size     customer    addr   city  state  zip
Table 2  (set up as query)

I have two tables of customer information in Access which contain data that I
would like to merge into 1 new table labeled (2009 master mailer). The parent
table (2008) has historical data and includes some information similar to
table(2009), like customers information as well as ...

I need to change the DSN on linked tables. How do I do that?

I have a table in 2007 access and for some unknown reason the filter is not
recognizing all of the stores listed.  (it does not work in any supplementary
reports or queries either) And when I try to select only one criteria from
those that are showing, it does not filter anything ...

I have created, split my database, but have concerns about security on the
be, I have made the FE (mde) to place on each user's pc but i am wondering is
it necessary for me to create user accounts?