I'm working on a small application and I am stuck on the logic behind
one of the queries I want to write. I've always considered myself to be
a good problem solver and it depresses me that I can't figure this out.
I don't really need any SQL syntax or anything, just help with ANDs,

I have a form (frmSelectIndustry) that I use to determine which filter
to apply to a forms recordset. I want to reuse this form for other
parts of my application and I am trying to rewrite the code so that it
can have more than one use. Currently I store selected items from a

Moin zusammen,
ich habe zwei Probleme:
1) Ich will ein Listenfeld aus einem Recordset füllen und einen
weiteren Wert "(Alle") hinzufügen.

I am trying to format an address so that if the Billing2 field is empty
it skips it and doesn't leave a blank line on my report.  I tried
putting
me.Billing2.visible = not isnull( me.Billing2.value )

Dear people,
I am a newbie with Acces.
Just now I have created a database with all my customers. I would like to
send them e-mails about offerings and sales etc. I have no idea how to send

I have to manage an Access application, developed by a sequence of unknown
programmers, that grew up out of control.
It contains hundreds of queries, forms and reports most of which are dead
code. Now I'd like to do a major clean up and I'm looking for a tool that

I have an access query which gets data from a number of different
tables. Although the tables have primary key fields, the order in which
the records are returned means that none of these are in ascending
order in the query result set. I need to include in the query a field

I know I can use Inner Joins in an Update query like this:
UPDATE DISTINCTROW tblA INNER JOIN qryA ON tblA.SomeID = qryA.SomeID SET
Flag = 0
WHERE (Flag = -1);

This is driving me crazy!! I am getting an error 'MS Access can't find
the form 'frmVendorsMenu' referred to in a macro expression or visual
basic code.'
The form name is definately correct - can anyone spot what I am doing

please help
I have a table with member details and another one to many table used for
payments.  The problem is that the foreign key is not saved into the payment
table causing the table to not relate.  I have the relational tick on.  If I

Hi  all ,
I had created the following  Form/SubForm structure :
MainForm
      SubForm A (SubForm of  MainForm)

If a user fills in some fields on a form, then decides not to enter the
record, what method is used to cancel the record? Everything I try, still
adds the record to the table.  I'd just like to close the form, but "Close"
adds the record.  If the Command button is set to "delete" ...

I'm trying to populate an array with the records from a recordset. But
I'm getting an error. Here's the code:
Dim db As Database, qd As QueryDef, rs As Recordset
Dim MyArray() As Double, i As Integer

How can I consolidate these two tables into a single view?
Current:
=TableA=
fldP

I have a MSAccess 2000 database that adds peoples info from the
database to Outlook Contacts using Automation - this works fine.
Problem comes when entering a birthday field to Outlook - What happens
is that this creates an automatic reminder which is added each time I