I am able to copy but the paste function does not work.

In Excel we have the option to set a cell as a Fractions to change
a number form 3.75 to 3 3/4.
Can we do the same in Access ????

Whilst looking through one of the tables in my database at work I noticed a
record that had   '#Deleted'   as the value for every field.
Could anyone shed some light on this ?
Two users were logged on and using the table (through forms) at the time.

I have a shortcut to my database on my desktop.  There's no problem getting
into the database from her.  As soon as I attempt to get into the database
straight from the access file it says, "Could not open table "MSysAccounts"
in the workgroup information file."  I tried creating ...

OK, so I know the basic trick for finding values on the left side of a
relationship which are not in the right side: use a left join and test for
null in the right-side field. Works any time the relationship is directly
between two tables, either many-to-one or one-to-many. I'm ...

How do I increase the table cell size in Access grater than 255 characters?

How do I create a drop down menu from a table in a form?

Let me explain my situation and tables real quick and then see if anyone can
suggest a better way to set this up.
tb_Contract has Primary Key fields: Base_ID, Contract_Number
tb_DO has Primary key fields: Base_ID, Contract_Number, DO_Number

My original table is like this:
Book_Index    Translation1    Translation2    ...    Translation5
<Integer>        <Memo>          <Memo>                 <Memo>
There are total 40,000 records x above 6 fields.

I am tring to design a database that allows me to track an event that occurs
each year. The event only happens once a year. Several venues (separate
locations) participate in the event. Venues have some information (address)
that will not change from year to year. Each venue that ...

Sorry this is long...I am trying to recreate Month End reporting which
currently is done in Excel only it requires manual data entry, the copying
and pasting of formulas, moving columns of data, etc., every month. Quite a
mess if you ask me. This is for a large medical department ...

Anyone know of an online list that has all the possible syntax for the
Alter Table command?  I need to know how to make a field  a text,
numeric, currency, double, etc...  Also, how to set the length.
Thanks in advance.

The other forum couldn't answer this so I try here.
Some background
1 master held locally (~72 MB)
15 replicas sitting on multiple data servers across country

I'm using access to track a document through a multi step review process.  My
table has a yes/no for when all reviews are completed.  I've created a form
based on my table for users to easily check the review status of a paticular
document and also make updates as necessary.  Now ...

I have three different parameters I  need to query. The first is a
classification such as 7.75G, 8.25A, 6.50E, etc. The second parameter is a
size range for each of the previously  mentioned classifications, 1000-1250,
1251 - 1500, and 1501 - 1750. The next item is cost based on ...