When i bound the other form in my main form. The whole first subform
area is covered with white color. But when i bound another form its not
shows the whole area in white color. Why my one subform shows the whole
area in white color. I mean its nothing shows any thing in that area.

I have a simple table, with only the following fields:
- Key
- MyDate
- Price

I have a form, pulling data from a Products table that has many fields
that do lookups to other tables. These are in a one-to-many
relationship to a pk in each of said tables.
I'd like to be able to compare the data on a BeforeUpdate event to be

A couple of quick questions:
Does MDE require licensing?   Can I create and EXE from it?  Can it be sold
without having to purchase Access?
Where can I find this information on Microsoft's site?

I'm hoping the answer to this is that I'm just doing something silly,
but I'm really scratching my head over this one.  I'm importing data
from multiple workbooks, each workbook has a sheet called SubSAT and I
need to get specific data from that into the database.

Here is my expression
=DCount("[Buyer ID]","tblDownload")>2
I would like to know how many records (including this one?) contain the same
'Buyer ID' as that in txtBuyerID on my report, is this correct ?

hi !!
i have trouble with reference in VBA
pls tell me the way to reference one field in code VBA
i used "table!<table>.field.<field> but errored.

I have a continuous form with a list of items from a table. One of the
fields in the table is "print". this allows the user to select items from
the list on the form for printing in a report. on that form i have a button
with the following onclick event:

This is my third question about eliminating accounting entries in a
clinical database, yet retaining the valid record. Latest wrinkle is
being able to sum the visits to the doctor, and the units of services
received. The units cannot be less than the visits, you get a least one

In a query's where clause I have:
Transactie.Rentedatum>#1/15/2005#
In stead of 2005 I would like the query to pick the year of the date the
query is being run.

Has anyone toiled with creating/using alternate domain aggregate
functions?  I have been messing with that a little.  The one
recordsource I have been working indicates I get 20 to 40% savings in
processing time.  I have not tried this with different recordsets yet.

I have my site hosted in the US and I use access as the database.
when I try to run a simple query like:
welect * from names order by surname
the results are not correctly orders according to the hebrew alphabet.

The statament below does exactly what I want it to do but I don't understand
why?
In my mind the subquery produces a result set which is a subset of the
handset table which the initial part of the query is then applied to.

Is it possible to have a data entry form where the information is
stored in several different tables (5 or 6)?  I have an inventory
database where Table1 stores all of the data common to all entries,
Table2 stores only the extra info relevant to items that are TYPEA,

If I run MsgBox "Wow!"
and I see text in the title
bar - where is that text
string setting coming from?