I am making some changes to an existing system, where a number of
fields on a form are coming out in a different color after data has
been entered. I cannot find any code that is doing this. I have added
a couple of new fields. The baffling thing is, some of them are

Field 1 is multiple copies of single numbers, ascending, related to table A;  
field two is unique date/time, descending, related to table B.  This table C
of about 1600 records sorts properly EXCEPT for 15 records (intermingled)
where field two shows ascending.  I have tried: ...

Sometime ago I created a database in Access97 and hide the database window
from the users. Since than I have converted to Access2000. Now I can not
retrieve the database window to make more changes.  Normally holding the
Shift key and opening the database brings up the database ...

What event is fired when the user moves between records?
Thank you,
Samuel

I'm making a hyperlink field to pictures in another folder. I'm working on
the db located on the server.  When my co-worker opens the db at his
location, the link works fine.  When I open the db at my location & try to
use the link, the link opens the program that opens the ...

Hi
I am new to this forum so be gentle with me!
Is it possible to create a numbering system within Access so that every time
you print off the same file it has its own unique number printed on the

I have this problem. I'm connecting to Navision native DB from AccessXP via
CODBC (unfortunately still 2.6). There is standard linked table. How can I
disconnect from Navision DB if I don't want to close whole application?

The following is apparently a known problem in access 2003 - an apostrophe
in the combo box item causes an error - how is it corrected?
Sandy
Private Sub Combo32_AfterUpdate()

My databases can contain attachments such as PDF, doc, xls, jpg. At
the moment I just open these within Internet Explorer but I would
really prefer to open them in the associated application directly.
I could have a big IF block to create an instance of the application

i want to put a picture in my data base so when i use the forms it will come
up with that spacific person.

When I type text in word, it goes right to the bottom of the page before the
page automatically scrolls up a little. As a result, all the letters with
'tails' on them, like 'p', get cut off.
I would prefer to still have some white space on the bottom of the page

I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
want only the first part, so whatever after the first space, i want to trim
it off. Is there a way to run an update query to do it?
Thanks...

is there a list somewhere of descriptions/definitions for the properties
listed on a field's property sheet?
i am thinking specifically of the properties for a text box in a form but i
am frequently unsure of exactly what a certain property does. ex: what is the

I need to do something simple.  How can I automate being able to
import a file into access that I get to select.   I have some files
that I want to append together, but the file names vary slightly each
week.

I am having a problem creating a msgbox, when data entered through a form
into a table is duplicated.  I would like for a msgbox to popup, and warn the
user for dupliucate data, before the actual data is entered into the table.  
I have an index for no duplicate set on a field in ...