Dear Friends
We are in advertisement business -hiring own sign boards to our clients. our
boards are booked by clients on monthly basis at a perticular rate per
month. More than one boards are booked at once.

is it possible to have a query be filtered by a recordset so that when the
loop is on a record, it would filter the query from the current record?  For
example, I have a query that will list outstanding items by employee - each
record that the recordset runs through would be for ...

I have the following code to allow a zip operation to finish before moving
on in an Access 2000 form command button on_click event:
           On Error Resume Next
           Do Until oApp.Namespace(sZipFile).Items.Count = 1

I have a wonderful macro that determines visibility of certain fields
depending on the value of another field in the record called [region]. The
macro runs when the single form opens.
I need to have the visibility macro re-execute every time I press page down

I use date time picker to let user enter time and store data in my
date time type field.
I would like user enter until minuts,but not second.
The date time picker and physical data always has seconds.

I have a listbox with many rows one of the columns is price , is posible
obtain the sum of the rows in determinated column????
My listbox show this (example)
Item                  Price   Qtd    Total

I have a standard Purchase Order database, with a main PurchaseOrder table
(tblPO) and a related line items table (tblPO_Items).  These are represented
to the user as a form/subform.
There is a Products table (tblPO_Product), listing products according to

Is there away to get the crosstab information into a form in the same
way the crosstab is laid out?

In a query I have one field that would have a size of an object, i.e.
10 OZ, for weight of finished good product.
Now is there away to only take the numerical value of this and omit
the letters? I know left([fielda],2) works but some items are 1.25 oz,

I want to open a from B from Form A button.
Form B always open behind Form A.
Is it possible to force a form open always in front?
Your information is great appreciated,

I have a form and sub-form, where the AllowEdits property of the former is
set True (and therefore inherited by the sub-form on opening).  If the first
data entry is made to the main form then the need is to reset the AllowEdits
property of the sub-form to False, and vice versa – ...

I have a form that I have coded with a search feature. Currently when the
search doesn't find a record it just shows the first record. When that
happens I would like a prompt to ask if the user would like to enter a new
record. If the user selects yes then the form would show ...

There are 2 parts to this question and as I am new to advanced functions in
Access, please be explicit.
1--I have a check box field called [Note Complete] on a subform called [BHT]
that, when clicked, I want a popup message asking the user if they are sure

I hope some one can help me i have a few databases and they send emails and
my problem is that they all use the same email account but i want some of
them to use a different account. Is it possible if yes how at the moment im
using the sendobject which uses the account setup in ...

How can I set my form to update my fields as soon as a data changed?
I tried to do the AFTERUPDATE, BEFOREUPDATE, ONLOAD, but they are all not
doing it really. I have to close the form and reopen it for the code to work.
Can anybody help?