I'm looking for a book for learning Acccess 2007 with useful examples,
and providing in-depth explanations of relationship design.
Thanks in advance
Maria J

I'm trying to find out if it is possible to eliminate the scroll bars
associated with viewing detail data in the pivot table.  It would
seems that it would be more efficient with to view with the scroll
bars, but I have a associate that trying to eliminate them and wonder

I have a access database, i havea  form loaded with a customers name
and address
I have about 10 Standard letter writen in Word, what i would like to
do is a way on the access form that lets me clcik a button that it

I've developed a bound form in Access 2003 with country and product
dropdowns. On selection of country and product dropdown values the
corresponding stock details with order number, quantity and unit price gets
displayed in the form. Finally we placed the access .mdb file in ...

I understand that, if I want to trim leading and trailing blanks in a
string, I should use the 'trim' function.
But it is not at all clear to me how I should use this function to
trim all the entries in a column or in a table.

How do I get rid of old email addresses in the drop-down box.  Everytime I
try to email someone, their new email is also shown with every other email
address I have ever used for them.  Isn't there a way to delete these
obsolete addresses?

Please help with the subject request, thank you! I also would like help with
how you make a field a required field... yout help is greatly appreciated.

I was wondering if this can be done.
I will place the link name of delimited text file in a table1 in filed
name like  "c:\abc\test1.txt", "c:\abc\test2.txt", "c:\abc\test3.txt"
and so on.

I have set up several Combo Boxes that reference indexed (no dup) Tables.  
Whenever I make a selection from a bound Combo box list and try to save, I
get an error message that says I am trying to create a duplicate value in the
Index or Primary key.

Hi, Im fairly new to Access but ok with ASP. I need to build an Access
database to provide a booking system for 5 apartments such that for any given
apartment there can not be any clashes or overlaps on dates between clients.
Also to sort by dates to find availabiliiy.

I tried to import a code number with 16 digits - from Excel 2007 - in a
string field in an Access table (also 2007).
At every attempt, it came up in the table in a scientific format.
Can you help?

We are using Microsoft Access project (one for each user) to access SQL2008.  
Lately, I found out that as soon as a user closed the access project after
using it, an extra access database (.adp) was automatically created:
adp1.adp.  In other words, if a user got access to the ...

How do I delete daily activities planner from my yahoo page.  It keeps
freezing my computer.
Thanks LKB

I have distributed an Access application (still using Access 97) for
over 3 years. In recent weeks we have had error reports from several
new users. The program opens correctly with a splash screen but when
the user clicks 'Check for program updates' a fatal exception error

Using Access2007 SP2
Here's how to duplicate this weird error (looking for suggestions to fix or
workarounds):
1. database with two tables tblContact and tblDonation (normal design with