All,
       I have the following function which is returning an error which I
have found to be due to the criteria of the SQL. Could anyone offer any
suggestions on how I can achieve the same results by using the results of a

Thanks in advance! I have an un-secured database that I can see which
computer name is logged-on but not the user. I have an error module
that can get the user name. It writes to an error file.
What I'd like to do is to have an invisible error generated that would

Hi There
Is There A Way To Add a Treeview In Access Form To Show All And Su
Accounts Where Sub Account Can reach Upto 5 Sub Accounts
Th

Hey Gang, I'm gearing up to retool for the upcoming deer season here in
Ohio and I could use some help with very general questions about
direction. I will be scanning nearly 210,000 forms that capture deer
harvest information. We use Verity's Teleform V9 enterprise to capture

I am trying to search a table of emailaddresses  records (tblMails -
slightly more then 7000)for
the occurance of words which are stored in another table (tblFilterwords-
aprox 3000 records) using DAO.

Anyone with know the best way to do this one?
I have a form that is unbound (i.e. in its properties the form itself
is blank for the datasource). I have a combobox named "cboDBName" and a
textbox named "txtPathName". The combobox has as its datasource the

I have an on click event in my acces 2000 database which open word and
prints a mail merge document.
This action is hidden and prints several copies of the document without
the user ever seeing word.

Either I don't understand (entirely possible), or there's no way to
copy parts of a class hierarchy from one instance to another.
Say I have a class called Foo, and it contains, among other things, a
custom collection called SubFoos.  If I do something like

I need some help please.  I need to show data as disabled but visible
on 1 of my forms that is linked up to another table.
For example:  I have 2 forms and 2 tables.  Form A is linked to table
A.  Form B is linked to Table B.  The cost field is from the

I have a table that has these two fields, company, lastname.
I want to create a query that when I type in the characters will return
all the values in the company and last name field that match.
So for example,  I have John Brown, and Brown Construction, two

Please point me in the direction of some good, free web based
resources\ documentation for information on developing the multi
select list boxes. Have made extensive use of the non-multi list
boxes in the past but am having problems locating good info for

The default window for forms is too deep to show the bottom record
navigation icons. I checked different workstations (hi-res, how-res, 15"
and 17" monitors) and it's the same -- a tad too deep. It confuses
co-workers, who have to maximize the form window to easily see the icons.

How can I set the left position of a form relative to screen?
Thanks
Regards

Hello friends,
My HR manager has asked me to make a global benefits database that
tracks the countries that we do business in for benefits that we offer
in a specific region. For example, in the US we offer a 401k benefit, a

I'm trying to find the best way to set indexes and primary keys on MSAccess
tables
What are the advantages and disadvantages of indexes and primary keys?
What fields should be indexed?