I have a dropdown in form1 that is controlled by column1 in table1. Column3
in table1 groups each record into groups of 1, 2, 3, etc, with multiple
records belonging to multiple groups.  Is there a way to have the dropdown
limit what it shows to only group 1, or group 2, or group ...

I need to find the number of of requests for several states, I am using the
following:
=DCount("[Request]  ","Table Query","[State] ='NC' AND 'SC' ")
But it only picks up the First State i.e. NC

I have 1 ListBox and 5 MultiSelect ListBoxes on an unbound form. I have
written the code to generate the WHERE statement for a DoCmd.OpenForm
command. The problem is that the data being pulled seems to build on each
subsequent part of the where statement instead of filtering each ...

is there another way to stop a user exiting a form other than cancel = true?
maybe something on the lines of newrecord = false/ me.form.onexit = false?
any ideas?

Good Day!
I am trying to set up a generic and very simple object operation to see if i
could acheive something in this fashion.  i am trying to set up a 'dynamic
variable' and i am having no luck.  this is what i have so far:

Does anybody knows how I can do a conditional format on dates?
i.e. I would like to change the textcolour for every date between 01-xx-xxxx
and 15-xx-xxxx
where the xx stands for every months and the xxxx for every years...

What method would I use to loop through all the records of an unbound
continuous sub-form?
I understand that you can only use recordsetclone when the subform is bound
to a table or query.

I'm picking up a file name from a text field in a form and a foldername from
a query, merging it to something like "myfolder/myfile.doc" and
insert it into a table filed file_location as hyperlink. The field is
formated as

When trying to start a transaction with begin.trans and db.execute in Acc
2000 I always receive the error message:
"Couldn't start transaction, too many transaction open"
(this is translated from german).

Below is my code. I have a button that copies the allocation from one subform
to another subform on the main form.   I'm trying to do this...
if sumAllocation total > 100 then a message pops up that the allocation
cannot be more than 100, and then exit the routine.  But if ...

Hi, everybody. I hope somebody can help me. I new in Access, my boss
wants me to make some corrections to a database they used, and that an
ex-employee designed. I being trying to find files that can show me the
design window of the database, but i only  see the database as any user

Is there a way to have a command button not only exit the "current database
application", but to have it exit microsoft access also.
Thanks, Dan

I'm trying to write an if then statement where one value is null and the
other is not.  This is what I'm trying to write in words:
If name is null and comment is not null then pop up a message box, else
close window.  

I would like to know if there is a way to seamlessly prevent a form from
advancing to another record when the current record is determined to be
invalid or in need of additional information.
I've been looking at dozens of articles regarding record selection and the

I have a dillemma that is haunting me and several of my collegues.  We have 2
spreadsheets that are imported into A2k so as to run an unmatched query.  For
simple reference call then tblA and tblB.  They both contain the same fields,
Level, Code, CodeDesc.  The dilemma is tblA ...