I cannot now use the paste function from information in one cell to another,
or paste in the search function dialog base,  when copying from 1 table to
another, and from one database to another with my mouse, or menu bar. It
doesnt work in Excel, either - only the keyboard ...

How come when I link my tables in the relationship window, I never the
"zeros" that show you the many side and the "1" for the one side. I see this
in other examples but not my Access 2007. I use to see it in Access 97 etc
but not this version. Is thiera way I can set this ...

Hi can anyone help. I have a field in a table in my database which is
used  for fax numbers our old system used to have all fax numbers
prefixed with 9,  ie 9,01234 546785   our new system no longer needs
the 9, (new format 01234 546785) and I need to remove it.  many of the

Hi Robin,
I've got a bill from the Yacht Club for your absentee membership, $154.00.
Would you like me to pay this for you?
Keep having fun,

Sometime my access progs get an high cpu level.
How can I limit them, so the can only use 10% of the cpu?
Thx.

Is there a way to create an Excel file that lists all the fields for a table
and their descriptions (not their properties, but the spelled-out
descriptions that can be viewed in design-view.)
I haven't found an option for this in the Documenter or in the Export

I am trying to pull data from a table with a Query, which I have but now I
need to make it pull ONLY the first 4 numbers in a 8 digit string... Need
help on this if any one can assist

I am with a University and I have an access Database that I want to put on
their server but the IT people say that it is their understanding that you
can't secure an Access database with Access security tools (i.e. user level
security). To prove the point they took a program ...

Hi, there.
All was well until we put the db on a server and now have multiple users.
I have code that checks the Member's last name to see if there is a
duplicate entry.  Now that many users are entering Members, the code seems

I have been asked if there are any functional problems with a database having
only relationships defined by queries.  Will it be stable?  Will there be
issues and if so of what nature?  Thanks!

I have an access program that runs every night, started up with Windows Task
Scheduler.  At the end it saves the results into a memo field of a record,
and emails the text to the admin. before closing itself.  I try to trap all
errors, but occasionally I come in to find an error ...

I have a form with some data being displayed when I go to update the
form an update query runs asking I'm about to update 1 row and I click
yes. The Autonumber (ID field) displayed in this form changes but not
from say 1 to 2 but rather it jumps from 1 to 3. Any ideas why this is

Hello...
I've come across this in the past and now trying to do a simple export of
data to another db is doing it again.  I read records from one table, do a
findfirst to see if the record already exists in the new table, if not, add

I have the following table:  
code     Amount
a            10
             15

Hi Friends,
My Application is connected to MS Access database. I want to provide one
option as Backup and another option for Restore. I use Delphi 5 with ADO to
connect DB.