Hello! I need a query that will printout all of the column names of each
table. Someone has done it before but that person does not remember how they
did it. Can someone help me? Thanks. Denise

I currently have a database similar to the following (but with many more
committees):
Name               Asset Committee
Mike Smith               x

When running the following query in Access 2002, I am able to see my results
in the data sheet view, but upon attempting to save the query, the Access
application crashes.
SELECT UIMSMGR_UIBCINV.UIBCINV_CODE, UIMSMGR_UIBCINV.UIBCINV_MODEL,

I am new to writing code in access, but have managed to build a large
database, with security and the works. I've been pulling my hair out trying
to figure out something that is probably very simple, and would appreciate
some help.

I have 2 spreadsheets that have about 13 fields for each one. I would like to
link the information all together but showing each field for both
spreadsheets is this possible?
I only have 3 categories that are related...

I am attempting to collects data from a table and tally totals based upon
month/yr that its datestamp is.  What I need to do is somehow extract the
data for a certain month, say December, and total each months count for year
over year comparison. It might look like this:

Hopefully this is in the right forum.  Hopefully what I am trying to do
is fairly simple.  My employer has two simple Customer Paradox tables
that have a field that needs to be updated.  My only tool to use is
Access 2000.  I can link the tables easy enough however running the

I have a table which contains the following fields (which represent
results):
Score, Team, Opponents
I needs a query that will return the highest score for each team AND who the

I have a very simple query that is pulling all information from one previous
query.  I have a field called "Area" that I want to be a user-entered field
(the user will enter the specific area they want to see the information for).
I've done this many times, but some reason, with ...

I am trying to connect to a free table Foxpro 2.6 table from access
2003 using ODBC, Visual Forpro Driver 6.01.8629.01 and I get the above
error. If I open a database with the table already attached I can open
the table and insert, delete, ammend etc. It is only when I try to

Is it necessary to use action queries with user-level security??

I have two tables, one contains the highest score each team has ever
achieved - this has been manually built loaded from the leagues historical
records.
I written a query that produces, for each team, it's highest score of the

Can someone help. I need to retrieve peolple's addresses from a table.  The
only criteria I can use to identify these people is their ID number (an auto
number field), there are no similarities i.e. their addresses aren't the
same, and the numbers aren't consecutive.

Hi guys, bit of a tricky one here and I can't seem to find satisfactory
answers anywhere so hoping you can help.
I have a form which contains 7 parameters. 4 combo boxes and 3 text fields.
The user selects entries on any of the combo boxes or types text in any of

I need to update a bar codes field for hundreds of records.
Does anyone have a script that I can use to accomplish this in an update
query?
I'd like to generate the digits (not bar code graphic) on the fly.