I am using a listview (MSComctlLib.ListViewCtrl.2)on an Access form.
Actually there are six listviews on the form. I need to do the same
thing to all six forms so I have the loop below. I would like to assign
each control to a listview object, however I get a type mismatch.

Hy all,
We have two databases with similar information (both, made with MS Acess).
Both, A and B, have - in some cases - the same information, names etc.
       Database A has the following fields.  (4,000 entries)

I am in the process of bringing my Access application to client's
server, and need some help!  The background is: I created application
(mdb) using Access 2003 on my laptop, converted it to Access 2000
(client uses both 2000 and 2003), split it into Front End and Back End,

I have a data entry form. I am trying to avoid users accidentally using
the mouse wheel and saving an incomplete record (or saving record that
skips the validation routine).
In Mousewheel event, I have a boolean variable (blnMousewheel) that is

On the Order form, I have a subform, OrderDetails, which contains every
item one customer orders. After the order is complete, I would like to
update the inventory amount. How can I enumerate the records in
OrderDetails subform?

I have a label on my form lblCount and the following code in my form for
displaying a record count:
Private Sub Form_Current()
Me.RecordsetClone.Bookmark = Me.Bookmark

I have a database created that has a field with many different entries in
it. Is there any way of getting a count of the number of each entry in the
field?
For example, if the field contains entries A, A, B, D, C, A, B, B, B can I

How could I find the primery key(s) if any in a known table?
Access 97 help doc seems to suggest it's tied to Index,
so, it's sort of along the line of
tbldef.Indexes(0).Index(0).Primary

I'm wanting to give my users some options in a datasheet view
* drag the columns around
* set the widths
* show or hide columns, etc.

I have a crostab query which does a count calculation. Everytime there
is a crosreference between a given row heading and a column heading I
get a count of how many crossreferences there are. Is there a way of
instead of getting a count I could have an X display? I tried putting

I would guess that someone has done this before, but I cannot seem to
get it to work. In a given month, there are hundreds of updates
received that need to be entered. It is obviously a slow and tedious
task to import them one at a time. What I would like to do is to place

Hello everybody! I am trying to find a link leading me to the FAQ but i can
not find one in the site. What am i doing wrong? Thanks for your time!!

I need some pointers/help on how to do the following if it possible:
In my access db, I have the following:
Tables: Products, Sub-Assembly, Product-Pack
Table, Products

I've noticed this a couple of times so far.  I created a database which is
stored on a server and is shared by about 6 or so users.  Sometimes, when the
file is opened, it creates another file called "db1.mdb".  When that file is
clicked on, there is a message "unrecognized database ...

Access 2002 default file format is Access 2000
Grrrrrrrrrr!
I just spent an hour getting a database out of StarTeam only to find
that only tables and queries came through because of this setting.