Here's the deal...I have project numbers, each project number can have
multiple subjects and each subject can multiple technologies.  I have a form
running off of a query.  On this form I have three combo boxes: Project
Number, Subject, and Technology.  I wrote a macros for each ...

I'm trying to open a report from a form, and set up a "Where" statement
for that OpenReport command.
If a checkbox is True, then use the exact value from a form field as a
criteria.

Hi again :-)
Am i pusing the enevelope to far this time
with the following code?
Dim strSortUsing As String

I would like to have multiple entries for one person . I want to add new
entries to the old ones without erasing the old ones. How can I do this with
Access?

I'm working through my first database.  I have about 1100 records, and if I
want to build a query (and ultimately a report) that gives me only records
meeting a certain criteria, how do I get the query to "ask" me for the input?
I am tracking employee locations at multiple sites ...

I created a report and subreport from two different
and unrelated queries. One groups monthly sales by
customer for a few of our best customers. The second
query groups our largest customer monthly sales by

I have documents with Nested If Statements, using Word 2003 - through Citrix.
Example 1: { If { MERGEFIELD Prime_Officer_Fax }= "" "Office Fax: "{
MERGEFIELD Company_Phone_Fax } " "" }
that works initially, but often will cause a loop - creating errors for my

Have been an intermediate user of FMP for years.  Want to learn to do the
same things in Access.  I think I've got the basics of Access.  Anyone out
there with knowledge of both Access and FMP?  Would love to chat.  Thanks in
advance.

i change my mind to reformat my windows XP service pack 2. update success.

I've seen this description of a join used several times in recent posts.
Anyone care to give either a definition or references?
Thanks.

I have made a form on which there are nine groups of seven characteristics
describing a product.  They are all text boxes, and the page is clutered.  
For each product at least half of the groups of text boxes are blank.  I want
to make the first text box be the deciding factor in ...

Is ther in the query in Access possible to create a parameter that present
you a list in the parameter box popping up, so you don’t have to write the
criteria but only to choose it.
Anyone who knows how to do this if it is possible, will you then please help

Hi gang,
From the example Northwind Traders...
...is there a way to minimize the "Database Window" upon loading?  When you
load the sample database, the about box comes up but you see the database

I want to create a message box with the following message: "Add/Change
record"? I also want the message box to include an 'OK' and 'Cancel' option
buttons. I am not familiar with VBA code so I find the task of writing code
daunting.

Greetings Guru's
I have a database which I have written that is used to generate invoices for
customers of our auto repair business.
On the Jobs form, there is a combo box for looking up and retrieving the