I am trying to write a simple form that allows a user to search
through an address table. The main form has the text boxes (to be used
as where parameters) and when clicking the search button will create
an sql string that is to be used as the recordsource for the subform.

Using MS-Access 2003 is there a way to conect to the Active Directory to
use the user accounts and security in an Access DB?

I want to have a memo field on a form which it is mandatory to make a
comment in.  My problem is that people often don't want to fill this in and
I believe that they are simply hitting the space bar a couple of times and
there is basically no comment saved, but it fills the ...

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?
Thank You

Anyone know why I'm getting a blank page between each group when I print
a report?
Thanks
DS

I'm trying to do query that will return all rows within the last quarter of
any year.
I've tried: "Between #10/1/????# And #12/31/????#" and I get an error
message:

On a form I developed, I want to do some cross-field dependencies.  If
field1 = "xxx" then field2 must be "yyyy" and so forth.  Apparently I
cannot do that in field properties via the validation as you cannot
refer to other fields in a form.  Right now I am doing these in a

There are many techniques and code snippets that will open a popup
calendar so that you can pick and insert a date into Access. However,
I have been unable to find a method to insert information and/or
display a full screen calendar so that the user can see activities for

Trying to create multiple acct reports based on the selection in a
list box.  I've set the list box for multiple selections, and in the
report data source, I have a SQL statement which is reading the list
box(when there is a single selection) but no luck with multiple

I have hundreds if not thousands of documents in various formats that I
have been asked to organize in such a way as to make it easy for the
people around here to search for them and to group them based on their
own criteria.. it seems like a pretty straightforward project.

Hello experts!  I hope to tap your vast knowledge of unbound wisdom.
Please help this humble squire in his search for knowledge.
Product: MS Access 2003
I have a report that basically lists the contents of a dB into

I'm making library db using SQL.
I have date when book has been loaned (Date loaned) and date to return the
book (Return date), which is 4 weeks.
How can I get current date to show in Date loaned-field?

I have a form with two pages - that is, the height of the form is
about two screen heights and it has a PageBreak half way down.
I move between the pages with:
    Me.GoToPage 1

I have a printer log that I need to manipulate.  Each row contains
document name and total # of pages in the document.  Document names
contain various 12 digit alphanumberic codes.
I want to make a report that lists all rows with a common code in one

I'm a relatively new VBA programmer but have been given the task of
repairing a database that currently appears with "3146 ODBC--call
failed." This happens when various criteria are input into a form
(called InvCredit), and then cmdProcess is clicked. Then we are asked