I am using a database to which 10 telemarketers are
connected.  When I run a query with specific criteria I
get a number of records that fit the criteria.  
My first counts those records, giving me an "x" number

i have a database that is split and i need to update 1 form in the frontend
(one line of code only!!!) and i would like to make this change without
requiring the users to download & install a whole new front end - any ideas?
unfortunately they can't get to "file / get external data ...

      I am using the Inventory Control template in Access '03. I made a form similar to the Purchase Order for
called Issue Order ( it enables me to issue items in stock to custodial and maintenance personnel). When I try to
preview the order in a report using a command button I ...

I'm working on a record-keeping system for a traditional Chinese
medicine practice and am trying to work out a way of recording the
needle points used in each individual acupuncture treatment session.
I've got this working on a form/subform where the acupuncturist selects

i have a few users who use a split frontend / backend database in access
2000. the database is beginning to feel a little clunky and slow to the
users.
the database on the clients is 5mb and has been compacted and repaired -

How do I use a Yes/No button on a form to set the Yes/No value of a
specific record in a table?   I've got several of these buttons which
I'll need to place on a single form.   When the operator has checked the
relevant buttons I want to run an append query to add the record IDs ...

on an order processing form i need each order to be of all the same type
of products - each product is of type 1, 2 or 3.
i use a combo box to choose the product and can have multiple products
on each order .... what i want is if the user chooses a product for the

Why, when I try to debug a private sub in Access 2000 do I get the error
message "User Defined Type Not Found" on the line
Dim dbD as DAO.Database
Steve

I have had problems with word in my documents I am not able to cut ans past to transpher info from one file to anothe

on an order processing form i need each order to be of all the same type
of products - each product is of type 1, 2 or 3.
i use a combo box to choose the product and can have multiple products
on each order .... what i want is if the user chooses a product for the

In a work database a module allows a series of calculation which produces a
result of the number of hours worked, but I am unable to carry out any form
of manipulation on it. It will not even sort Ascending / Desending order.
I am told this may be because it has been produced "as a ...

I have a database that has a linked .txt file in it. I
have it pulling this text to populate the data fields in
the database. This file is located on a server with the
rights open to all. I am using this text file to get

assume I have a table with a bunch of recorsd in it ... I
have say 200 columns in the table.  All fields/columns
are null (as in vbNull)... except the 1st column which
has an ID in it... Does this take up significantly less

I am trying to compare a database with a dept. and shift field to another database with that has the same two fields to see if they match.  It will then return an email address from the first table where dept./shift did not match.  Any ideas on how to write that?

I'm drawing a blank on how to do this.
I have a table (orderdetail)with order numbers and detail
info.  
I have a query (ordernumberquery) which has the order