I want to use a pop up, modal form instead of a subform and want similar
functionality to a subform.  I have made the form, button to open etc all ok
but I am having difficulty getting the subform to only show the records
realting to the current record on the main form.

I have a query for the rowsource of a combobox:
SELECT DISTINCT tblAircraft.DN FROM tblAircraft WHERE
(((tblAircraft.Program)=[cmbProgram])) ORDER BY Val(tblAircraft.DN) DESC;
and when I run this query I get the following error:

I want to use the following
=DateAdd("d",180,[Date Referred])
=DateAdd("d",90,[Date Referred])
=DateAdd("yyyy",1,[Date Referred]).

I am using a table that I improted from excel, but have done nothing else to
modify.  The erroro message state "cannot group by object with "*" in
statement.  I am doing this in a simple query and using no VBL.  What do I
need to do to be able to execute query?

I just setup a new computer based in English US and the
spelling seting in outlook express is set for French language.
It does not give me another option, that is the only one
at the settings.

When I am developing my program in Access I can use the copy/paste functions
with the right click, but, when I package the program for distribution using
the developer tools, the right click function is turned off.  I want to be
able to use the right click copy/paste function in ...

Hi I would like a window to pop up 3 months, (or 90 days)  from the date the
client is created just saying a reminder, is this possible? And how would I
go about doing this?

I have a number in an access query that when I export to excel it isn't
recognized as a number.  I have to then select all the numbers and format in
excell as a number.  How do I do this in access?  I see a format for each
field in the query but do not know what is the correct ...

Is it possible to edit the dialog box that comes up on a parameter query so
that it says something like "enter you zip" instead of something cryptic?

I have tblPerson related to tblAddress via a MxM table tblPersonAdres.
Referential Integrity and cascading deletes work fine. Except when I delete
a record from tblPersonAdres which links PersonA to AddressA. If that is the
only linking record where addressA's ID was present, ...

Hello I have a button that clears the form so the user can enter a new
client's information. However I would like to have the ID come up
automatically to the next unique id in the list.
Here's some code I came up with however I have the SQL and Visual Basic

I have seen different ways this question was answered but it seems to
be a different answer based on the way the databases are set up.
I have 2 databases 1 with a list of names and id numbers,the other
database with information about the names.

Hello all, you have been an invaluable source of help for me in creating my
database, it is simple db for small office of five.  I have it on 2003
server. How can I become db administrator and allow others in office to work
in it at the same time without changing much of ...

I want to add code to a command button to check for an entry in a table
“tblDownTime” for the current date in the field “date” and for a specific
ride in the field “ride” ‘which I want to hard code’ if found then check if
the field “safety” is null. If it is not null then I want ...

After Jeff Boyce opened my eyes yesterday I started normalizing a
hierarchical cost category sctructure and trying to find an intuitive GUI.
Now it occurs to me why I've kept avoiding this path ;-)
This is what I had: