I need help writing a query to display all boxes that are checked for
a particular record.  I have ten possible check boxes for each record
and each record will have different boxes checked.  Any help would be
greatly appreciated.  Thanks.

I have a form named frmCustomerWithJobs with a combo box with the
following rowsource:
SELECT ContactID, ContactName, ContactType, Phone, ContactTitle FROM
Contacts WHERE CustomerID=[Forms]![frmCustomerWithJobs]![CustomerID]

I have a company form that I would like to protect against duplication
unless checked. Main point being, that I dont want to just be able to
add a duplicate company name in a test box unless I need that for some
reason, which there are reasons. I need a bound or unbound check box

I am using ShellExecute to open JPG files with the associated application,
MS Photo Editor, from within an Access 2000 application. When the code is
run the first time (Photo Editor closed), there's a blinking in my
application title bar, and nothing appears. Then, if I do it a ...

How does one handle the situation where two different users are looking at
bound forms that display data from a table.
User #1 makes a change to the data, but User #2 is just perusing the data.
User#1 has his bound form updated, but User#2 does not.

I tested the install fileset on my laptop before leaving the
office. It worked perfectly.
My-App installation was terminated prematurely because
DAO350.DLL would not register in registry. So I booted into

Is it possible, and if so how would I read and import folder names
from a CD to a table?
Thank you for any help.

Does anybody how I can copy several fields into the clipboard. I have
copied the code of the following microsoft website:
http://support.microsoft.com/support/kb/articles/q210/2/13.asp
But with this code i can only copy 1 string each time into the

i have that code :  DoCmd.RunMacro "Boucle liste user 0", ,
"[Forms]![Form liste utilisateur]![Nom] Is Not Null"
I have converted the macro "Boucle liste user 0" to the function
""Boucle_liste_user_0".

How can i copy a table to a new table(structure and data) with primary
key remain
i have try to use Select * into table from old_table
However, i dont have any primary key which old_table have

I suspect the answer is "no," but I thought I'd throw this out anyway.
My background is in languages that support redefintion in
datastructures, something that I've yet to figure out in VBA.
Is it possible redefine variables something like this in VBA:

Hi, I have a set of comma delimited values in a text file.  They import
fine.  However, they are all in one record.  How can I get each value
on one record?  For example, say I have:
toys, books, shoes, houses

i have made a small database for pilots to log their flying time. i
want to set either some user permissions or startup options so that the
user might not see the database window nor he/she should be allowed to
access it anyway. i also want that whenever being administrator i want

I used the Database Splitter wizard in Access 2002 to split my database
into front end database and back end database.  How do I undo the split
and join them back into just one database. Thanks.

I have created a form called frmS2P with the following:
1 listbox called List11 which holds the contents of a query created off
my table called tblRequestActions. The fields which the listbox holds
are Request_ID and MoveNumber.