For no particluar reason today, Access 97 is prompting for password to launch
the program. It auto-fills my LAN id and only requires a password. I tried my
LAN password as well as local admin credentials. I attempted to google the
solution to no avail. I have MS02K3 installed as ...

I'm setting up a database to store info on our Items.  One thing we need to
show is the Group(s) the item is associated with.  Some items are part of
only one group, some are in multiple groups.  Ie, a Widget is part of Group
"Pump" AND Group "Tool".

It worked (from examples) to created linked combo boxes from an access 2003
table, but when I try to do the same from a SQL Server 2000 DB table I get an
error from the SQL Statement Query window.  
This code works fine from an access table ...

I followed the advice in Microsoft Office Online for deleting duplicate
records by having one table with all records and another (a query) with
distinct values for fields which may be duplicated and a further field for
the field upon which I decide which record to delete. On ...

Can anyone help me figure out whats wrong with this expression?
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group")
Im trying to use it to calculate the percentages of each EthnicGroup of my
table.

I would like to set up a part number database using prefix (PL-, EQ-, etc.)
pull downs and suffex (-01, -02,  etc) addendums to part numbers.  I would
also like to place descriptions, vendor(s) (pull down menu) and vendor
information, buy / make, type of part number, etc to a new ...

i HAVE TYPED A LABEL LIST AND NOW i NEED IT IN ABC. ORDER

I have to implement some tables for our shipping department.  I know the
table that holds the shipping data in our system, which will be pulled from
the system using ODBC, but I have a few problems in figuring out the best
way to accomplish this task.

I am using ADODB recordset and has SQL server database. I have a ListBox on
the form and need to load large rows around 100 number of rows with about 12
columns. I want to do the same using couple of commands because it is require
to refresh the ListBox many times during ...

I have a table with a feild named "Ethnic Group" which has a pull down menu
with various choices (ie. Latino, Caucasion). Im trying to create a query (in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50 Caucasion)

I am working on a report I created to track training classes and hours taken.
I need to sum the hours in seven different categories to show the total hrs
taken in an employee’s anniversary year.  Some of the training categories
will have no training hours since the training does ...

I need to set up a database to include Owner and property details, visitor
contact details plus specialist group marketing and letter generator (Word)
Have 2003 pro, so latest bells and whistles available, but am wet behind
ears on database construction and no time to sit and ...

I need to be able to convert a JPEG so i am able to use/write over it in Word?

Hi all, need your assistance again, I have 4 fields on a form that are for
file locations/hyperlinks to a document.  If I install the runtime version on
a machine that does not have access, I cannot right click in the field and
edit or insert the hyperlink.  Is there a way to allow ...

It needs to give users the ability to access staff details (name, office
address, phone number)  firstly by job title then country then city. We have
several hundred staff!
I have not the faintest how to do this. However my pointy haired boss in her