I would like to design a database.  it is a very simple database.
I want to enter information and then have it produc documents.  The
documents are templates and will be the same everytime.  It will help
reduce the find and replace kind of thing.

Here's a problem I've encountered with Access 2003 which has got me to
redesign how I get the row source in a second combo box using the first
combo box as a filter.
In Access 2002 and earlier the row source for the second combo was "SELECT

Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.

I'm trying to calculate for a report the previous year to date value of a
control I'm using this:
=DLookUp("[Sum of
txtDomfactot]","qryFDASalesV2","Year([txtmonthlabel])=Year([txtprevyr])")

What is the correct syntax to reference a form field in a query.  For
example, I want to pull data where field x of my table equals field y
on a form?
Thanks in advance for the help!

I'm trying to lock two fields on a form, but only for data
editing/deletion.  I want the user to be able to enter data, but once
it's saved, it needs to be locked.  Any help would be greatly
appreciated!

I am designing an application to be used by a book dealer and they
have asked if I could develop a function on the form where they could
use accented characters and other european characters. There are
roughly 10 characters they want to use.

TabControl on the right side of a form with two tabs:
Tab #1 contains two subforms that show some dynamic query results.
Tab #2 contains a ListView that gets dynamically populated as the user navigates
a TreeView on the left side of the form.

I have a query that returns a customers details on entering an account
number.
The query is on the account number field.
How can I get a list of customers by putting more than one account number

I have two tables: tblRecords and tblOptions.
tblRecords consists of RecordID (autonumber), Record (text) and Option
(text record of options chosen) fields
tbloptions consists of OptionID (autonumber) and Option (text) fields.

I stumbled over a strange problem in A2K concerning the Tab Order of 60
textboxes placed on a tab control: whenever I change the TabIndex of any
one of these textboxes the other 59 change there TabIndex RANDOMLY (I do
know about the renumbering mechanism, that supports you to ...

But all the functionality to create new, or edit copy paste etc has
been restricted. There is no security settings in place. Is there
anything i can do to get this functionality back??
JJ

I have values in a table that are represented on a form and subform. The values are numbers (typically 1, or .5, or .25, or .9, or .1, etc...).
I want to add all occurrences from the table as displayed on the subform and display them on my main form. I am able to do, however, when ...

Suddenly my current app has stopped issuing delete and save confirmations.
Tried it in another app and it still does...so I guess it's some app-specific
option setting....but I can't find anything.
Changed Name Autocorrect just yesterday - so that menu is a prime suspect...

I've dabbled in "Optional" over the last few days and think I'm coming down
against using it.
Seems to me like it makes the code harder to read and more complicated.
Instead of using Optional, I'm making the parm a Variant and passing Null when