I'm working with a database that was created by someone who no longer is with
the company. We use it to keep track of our construction equipment and when
it was serviced. We have  a equipment table that has relationships with other
tables based on the type of equipment. For ...

Is there a way to both round and replace a column of numbers?
I have a user who has multiple columns, that contained formulas,
so I inserted and copied them to get just the values.
Turns out, the values are decimals, and that he was rounding.

I have a check-box field to determine whether or not to print a mailing
label for a person.  Once the label is printed, I would like Access to
automatically clear the check-box.  Is there a macro that I can create to do
this?  Or some other method besides the check-box clearing?

Hello... please help with solution.
col1   col2                          col1    col2   col3   col4
1001 1001             to          1001  1001  1002  1003
1001 1002                          1004  1004  1005  1006

I am capturing data into a text field via barcode using a handheld scanner.
The barcode is on a US Postal Form (Customs number). I am having no problem
capturing the information, but was wondering if there anyway after the data
is scanned into the field to issue automatically a ...

I have designed a form with a text box.  Switchng back to print preview, the
text is dispayed correctly in the text box.  However, when you actually print
the form, the text is still in the correct position, but the text box is
undersized and printed well away from where it is ...

So a query was set up to output certain data, my problem is, I have a random
extra number in only one of the tables.
In the field I have a column for the count, and another column that averages
the count dividing it by another field on the table. It looks like

I'm working on an input form (Access 2000-2003) and have some check boxes.  
My question is, is it possible to set the check box to a text response rather
than a yes/no response?  If so, can someone please walk me through how to do
it.  For example, one is labeled "In-house ...

Can someone please tell me how to insert a formula.  I have a training dates
that were completed on 1 jan but in the next column i want to be 15 months
later to whatever date i enter in the 1st colum.  How do i do this?  thank
you!

I would like to print a list of all of  ' my documents.'  Would someone
please advise as to how I would go about doing this?  
Thank you in advance.

When I try to open an image using the right click, open with, select a
program function, Vista doesn't offer me my Photoshop. I browse for it and
click on the program exe and click ok and then it's still not there. I can
start Photoshop and open the file, but I'd like to be able ...

I need to do two things 1st to identify numbers that are duplicated in a
column part of a query. In a separate column same query I would like for it
to indicate which rows are duplicated (E.G. Dup, Not Dup). The rows has a
column with  date/time stamp with a format of  08/22/2007 ...

We have an Access 2003 database that resides on a shared network drive with
plenty of resources.  About 40 people have their own copies of the database
and sync up with the network.  Yesterday afternoon, an "Out of Memory
Error-Please close other applications etc" started ...

I have an access 2003 database sitting on a file server. I am on the
only one who has access to this database. When I open it, I tell me
that it is "read only"
I have made a copy in the same directory and this database opens fine.

I have a set of whole numbers (counting numbers) in tbl_WN.  There is
a field [Is_Prime] that indicates whether the number is prime.
I would like to create a set of prime numbers, then randomly call any
number from that set.  Based on what a user does on a form, a random