Access2K. I have a report where in one column, for each record, it has one
of three values. What I would like to do is at the end of the report create
a summary that has three text boxes representing the number of times that
value occurred in that column. If possible, I would also ...

I've tried the 'Convert Database' option in 'Tools' but all I get is the
'Unrecognised Format...' error. I've seen several posts that mention opening
old Access databases in a new version of Access, but none the other way
around. Can anyone help me with this, please?

wonder if anyone can assist with my latest
problem !!! I've been asked to create a DB with a Calendar front end
so the first form is displayed like an outlook monthly Calendar. User
can then click on a date square and write a brief description of a tas

Is there a way in Access (or a freeware utility) that
allows me to view the relationship between objects (i.e.
which queries a form is using, etc.)?  I've tried the
Analyzer-Documentor, but it's not really helping.

I have an inventory database that I am working on for a small
maintenance facility.  In the "old" database, each part was assigned an
individual number.  The maintenance technicians are quite wedded to this
idea although they want the bells and whistles of a relational database.

I have a form with a combo box on it it is set to look up a record. all this works fine except being based on a table the list gets very long. (call it Property list) it looks up the names of buildings
I would like to have a second combo or list box (Call it Department as it has ...

I have just installed Access 2003. When I open a
database, I get a warning message about possible viruses,
which I override and open the db anyway.
When I do calculated controls in forms or reports the

cboBox values
I have a form based on one tbl and I have created a cboBox that wil
pull up a record on the after update event of the cboBox.
It works fine but i'd like it to display unique values since there ar

I have a problem using ceiling function in acces
for the given values i have to change them into multiples of
in excel its possible by using =ceiling($D1,6) where D1 is the say 1 and the result is
Before ceiling       after ceilin

Is there a way that I can have a field in a form notify
me if there are any duplicates, but still allow them?

My day job is working with ASP and SQL Server, but the boss has asked me to
help him out with an Access report question. I don't work a lot with Access,
so I'm hoping someone can help me out.
My manager recently upgraded from Access 97 (ack!) to Access 2003. He's

I have a form that display some information, and I can
navigate through the records by using the nav-buttons at
the bottom.
Now I want to add a button that makes a copy of current

I'm at an impasse!  I have a form associated with a table.  When the
database is opened I have it set so the form opens first.  Somewhere
along the way I did something wrong however I can't seem to go back
and fix it.

can you please help me
i am new at using access
i have created a form that accepts user input for components
what i want is to have the user select a component from a list and on doing

I am working on a form where I am trying to automatically fill in the users
name and Employee ID at the top.  I have a module "fOSUserName" that I got
from this group which provides the Windows Login Name.  I also have a table
called 'Employees' which contains all the needed info ...